You can create your own data provider by manually entering the SQL for a target data source to acquire table data. When using Query with SQL, you must enter connection information for the target database, and you can specify connection parameters to optimize the fetching of data.
|
Parameter |
Description |
|---|---|
|
User name |
The user name that you use to connect with the target database |
|
Password |
The password that you use to connect with the target database |
|
Server (<host>:<port>) |
The name and port of the server hosting the database |
|
Database |
The database name |
|
Parameter |
Description |
|---|---|
|
Connection pool mode |
If using a connection pool, use to keep the connection pool mode connection active. |
|
Pool timeout |
If the connection pool mode is set to Keep the connection active for, the length of time in minutes to keep the connection open. |
|
Array fetch size |
The maximum number of rows authorized with each fetch from the database. For example, if you enter 20, and your query returns 100 rows, the connection retrieves the data in five fetches of 20 rows each. To deactivate array fetch, enter an array fetch size of 1. Data is retrieved row by row. Deactivating the array fetch size can increase the efficiency of retrieving your data, but it slows server performance. The greater the value in the array fetch size, the faster your rows are retrieved. However, ensure that you the client system has adequate memory. |
|
Array bind size |
Size of the bind array before it is transmitted to the database. Generally, the larger the bind array, the more rows (n) can be loaded in one operation, and performance will be optimized. |
|
Login timeout |
The number of minutes before a connection attempt times out and a message appears. |
|
JDBC driver properties |
Values for JDBC driver properties. You can define the value of more than one property, separated by commas. For example, the oracle.jdbc.defaultNChar=true,defaultNChar=true value for JDBC driver properties sets the oracle.jdbc.defaultNChar and defaultNChar driver properties. |