Configure external connection (JDBC/ on-premise version only)

JDBC (Java Database Connectivity) is a common interface (API) for Java to access relational database management systems (RDBMS).
By registering the JDBC connection information for a database, CELF can connect to any external database other than those provided internally by default, and retrieve or update data.
External database connection via JDBC is available only in CELF on-premise version.

Register external database connection information

  1. Open 'Database connection management' tab in "Manage" screen.
  2. Click '+New Database Connection' button.
../../../_images/img_01.en114.png

Configure database connection information

  1. Input database connection information to register in 'Register database connection settings' dialog.
../../../_images/img_02.en111.png

[1] Connection type

Choose 'Server connection' in 'Connection type'.

[2] Connection ID

This is the name you specify for the external database connection destination.

Note

Set the unique name in 'Database connection management' screen list.

[3] Connection name

It is the name to be displayed when you select connection database in 'Table management' screen.

[4] Database type

You can select the following database type.

  • Oracle
  • MySQL
  • SQLServer
  • DB2
  • PostgreSQL

[5] Connection string

Set connection string for each database type.

Database type Connection string
Oracle //host:port/service name
MySQL host[:port][/database]
SQLServer host[:port][;databaseName=database]
DB2 host:port/database:
PostgreSQL host[:port][database][?currentschema=schema]]

[6] User name

Set the user name to use when connecting to database.

[7] Password

Set the password to use when connecting to database.

[8] 'Register' button

Register the database connection information with the settings you have made.
  1. Click 'Register' button.

Attention

  • Supported databases are MySQL, Oracle, SQL Server, DB2, PostgreSQL.

    The objects to be displayed are as follows.

  • MySQL … Tables and views belonging to the specified database (schema).
  • Oracle … Tables and views belonging to the specified user’s schema.
  • SQL Server … Tables and views belonging to the specified dbo schema.
  • DB2 … Tables and views belonging to the default schema when connecting to the specified database.
  • PostgreSQL … Tables and views belonging to the specified database and schema.
* If you connect to Oracle Database, DB2 or PostgreSQL, objects defined with quoted identifiers (enclosed in double quotes '"') are not supported.
* CELF does not support access to synonyms and schemas other than the above.

See also

  • You can get data from tables of the external databases with registered database connecting information. For details, see Get From External Table.
  • If you selected connection type of 'client connection', you need to connect to external database via ODBC. For details, see Connect External Database (ODBC).

Important

  • To operate database connection information, you need database administrator’s privileges.
  • In order to operate external database via ODBC, you need to install ODBC driver into your PC.
../../../_images/celf_help_mascot14.png

Related keywords

driver