1. Emily Gibson
  2. PowerBuilder
  3. Thursday, 24 September 2020 17:00 PM UTC

Hi....We have several applications that use PowerBuilder.  One application stores all PDFs in an Oracle database.  We are being asked by the DB unit to find a new place to store the PDFs because they are taking up quite a bit of space.  

Someone in my unit suggested FileNet.  Is there a way for PowerBuilder to connect to FileNet?  I've never used FileNet but others in my unit have.  So I'm not sure what questions to ask about it but believe I'll need a Web Service if this is at all possible.

Any ideas or help would be appreciated.

Thank you.
Emily Gibson

 

 

Accepted Answer
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 24 September 2020 18:08 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi Emily;

   FWIW:  Most PB customers that store images outside the DBMS just store the PATH and FileName of the image in a DB Table. Then at run time, use that information to point the PB App to that file server location. That way, you can offload the DBMS yet provide an easy & free external solution without having to refactor your App code hardly at all.

   If you need your images compressed even better on the file server, you can change the image format and add better image compression by using the free ImageMagicK open source software to your image handling.

Food for thought.

Regards ... Chris

Comment
There are no comments made yet.
mike S Accepted Answer Pending Moderation
  1. Thursday, 24 September 2020 20:10 PM UTC
  2. PowerBuilder
  3. # 1

You can also use blob web services to store blobs.  I use azure, but AWS has one as well.

just need to call the service using REST api calls. 

 https://docs.microsoft.com/en-us/rest/api/storageservices/blob-service-rest-api

 

another alternative is to store them as files on azure file service.  probably a lot of network setup to get that to work though.

Comment
There are no comments made yet.
Emily Gibson Accepted Answer Pending Moderation
  1. Thursday, 24 September 2020 18:27 PM UTC
  2. PowerBuilder
  3. # 2

Chris,

Thank you for your quick reply.  I will pass this along to those who make decisions.


Emily

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.