Connect Liberty Create to an External Database

Liberty Create - Build Advice
1

Hello,

I was wondering if it is possible to connect Liberty Create to an external DB, in my case I would like to connect to a DB Oracle.

What I’m looking for is a way that Liberty Create saves/reads the data from an External Oracle Database.

For what I read, Liberty Create “just” allows us to access the BD via ODBC Views (so I can query her form an External SQL Viewer).

Hope you can help me.

Best Regards
Diogo Mendes

2

Hi Diogo,

It sounds like you need the Liberty OPA (on-premise adaptor), you can see a summary of it here:

Full details can be found in the Feature Note document:

Richard

3

Hi Richard,

Many thanks for your feedback.

With this LOPA is it possible the Liberty Create Forms write the data directly to the External Database or is it always need to build and use the internal database to link objects to the respective tables?

Best Regards
Diogo Mendes

4

Hi Diogo,

LOPA acts as a bridge into your network, exposing web service methods that Liberty Create can call to write data back to any database schema.

Once installed you configure the web method and define the SQL that will get executed once the method is called.

Richard