Establishing Connections to Databases

You can import and export tables into and out of your Rulex Flow either by selecting a file from your local file system or through a connection to a database.

Whether you are creating a Saved source or you are using a Custom source, you need to insert certain parameters when you need to connect to a database.

Tables can be loaded from the following databases:

  • SQLite

  • Oracle

  • MySQL

  • SQL Server

  • PostegreSQL

  • IBM_DB2

  • IBM DB2 AS400

  • Azure Synapse Analytics

  • Impala

  • Spark

  • Hive

  • Teradata

  • OpenText Gupta SQLBase

  • Microsoft Access

  • SAP HANA

  • Generic ODBC Connection

Rulex's technical documentation does not and cannot provide comprehensive guidelines on the use of third-party software, beyond how Rulex integrates with this software. Please consult the technical documentation of the third-party software itself for up to date information.

Prerequisites

  • you must have chosen if you need a Saved or Custom source:

    • If you are creating a Saved source, go to the Explorer, switch the Flow filter off and select Add new Database by hovering over the plus button.

    • If you are using a Custom source, open the Import from Database task or the Conditional Import task.

  • You must have installed the ODBC drivers (64-bit) corresponding to the database you want to import from.

Procedure

  1. Choose the database you want to connect to.

  2. In the Database Connection window, provide the connection information required, as listed in the table below.

  3. Click Confirm.

Connection Parameters

Parameters in bold are mandatory.

  • SQLite: Database Path, ODBC Driver, Additional Options.

  • Oracle: Host, Port, Service Name, Authentication (one of the following: Username/Password, Windows Authentication), Username, Password, Schema, Driver, Additional Options.

  • MySQL: Host, Port, Database Name, Authentication, Username, Password, Schema, Driver, Additional Options.

  • SQLServer: Username, Password, Host, Port, Database Name, Schema.

  • PostegreSQL: Host, Port, Database Name, Authentication (one of the following: Username/Password, Postgre Pass File), Username, Password, Schema, Driver Additional Options.

  • IBM_DB2: Host, Port, Database Name, ,Authentication, Username, Password, Schema, Driver, Additional Options.

  • IBM DB2 AS400: Host, Port, Database Name, Authentication, Username, Password, Schema, Driver, Additional Options.

  • Azure Synapse Analytics: Tenant, Port, Database Name, Authentication (one of the following: Username/Password, Windows Authentication), Username, Password, Schema, Driver, Additional Options.

  • Impala: Host, Port, Database Name, Authentication, Username, Password, Schema, Driver, Additional Options.

  • Spark: Host, Port, Database Name, Authentication, Username, Password, Schema, Driver, Additional Options.

  • Hive: Host, Port, Database Name, Authentication, Username, Password, Schema, Driver, Additional Options.

  • Teradata: Host, Port, Database Name, Authentication, Username, Password, Schema, Driver, Additional Options.

  • OpenText Gupta SQLBase: Host, Port, Database Name, Authentication, Username, Password, Schema, Driver, Additional Options.

  • Microsoft Access: Database Path, ODBC Driver, Authentication, Username, Password, Additional Options.

  • SAP HANA: Host, Port, Database Name, Authentication (one of the following: Username/Password, Windows Authentication), Username, Password, Schema, Driver, Additional Options.

  • Generic ODBC Connection: Host, Port, Database Name, Authentication (one of the following: Username/Password, Windows Authentication), Username, Password, Schema, Driver, Additional Options.

Search