Difference between revisions of "Data Connectivity"
Barrymavin (Talk | contribs) |
Barrymavin (Talk | contribs) (→ODBC Functions) |
||
| Line 15: | Line 15: | ||
Visual FoxPro compatible remote data connectivity functions are used to handle connections to ODBC sources. | Visual FoxPro compatible remote data connectivity functions are used to handle connections to ODBC sources. | ||
| − | Full documentation for these ODBC functions can be found [[ | + | Full documentation for these ODBC functions can be found [[Category:ODBC_Functions|here]]. |
===Web Integration=== | ===Web Integration=== | ||
Revision as of 22:11, 7 December 2017
Under construction
Lianja has its own high performance database engine built-in. Unless absolutely necessary we recommend you use that database engine.
It also provides full support for working with MSSQL, MySQL, PostgreSQL and other SQL databases.
Virtual Tables
Virtual tables allow you to access external data via an ODBC connection, yet they look like regular tables in a Lianja database. You can drag 'n' drop virtual tables in the Page Builder and reference them in the same way as standard tables and all the time the underlying connection, SQL statements and cursor adapter are being handled for you.
Full documentation on Virtual Tables can be found here.
ODBC Functions
Visual FoxPro compatible remote data connectivity functions are used to handle connections to ODBC sources.
Full documentation for these ODBC functions can be found.
Web Integration
You can work directly with remote Web APIs and integrate this data into your Apps.
Full documentation on Web Integration can be found here.
