DB Interfaces Overview

What Is a Database Interface?

Database interfaces are used to define connection details to a database that has a JDBC driver like Oracle, PostgreSQL or SQL Server.

A database interface includes the following details:

  • IP address of the database server and the communication port for importing data.
  • Database type like Oracle, PostgreSQL or SQL Server. The type of database influences the structure of the queries generated by the Fabric Studio.
  • Database name.
  • Connection’s authorization credentials.
  • Post connection commands.

Click for more information about Creating DB Interfaces.

Database Connection Settings

When building a DB interface it is very important that connection settings are defined accurately. Connection setting parameters depend on whether the interface is a DB interface or a Non-DB interface. The following fields are displayed for all types of DB interfaces:

Name

Database Filename

Active

When checked indicates whether the database connection is active during runtime. When a connection is disabled it is ignored by the server side.

Type Name

Database interface type, for example, Oracle or DB2.

Server

Host

Hostname or IP address of the database server.

In case of Cassandra interface, it is possible to define a list of IP nodes separated by ; sign for the establishment of the initial connection to the Cassandra cluster.

Port

Connection port used to communicate with the database. A default port is entered based on the type of interface selected.

Database

Database, schema or service name.

Note that for SQLite DB Interfaces, populate the database using the full path of the SQLite file.

For example: C:\SqliteDB\crm_db.db

User

Username used for database access authentication.

Password

Password used for database access authentication.

Custom Connection String

Default = False. When set to True, the Custom Connection string is editable.

Connection String

Connection string used by the client side. This is generated according to the database type. For example, for Oracle, the string consists of jdbc:oracle:thin:@:1521/

For Cassandra interface: the consistency and serial consistency level parameters could be set using the server connection string.

For example: consistency=QUORUM&serialConsistencyLevel=SERIAL

Min Connection Number

Minimum Connections

Minimum number of connections per interface allocated by Fabric per node that remain open throughout the entire time that the Fabric project runs.

Max Connection Number

Maximum Connections

Maximum number of connections per interface per node. Note that this parameter should not exceed the maximum number of connections allocated by the DB.

Schema Filter

Name of the Database schema to access. Required if more than one schema exists. The Schema Filter setting in the DB Interface filters the list of schemas to be used by the Query Builder and DB Queries.

Post Connection Commands

Optional - a list of SQL commands that are to be executed post JDBC interface connection on the DB interface.

Connection Properties

List of JDBC Connection Properties of the selected Interface type. This section is visible only when the selected Interface type has any JDBC Connection Properties.

Previous

DB Interfaces Overview

What Is a Database Interface?

Database interfaces are used to define connection details to a database that has a JDBC driver like Oracle, PostgreSQL or SQL Server.

A database interface includes the following details:

  • IP address of the database server and the communication port for importing data.
  • Database type like Oracle, PostgreSQL or SQL Server. The type of database influences the structure of the queries generated by the Fabric Studio.
  • Database name.
  • Connection’s authorization credentials.
  • Post connection commands.

Click for more information about Creating DB Interfaces.

Database Connection Settings

When building a DB interface it is very important that connection settings are defined accurately. Connection setting parameters depend on whether the interface is a DB interface or a Non-DB interface. The following fields are displayed for all types of DB interfaces:

Name

Database Filename

Active

When checked indicates whether the database connection is active during runtime. When a connection is disabled it is ignored by the server side.

Type Name

Database interface type, for example, Oracle or DB2.

Server

Host

Hostname or IP address of the database server.

In case of Cassandra interface, it is possible to define a list of IP nodes separated by ; sign for the establishment of the initial connection to the Cassandra cluster.

Port

Connection port used to communicate with the database. A default port is entered based on the type of interface selected.

Database

Database, schema or service name.

Note that for SQLite DB Interfaces, populate the database using the full path of the SQLite file.

For example: C:\SqliteDB\crm_db.db

User

Username used for database access authentication.

Password

Password used for database access authentication.

Custom Connection String

Default = False. When set to True, the Custom Connection string is editable.

Connection String

Connection string used by the client side. This is generated according to the database type. For example, for Oracle, the string consists of jdbc:oracle:thin:@:1521/

For Cassandra interface: the consistency and serial consistency level parameters could be set using the server connection string.

For example: consistency=QUORUM&serialConsistencyLevel=SERIAL

Min Connection Number

Minimum Connections

Minimum number of connections per interface allocated by Fabric per node that remain open throughout the entire time that the Fabric project runs.

Max Connection Number

Maximum Connections

Maximum number of connections per interface per node. Note that this parameter should not exceed the maximum number of connections allocated by the DB.

Schema Filter

Name of the Database schema to access. Required if more than one schema exists. The Schema Filter setting in the DB Interface filters the list of schemas to be used by the Query Builder and DB Queries.

Post Connection Commands

Optional - a list of SQL commands that are to be executed post JDBC interface connection on the DB interface.

Connection Properties

List of JDBC Connection Properties of the selected Interface type. This section is visible only when the selected Interface type has any JDBC Connection Properties.

Previous