Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Merging of PDFs stored in database

Posted on 2014-10-22
2
Medium Priority
?
281 Views
Last Modified: 2014-11-03
I have setup the database which holds info about customers orders and those orders are saved in form of PDFs and/or TIFFs in the database per client.

As part of monthly business procedures, it is required that all invoices for one customer need to be joined in one file and stored as a monthly file in PDF/a format in the database for the archiving purposes.

So, the issue here is that i need to create/implement some kind of automation where this merging will be done by running some SQL procedure.

How can i achieve this? Or is this even possible?
0
Comment
Question by:Haris Djulic
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 16

Accepted Solution

by:
Wasim Akram Shaik earned 2000 total points
ID: 40398547
>> where this merging will be done by running some SQL procedure.

I'm afraid, this process cannot be done via sql, infact I would say that file is an external object which would reside in operating system, so its better to go for other options outside of database..

Oracle BI Publisher(needs license if you want to use it for commercial/business purposes) has a facility to do so.. but I have never done this kind of thing.. But I am sure that its out of the box utility for oracle database.. You have to create external libraries and point them to your library path and build procedures around them to wrap them as a oracle object and can use them via sql.. but trust me its a tedious process..


>>How can i achieve this? Or is this even possible?

Refer to the Oracle Documentation of book binding(merging documents) using BI Publisher

http://www.oracle.com/technetwork/middleware/bi-publisher/bip-bookbinding-176639.pdf
0
 
LVL 15

Author Closing Comment

by:Haris Djulic
ID: 40421010
Thanks, this is good starting point for what i need..
0

Featured Post

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
In this article, we’ll look at how to deploy ProxySQL.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

704 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question