These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

General question about DB's and Adobe Acrobat

khovanes
Registered: Dec 22 2008
Posts: 3

Sorry for the general posting... but I was not sure where to look... and I've been searching all over google for a lead... and it was to here...

I would like to populate a PDF with data from a database (either SQL Server or MySQL). I have a form with, say, 100 fields... these fields relate directly to columns in a database I already have populated with around 10,000 records. What I would like to be able to do is, when editing a record (in an application), add a button the the app, and trigger a dump of the current row to a pdf form, which would print.

What product should I use for this?

Thanks,

Ken

My Product Information:
Acrobat Pro 9.0, Windows
daka630
Expert
Registered: Mar 1 2007
Posts: 1420
Quote:
populate a PDF with data from a database
Try a "Search Forums" with Keyword search = "database pdf" & author = "thomp"
Thom Parker has a number of posts that may be useful.
As you would be putting data into the PDF you'll have to decide which forms method to use for your PDFs
(Forms: LiveCycle or Forms: Acrobat) as I believe this can make a difference in the "how-to".

Be well...

Be well...

lkassuba
ExpertTeam
Registered: Jun 28 2007
Posts: 3636
Here is a link to several examples of [url=http://www.adobe.com/devnet/livecycle/designer_scripting_samples.php]Working with data sources and schemas[/url] with forms developed in LiveCycle Designer.

If you're using Acrobat, check out [url=http://kb.adobe.com/selfservice/viewContent.do?externalId=333472]ADBC (Acrobat Database Connectivity)[/url]. This is disabled by default but can be useful in limited desktop applications.

Lori Kassuba is an AUC Expert and Community Manager for AcrobatUsers.com.