6 Replies Latest reply: May 19, 2014 6:35 AM by Test Screen Name RSS

    PDF from SQL data

    Community Member
    (Debbie_D_Saunders) Feb 16, 2009 8:55 AM
      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?
      • 3227 Views
      • Tags:
        • 1. Re: PDF from SQL data
          Peter Headland Community Member
          Peter Headland Feb 16, 2009 11:39 AM (in response to (Debbie_D_Saunders))
          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.
          • 2. Re: PDF from SQL data
            Sheila Carlisle Community Member
            Sheila Carlisle Feb 16, 2009 6:25 PM (in response to (Debbie_D_Saunders))
            [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
            • 3. Re: PDF from SQL data
              Peter Headland Community Member
              Peter Headland Feb 17, 2009 7:46 AM (in response to (Debbie_D_Saunders))
              > 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.
              • 4. Re: PDF from SQL data
                LynnFredricks Community Member
                LynnFredricks May 6, 2009 10:03 AM (in response to (Debbie_D_Saunders))

                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.

                • 5. Re: PDF from SQL data
                  bsillustrator1957 Community Member
                  bsillustrator1957 May 8, 2014 7:38 PM (in response to (Debbie_D_Saunders))

                  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..

                  • 6. Re: PDF from SQL data
                    Test Screen Name CommunityMVP
                    Test Screen Name May 19, 2014 6:35 AM (in response to bsillustrator1957)

                    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.