Import ODBC

Oasis montaj provides the functionality to import ODBC data sources. This gives you the ability to import data from complex or custom data sources such as corporate databases. Use the Database > Import > ODBC menu option (IMPODBC GX) to import external database tables into a database.

To Import an ODBC Database:

1. The IMPODBC GX begins by scanning your system to determine valid ODBC sources.
   
   If you have an open database, the system will ask you whether to import to the current database or create a new one. If you have no database open or choose to create a new database, the New Database dialog is displayed. Specify a new database name and size and click OK.
2. It then provides the Select Data Source dialog listing possible sources:

   • Click the Machine Data Source tab to view the Data Source Name entries that are available on your computer. To add a new data source, select the New button.

   • Select a Data Source Name from the list by double clicking the left mouse button on it.

3. Once the source is chosen (and depending on the type of source) you are presented with a selection file dialog to select the file you want to import. After selecting the file to import, click OK.
4. Finally, the table and fields selection dialog appears and allows you to choose a table, then one or more fields in the selected table:
   • You can specify conditions that enable you to filter out unwanted data from the external database.

Once the OK button is pressed, the selected fields are imported into the database. An import template, "impdb.i4" is created, which is used for the import stage.

Application Notes

A data source includes the data you want to access and the information needed to get that data.

Examples of ODBC Data Sources:

• A SQL server database, the server on which it resides, and the network used to access that server.

• A directory containing a set of dBASE files you want to access.

• An Excel workbook accessed using the Excel ODBC drivers.