Solved

Merging of PDFs stored in database

Posted on 2014-10-22
2
274 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 500 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

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

622 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