Query with SQL connection parameters

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.

Table 1: Logon parameters

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

Table 2: Advanced parameters

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.