The Import Config Window window that is launched from the Tables window allows you to specify a data source for the data to be imported. Two of the allowed data sources are Database Table and SQL Server Table. The Data Source Connection window configures the database table and/or SQL server table from which the data will be imported. The following columns are available in the Data Source Connection window:
- Data Source Connection: This column shows the literal name of the data source. (The AgileAssets database is called "main.")
- Data Source Type: This column provides a drop-down list so you may select whether the source is a database table or an SQL server table.
- Schema Filter: This column shows the schema name within the database that will be accessed.
URL: This column shows the name of the database for the schema. For the Database Table type, this is the AgileAssets database and is called "main." For the SQL server table type, an example of the URL for the server could be jdbc:sqlserver://aasql01;user=TXDOT_FMS_CONVERSION;password=TXDOT_FMS_CONVERSION.
Note: Typically, only one database table and/or one SQL server table is defined in this window. However, if multiple sources are configured for a particular source type, then the system will ask which source to use when the user selects the source type in the Import Config window.
