Fields settings

This section explains the fields of database connection information.

(1) Fields for Database Connection - Detailed Information

ID

The ID used to identify registered database connection information.

Business group

A business group for which general users have access rights.

Alternatively, a business group that is used as a filter condition only.

Comment

Comment about the database connection information.

Product type

The type of connected database.

SQLite3

: Connect to SQLite3.

Oracle

: Connect to Oracle Database.

DB2

: Connect to DB2.

SQL Server

: Connect to SQL Server.(Windows only)

PostgreSQL

: Connect to PostgreSQL.

ODBC

: Connect to the database via ODBC.

Excel

: Connect to an Excel file.(#1)

#1

:

In a future revision/version, use of Database connection information to specify accessing Excel files may become obsolete. When using Excel files, be sure to use Excel information.

Kanji code type

The kanji code type of the connection point database.

If the kanji code type varies, a connection error occurs.

If you specified Undefined, the character code type set in the database is used.

  • Undefined

  • ASCII

  • SHIFT-JIS

  • EUC

  • UTF-8

  • UTF-16

  • UTF-16 Big-endian

  • UTF-16 Little-endian

Select Database name

When you connect, select the database specification method.

If Product type is SQLite3 or PostgreSQL, always specify the database in the database name.

Database name

: Specify the database by name. You can select this item when the Product type is SQLite3,

Oracle, DB2, SQL Server (Windows only), or PostgreSQL.

DSN

: Specify the database by DSN.

You can select this item when Product type is DB2, SQL Server (Windows only), or ODBC.

TNS

: Specify the database by TNS.

You can select this item when the Product type is Oracle.

Note

If the DataMagic Server for Windows environment is an x64 environment, specify this item by using the DSN that was registered in the System DSN in the connection from DB2 Connect. Other connections are not supported.

Database name

Specify the connected database name. Clicking the Browse... button displays the Browse folder dialog box. In this dialog box, select the target database file.

If Database name is specified in Database Selection, this item cannot be omitted.

Note

If Product type is SQLite3, when performing a connection, you can use the dynamically specified file name when running conversion.

= Remarks =

For UNIX, you cannot specify a Database name that includes Japanese.

DSN

Specify the connection database by DSN.

You can select from the DSN list by clicking the Browse... button to open the Select DSN dialog box.

If DSN is specified in Database Selection, this item cannot be omitted.

= Remarks =

DSN (Data Source Name) is the source that describes the database connection information.

TNS

Specify using the net service name that describes the connection database in the local naming parameters (tnsnames.ora).

You can select from the net service name list by clicking the Browse... button to open the Select TNS dialog box.

If Product type is Oracle, specify this item.

If TNS is specified in Database Selection, this item cannot be omitted.

User ID

The user name connected to database.

Password

The password for the above-mentioned user to use for connecting to the database.

Host name

The connection host name.

Port number

The database connection port number.

If you omit this item, the following default port numbers are used.

Table 4.4 Default Port Number

Database

Default port number

Oracle

1521

SQL Server(#1)

1433

DB2

50000

PostgreSQL

5432

#1

:

Windows only.

Authentication method

The authentication method for connecting to the database.

If Product type is SQL Server, select this item.

Windows authentication

: Use for authenticating user and group registered in Windows.

SQL Server authentication

: Authenticates only user registered in SQL Server.