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:
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. |