Populating a PDF form from SQL data.

[Sparrowhawk-AES]

I have used for years the ADBC connection to create interactive PDFs that create a work flow that has been very successful.  Now that it is discontinued I am looking to explore different options for Data exchange that can be used to populate forms.

[Thom Parker · Accepted solution]

There are a few options, but all of them require purchasing or writing an external application that handles the actual data transfer to the DB.

1.  The traditional method - submit the data to a server script that writes/retrieves the data to/from a DB on the server. This one is platform independent.

2.  Write a plug-in to connect to a local DB and export the data.

3. Use VB, C#, etc. to write an app that connects to Acrobat through the IAC and writes the data to a local DB.

Not recommended option:

4. Convert your form to LiveCycle and use the built-in LiveCycle DB connection.

[Sparrowhawk-AES]

Thank you Mr. Parker.  I like you No. 1 method.  I am going to explore this option.  This may be the best option for the development on the table now.  This seems like it would also lend itself to sign tracking as well.  Is there some documentation within the SDK that you might direct me to?  I am thinking the REST exchange might be the route or is SOAP a better method?

This reply was most helpful.