Connect to external database (ODBC)

ODBC is one of common interface (API) to access relational database management system (RDBMS).
By registering the ODBC connection information for a database, CELF can connect to any external database other than the databases provided internally by default, and retrieve or update data.
To connect to external database via ODBC, you need to register the connection information in the PC as data source in advance.

Register external database connecting information

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

Configure database connection information

  1. In 'Register database connection setting' dialog, input to register database connecting information.
../../../_images/img_02.en112.png

[1] 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.
  • You can use just 2 bytes alphabet and number.

[2] Data source name

Set data source name of 'ODBC connection'.

Tip

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

[3] Database type

Select 'ODBC connection'.

Tip

CELF cloud version can select ‘ODBC connection’ only.

[4] User name

Set the user name to use at database connection.

[5] Password

Set the password to use at database connection.

[6] 'Register' button

Register database connecting information with configured details.
  1. Click 'Register' button.

See also

You can get data from the table of the external database with registered database connecting information. Refer the detail from Get From External Table.

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.
  • You cannot specify a password that includes a semicolon ( ; ). Please change the password to one that does not contain a semicolon ( ; ) before setting it.

Important

  • Regarding operating database connecting information, you need the permission as Database administrator.
  • In order to operate external database via ODBC, you need to install ODBC driver into the used PC.
  • ODBC Driver install
  • Set data source as same to above one
../../../_images/celf_help_mascot15.png

Related keywords

driver