Our HR and Finance software backend is all in a Progress OpenEdge database. We would like to be able to use forms to retrieve information from that system while a form is being filled out.
Hi Blake,
We're working on it! The Forms development team hopes to expand database support to all ODBC-compliant databases in the future. Then, using one of the available OpenEdge ODBC drivers, you should be able to accomplish exactly what you've described. In the meantime, perhaps you can replicate the data from OpenEdge to SQL?
That's what we're looking at doing for now. Our HR/Finance software allows us to perform scheduled exports of information, so we'll do that and import it into a SQL database for now. Look forward to the additional ODBC features!
Yes, that's what we are going to do until this feature is implemented/added.
Bump.
Hey where are you at with allowing forms to connect to an ODBC data source?
We would like to retrieve user info from Active Directory via ODBC instead of using the messy and terribly inefficient Linked Tables solution.
/tm
@████████ I don't see Brett as a name I can select any more. Did he leave Laserfiche? If so I am guessing this is a dead thread. Happen to know if there was any work done for Laserfiche to work with OpenEdge ODBC's?
Hi,
Have there been any updates on this feature request for being able to add other data sources other than Microsoft SQL Server?
Thanks!
While I'd love for Laserfiche to be able to connect to anything, wouldn't it be simpler to find an ODBC driver that you could install? A quick web search reveals that there are a few available.