Integrating with SQL databases

Flowgear includes these Connectors for SQL:

• Microsoft SQL Query and Microsoft SQL Table Update
• MySQL Query and MySQL Table Update
• Oracle Query and Oracle Table Update
• PostgreSQL Query and PostgreSQL Table Update

It also include generalized connectors for ODBC and OLEDB

• ODBC Query and ODBC Table Update
• ODBC Query and OLEDB Table Update

Working with ODBC

1. Obtain and install the appropriate ODBC driver
2. Install a DropPoint on the machine you've installed the ODBC driver on
3. Provide a connection string that specifies the ODBC driver that you want to use (http://connectionstrings.com is a good resource for obtaining ODBC driver connection strings).

Common ODBC Drivers & Connection Strings

Firebird

Drivers are available at https://firebirdsql.org/en/odbc-driver/

DRIVER=Firebird/InterBase(r) driver;UID=SYSDBA;PWD=masterkey;DBNAME=C:\database\myData.fdb;

mySQL

Drivers are available at http://dev.mysql.com/downloads/connector/odbc/

Driver={MySQL ODBC 5.1 Driver};Server=your_server_name.net;User=username;Password=password;Database=database

For ODBC Table Update, use these parameters in the Connection:

• ParameterPrefix - ?
• AllowNamedParameters - False
• ObjectEncapsulator - leave empty
• SelectSql - select * from {table} limit 0

Pervasive SQL

Drivers are available at https://www.progress.com/odbc/pervasive-sql

Driver={Pervasive ODBC Client Interface};servername=server_name_or_ip;dbq=data_source_name

For ODBC Table Update, use these parameters in the Connection:

• ParameterPrefix - ?
• AllowNamedParameters - False
• ObjectEncapsulator - ""
• SelectSql - select * from {table} limit 0

HANA SQL

Driver are available at Obtaining the SAP HANA Database ODBC Drivers | SAP Help Portal

DRIVER={HDBODBC};SERVERNODE=server_name_or_ip:30015;UID=username;PWD=password