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

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

→ Mandatory

→ Optional