Database connections

Connections hold information about the connections to your databases. You only have to do this once for every database connection you would like to use for a WriteBack scenario. The username and password of a connection are stored safely and encrypted in our back-end.

A schema is connected to one of the available connections. You can have multiple schemas connected to one single connection. You can simply state that a connection is the authorized path to a database server and one database to store or edit write back information via the schemas within the available modules.

Access to connections is restricted to admins or to users with the connection manager role.

ODBC

Snowflake, Databricks, and Teradata use ODBC for connectivity. To use these databases with an on-premise installation, you must first install the appropriate ODBC drivers and configure them using ODBC Manager on Windows or /etc/odbc.ini & /etc/odbcinst.ini on Linux.

SAP HANA uses ODBC for connectivity in WriteBackExtreme versions 5.5 through 6.1.3. Starting with version 6.2.0, SAP HANA uses JDBC instead, and ODBC is no longer supported for SAP HANA.

Databases with a special ODBC setup are shown below

DataBricksSnowflake