Re: Saving MS Office Documents into an Oracle Database?

Well, everything is hard to handle when it's TB sized. I heard that EMC is retiring Documentum?

Regards

On 6/12/19 10:40 AM, Reen, Elizabeth (Redacted sender elizabeth.reen for DMARC) wrote:
>
> We did that for years.  Blobs get hard to handle when they are
> terabyte in size.  We ended up getting documentum to handle that for us.
>
> Liz
>
> *From:*[External] oracle-l-bounce_at_freelists.org
> <oracle-l-bounce_at_freelists.org> *On Behalf Of *[External] Ilmar Kerm
> *Sent:* Wednesday, June 12, 2019 9:43 AM
> *To:* Oracle Mailing List <oracle-l_at_freelists.org>
> *Subject:* Re: Saving MS Office Documents into an Oracle Database?
>
> Just to throw in a small (internal only) use case where I did load
> many word documents+pdf etc into Oracle database... In order to use
> Oracle Text automatic filtering for full text search on document
> contents. It was just too easy to implement and no extra software was
> needed :)
>
> https://docs.oracle.com/en/database/oracle/oracle-database/18/ccref/oracle-text-supported-document-formats.html#GUID-0A0442FB-74BE-4639-933D-7510F5E74D50
> <https://urldefense.proofpoint.com/v2/url?u=https-3A__docs.oracle.com_en_database_oracle_oracle-2Ddatabase_18_ccref_oracle-2Dtext-2Dsupported-2Ddocument-2Dformats.html-23GUID-2D0A0442FB-2D74BE-2D4639-2D933D-2D7510F5E74D50&d=DwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=BV314ZOkmpaB90VcVKN1V1Udzt1dtpEYKHA1hvS6VwA&s=CCdL2qR6C0qne68SnoverbE0C-XHUnremCEFFoHUbA0&e=>
>
>
> On Wed, Jun 12, 2019 at 3:07 PM Kellyn Pot'Vin-Gorman
> <dbakevlar_at_gmail.com <mailto:dbakevlar_at_gmail.com>> wrote:
>
> Yes, Jeremiah was blunt about his POV on this topic, but as
> someone who’s fully immersed on the Microsoft side, we also don’t
> recommend storing MS Word docs inside SQL or Azure databases. 
> It’s not that you can’t do it, it’s just that you’re using the
> wrong tool for the job.  We have Sharepoint for secure access and
> apps, even Power BI apps to create a better access point for
> customers to work with documents outside of a file share.
>
> Jeremiah and Niall are correct-  storing word documents inside the
> database is a waste of a good RDBMS.  It’s also a nightmare for
> all the GDPR initiatives and other data governance coming down the
> pipe...:)
>
> Kellyn
>
> On Wed, Jun 12, 2019 at 3:52 AM <niall.litchfield_at_gmail.com
> <mailto:niall.litchfield_at_gmail.com>> wrote:
>
> I'm with Jeremiah here (though not perhaps his image). Windows
> shared file systems provide centralized secure access to MS
> Office documents for millions of folks. You absolutely *can
> *use the BFILE data type, but then you can also generate a URI
> for the file as well and store than in a simple varchar2.
> Anyone accessing the URI will be able to view/edit the doc
> depending on their corporate permissions in a native app.
>
> On Tue, Jun 11, 2019 at 7:43 PM Jeremy Ovenden
> <Jeremy_at_hireserve.com <mailto:Jeremy_at_hireserve.com>> wrote:
>
> Heh thanks for reinforcing your view with a useful image.
>
> Why would you store anything in a database? Presumably for
> centralised, secure access to data.
>
> *From:* Jeremiah Cetlin Wilton <jcwilton93_at_earlham.edu
> <mailto:jcwilton93_at_earlham.edu>>
> *Sent:* 11 June 2019 19:35
> *To:* Jeremy Ovenden <Jeremy_at_hireserve.com
> <mailto:Jeremy_at_hireserve.com>>
> *Cc:* Oracle Mailing List <oracle-l_at_freelists.org
> <mailto:oracle-l_at_freelists.org>>
> *Subject:* Re: Saving MS Office Documents into an Oracle
> Database?
>
> Sorry... just being annoying.
>
> The question would be: "why?"
>
> Oracle is a transactional relational database. Why would
> we keep MS Office docs in there?
>
> Jeremiah
>
> ------------------------------------------------------------------------
>
> *From: *"Jeremy Ovenden" <Jeremy_at_hireserve.com
> <mailto:Jeremy_at_hireserve.com>>
> *To: *"Oracle Mailing List" <oracle-l_at_freelists.org
> <mailto:oracle-l_at_freelists.org>>
> *Sent: *Tuesday, June 11, 2019 10:06:07 AM
> *Subject: *Saving MS Office Documents into an Oracle Database?
>
> Hi
>
> Not sure if this is a the right group to ask for this
> assistance – but my google mojo has failed me thus far.
>
> In MS Word you can save files to o/s but you can also save
> to e.g. Sharepoint and Teams – I was wondering if there is
> a means by which you can save directly into an Oracle DB?
>
> Any pointers gratefully received.
>
> Many thanks
>
> jeremy
>
>
> --
>
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
> <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.orawin.info&d=DwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=BV314ZOkmpaB90VcVKN1V1Udzt1dtpEYKHA1hvS6VwA&s=IUGMzQ7EHU0uV9UX_NZ4UpVtSRGwsdcz0Hub--coqJM&e=>
>
> --
>
>
>
>
>
>
> *Kellyn Pot'Vin-Gorman*
>
> DBAKevlar Blog
> <https://urldefense.proofpoint.com/v2/url?u=http-3A__dbakevlar.com&d=DwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=BV314ZOkmpaB90VcVKN1V1Udzt1dtpEYKHA1hvS6VwA&s=azMgWgib-go849CPR153IwZlVvKX7FpjR5gupdrZ8Cs&e=>
>
> President Denver SQL Server User Group
> <https://urldefense.proofpoint.com/v2/url?u=http-3A__denversql.org_&d=DwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=BV314ZOkmpaB90VcVKN1V1Udzt1dtpEYKHA1hvS6VwA&s=0ctsekdtTm4UimYK4drd2gAaS7T75A6bKWl8hU2T6ec&e=>
>
> about.me/dbakevlar
> <https://urldefense.proofpoint.com/v2/url?u=http-3A__about.me_dbakevlar&d=DwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=BV314ZOkmpaB90VcVKN1V1Udzt1dtpEYKHA1hvS6VwA&s=jxVYhOCUvnVk5WX6dTdkv6V6RZn5Ad6LMRkbMARDr3w&e=>
>
>
> --
>
> Ilmar Kerm
>

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217



--
http://www.freelists.org/webpage/oracle-l