Field list
|
Field name |
Initial value |
Possible settings |
Omission possible |
Remarks |
|
|---|---|---|---|---|---|
|
ID |
|
Alphanumeric characters and symbols (#1) |
No |
50 bytes or fewer |
|
|
Business group |
|
A business group for which general users have access permissions. Alternatively, a business group whose only purpose is to be used for filter conditions. |
Yes |
|
|
|
Comment |
|
Characters (#2) |
Yes |
255 bytes or fewer |
|
|
Product type (#3) |
SQLite3 |
SQLite3, Oracle, DB2, SQL Server (#4), PostgreSQL, ODBC, Excel (#5) |
No |
|
|
|
Kanji code type (#6) (#7) |
Undefined |
Undefined, |
No |
|
|
|
Select Database name |
Database name |
Database name, DSN, TNS |
No |
|
|
|
Database name |
|
Characters |
No |
255 bytes or fewer |
|
|
DSN |
|
Characters |
No |
255 bytes or fewer |
|
|
TNS |
|
Characters |
No |
255 bytes or fewer |
|
|
Host name |
|
Alphanumeric characters and symbols (#8) |
No |
255 bytes or fewer |
|
|
Port number |
|
1 to 65535 |
No (#9) |
|
|
|
User ID |
|
Characters |
No (#9) (#10) |
255 bytes or fewer |
|
|
Password (#11) |
|
Alphanumeric character: |
No (#9) (#10) |
32 bytes or fewer |
|
|
Authentication methods |
Windows authentication |
Windows authentication, SQL Server authentication |
No |
(#4) |
|
|
Private Key |
|
Windows |
Characters (#12) |
Yes (#14) |
200 bytes or fewer |
|
Linux |
Alphanumeric characters and symbols (#13) |
||||
|
Private Key Passphrase |
|
Alphanumeric characters |
Yes (#14) |
32 bytes or fewer |
|
|
#1 |
: |
You can use only hyphen (-), underscore (_), period (.), left parenthesis ((), and right parenthesis ()). |
|
#2 |
: |
No line breaks can be registered. |
|
#3 |
: |
Only SQLite3 can use the DataMagic Desktop grade. |
|
#4 |
: |
For Windows only. |
|
#5 |
: |
In future upgrades or revisions, the settings for accessing Excel files using database connection information might become obsolete. When using Excel files, be sure to use Excel information. |
|
#6 |
: |
In the case of DataMagic Desktop grade, this field is not displayed. |
|
#7 |
: |
If the product type is ODBC or SQLite3, do not select Undefined in kanji code type, set the code type of your database correctly. |
|
#8 |
: |
You cannot specify left angle brackets (<), right angle brackets (>), double quotation marks ("), single quotation marks ('), ampersands (&), commas (,), or semicolons (;). |
|
#9 |
: |
If the product type is SQLite3 or ODBC is set, this can be omitted. |
|
#10 |
: |
If the product type is SQL Server and Windows authentication is set for the authentication method, it can be omitted. |
|
#11 |
: |
When you connect to Snowflake using Key Pair authentication, the value specified for Password is not used. |
|
#12 |
: |
You cannot specify left angle brackets (<), right angle brackets (>), or double quotation marks ("). You cannot use external characters. Operations are not guaranteed if any platform-dependent character is included. |
|
#13 |
: |
You cannot specify left angle brackets (<), right angle brackets (>), double quotation marks ("), single quotation marks ('), or ampersands (&). |
|
#14 |
: |
You can set this only if the connection destination database is Snowflake. |