Item name |
Required / Optional |
Use of Variables |
Description |
Remarks |
Hostname |
Required |
Only environment variables are available. |
Enter the host name of database. |
|
Port number |
Optional |
Only environment variables are available. |
Enter the port number of database.
The number defaults to 3306.
|
|
Database name |
Required |
Only environment variables are available. |
Enter the database name. |
|
User name |
Required |
Only environment variables are available. |
Enter the user name. |
|
Password |
Optional |
Only environment variables are available. |
Enter the password. |
|
SSL connection |
Optional |
Not available |
Select whether to make the SSL connection.
- [Checked]:
Make SSL connections.
- [Not Checked]: (default)
Do not make SSL connections.
|
- To perform SSL communication between MySQL and this adapter, you will need to import the private key and the certificate issued by Certification Authority (CA) into the keystore that is referenced by DataSpiderServer.
For how to import the private key and certificate, refer to Certificate Installation
Private keys and certificates generated with OpenSSL are also supported.
For how to enable SSL, refer to "Setting Up SSL Certificates and Keys for MySQL"(http://dev.mysql.com/doc/refman/5.6/en/creating-ssl-certs.html) and "SSL Command Options"(http://dev.mysql.com/doc/refman/5.6/en/ssl-options.html).
|
Item name |
Required / Optional |
Use of Variables |
Description |
Remarks |
Specify the number of tables in the list |
Optional |
Not available |
Select whether to limit the number of tables listed or not.
- [Checked]:(default)
limit the number of tables names listed.
- [Not Checked]:
Table names listed are not limited. Fetches all of the table names available.
|
|
Number of tables |
Optional |
Available |
Enter a number of tables listed.
|
-
Enabled when [Specify the number of tables in the list] is checked.
-
Defaults to 500 if omitted. Defaults to 500 if omitted, or if the value specified is invalid.
|
Specify the number of procedures in the list |
Optional |
Not available |
available Select whether to limit the number of procedures or not.
- [Checked]:(default)
limit the number of procedures listed.
- [Not Checked]:
Procedure names listed are not limited. Fetches all of the procedure names.
|
|
Number of procedures |
Optional |
Available |
limit the number of the procedures listed.
|
-
Enabled when [Specify the number of procedures in the list] is checked.
-
Defaults to 500 if omitted. Defaults to 500 if omitted, or if the value specified is invalid.
|