JDBC type data source fields

These additional fields appear on the data source form when the Type field value is JDBC.

Field Description
Use MID Server Select a MID Server to use to connect to this data source.
Format Select one of the supported database formats. Instances can connect to Microsoft SQL Server 2012 but not Microsoft SQL Server 2000.
Instance name Used to support dynamic port connectivity with SQL Server. To ensure connectivity, provide the instance name for a SQL Server that receives a new port number dynamically after each reboot. This field only appears when SQLServer is selected as a data source format.
Database name Enter the name of the database instance.
Database port Enter the port number for the database. Leave this field empty when using dynamic port connectivity with SQL Server.
Use integrated authentication Select this check box to allow the JDBC connection to use the ID of the user configured for the Windows MID Server service for SQL Server authentication. For additional details, see SQL server integrated authentication for Windows.
User name Enter the user name for authentication on the database server. The user name provided for the JDBC connection must be associated with an account on that database server; it cannot be a Windows Domain account.
Password Enter the password for authentication on the database server.
Server Enter the name of the server from which the data will be imported.
Query Select the type of query to run: All rows from Table or Specific SQL. If you select to run a SQL statement, the SQL statement field appears.
Query timeout Specify the number of seconds the JDBC driver will wait for a query (SELECT) to complete. Zero means no timeout. If timeout is exceeded, the integration considers the JDBC result inaccessible and places it in an error state.
Connection timeout Specify the number of seconds before MID Server connection cache pool closes and removes it from the pool. Zero means no timeout.
Table name Type the name of the table from which the data is being exported.
SQL statement Type a SQL statement to extract the desired data from the database.
Use last run datetime This selection controls the amount of data that is retrieved from a database during an import run. If this check box is unselected, then all rows in the table specified are imported, every time. You might want to use this setting if this is a one-time import, or if all the data in the target table is new. If this check box is selected, two additional fields appear, enabling you to select a datetime value to limit imported data to delta values only.
Last run datetime The datetime value in this field is automatically populated from the database field you select below and represents the latest value from the previous run. This value acts as a dynamic filter to restrict the number of records retrieved to those records that have changed since the data source's last runtime.
Last run database field Select the field name from the source table that will be used as the filter in the next run. This value may need to be case sensitive depending on the target database type.
Additional Database Parameters Optional parameters to add to the end of the URL generated for this data source. Enter a semicolon-separated list of parameters. You may need to configure the form to view this field.