We help IT Professionals succeed at work.

How to pre-populate form fields in a PDF based on a database query

I have a PDF document that has many form fields to be filled out.  Currently users fill them out by hand, but I would like to make it possible for them to pre-fill the values based on a database search.  In a nutshell, I want them to be able to search the database for a desired account record.  Once they find the account record they are looking for and select it, I want the PDF to retrieve all of the data from the database and pre-populate the fields on the form with this data.

I am running Windows environment with SQL Server.

What is the easiest way to get this done?  I already have a copy of Acrobat Standard 2009. Commercial or open source software is ok.
Watch Question

Distinguished Expert 2019