Home Patterns Integrating with SQL databases

Integrating with SQL databases

Flowgear supports integration with Microsoft SQL databases directly through the SQL Query and SQL Table Update Connectors.

You can connect to other databases via either our ODBC or OLEDB connectors namely:

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