Adobe Community: Message List - PDF from SQL data

Re: PDF from SQL data

forums_noreply@adobe.com — Mon, 19 May 2014 13:35:01 GMT

You need to get the original software fixed, or change the software used. I'm assuming you are already using an up to date Acrobat. I can't think of another solution. A lot of software does things that are pathological when scaled up to 10,000+ pages. Including Acrobat, though there were significant improvements in 11.0.

Re: PDF from SQL data

forums_noreply@adobe.com — Fri, 09 May 2014 02:38:23 GMT

I need help on this same subject. I am being provided with PDF's from SQL (not sure what software). A 3000 page PDF comes out to 300mb, and if you open it and save as in Adobe Pro, it takes 10 hrs to consolidate fonts and images, but I then end up with a nice 30mb file. Even using batch PDF conversion software, it takes 5hrs on a good dedicated machine to flatten these PDF's. I'm guessing it has a lot to do with how they are handling font embedding and the image (form flash) on each page (same on all pages for each PDF). What kind of programs should I be looking at to keep the PDF file sizes manageable and where I can work with the files without it taking 10 hrs to save them. I print about 120,000 images per month.. We save the images for up to 6 months.. With 300mb files this won't work..

Re: PDF from SQL data

forums_noreply@adobe.com — Wed, 06 May 2009 17:03:33 GMT

Paradigma Software's Valentina DB Reports can generate PDFs from SQL data. This is an add-on option for most of the developer versions of Valentina DB. There are many companies using it for the same purpose you mention. Some of them use Valentina for all their projects, while others use a process where they dump data from Oracle or other big iron database into Valentina and then run PDF generating reports.

Re: PDF from SQL data

forums_noreply@adobe.com — Tue, 17 Feb 2009 15:46:31 GMT

> There is a product that will do exactly what you are needing.

There are many products that will do what the original poster needs. Indeed, I am the architect of one. I don't think this is the place to advertise individual products.

Re: PDF from SQL data

forums_noreply@adobe.com — Tue, 17 Feb 2009 02:25:17 GMT

[disclaimer: AxialInfo is a reseller of the product suggested below; for more information about Adobe FrameMaker please see the FrameMaker section of the forums, at http://www.adobeforums.com/cgi-bin/webx/.ee6b312/ ]

There is a product that will do exactly what you are needing. Miramo dynamically creates PDFs automatically, on a server basis, from database and other content, and is widely used in the Financial Services sector; it works with Adobe FrameMaker Server as the formatting and pagination engine.

More info is available at http://www.datazone.com or
http://www.axialinfo.com

Sheila

Re: PDF from SQL data

forums_noreply@adobe.com — Mon, 16 Feb 2009 19:39:34 GMT

You need a reporting tool that is capable of PDF output. Which of the many tools available will meet your needs will depend upon how precise the output format must be. Anyhow, this is not the right place to look - you need to research reporting tools in general.

PDF from SQL data

forums_noreply@adobe.com — Mon, 16 Feb 2009 16:55:20 GMT

I'm looking for a technology that will help me create multiple formats of similar data from an SQL database into PDFs. I haven't found a sales rep at Adobe who knows if any of their products can do what I need and they recommended the user-to-user forums.

My web-based application will generate financial affidavits. I need a different template for each state, so I need to create these templates without getting too much into the code itself. The templates will need to draw similar data about assets, liabilities, income and expenses from my SQL database, but the data will be organized in different places on the end document depending on the state. Each state's template (some states have different formats for each county) will also have different fonts, borders, and labels, so I want to be able to create these templates easily, without getting into the code.

Do you know of any Adobe or other technology that can help me do this?