The Import Utility provides you with inherent support of the following database platforms and database file formats:
-
Oracle (only if you have selected Oracle as your current database platform during Setup)
-
SQL Server (only if you have selected SQL Server as your current database platform during Setup)
-
Microsoft Access
-
DBF (Smart Instrumentation comes shipped with .dbf files. These files appear in the path <Smart Instrumentation home folder>\Import. You can use these files as examples when learning how to import source data from .dbf files.)
-
ASCII delimited files
-
Excel worksheets
-
Text files
-
To install drivers and profiles of ODBC platforms other than those listed above, you need to install the appropriate software (for example, Microsoft Excel 7 or later, Microsoft Access).
-
Smart Instrumentation supports Microsoft dBase Driver for .dbf files, and Microsoft Text Driver for .txt and .csv files. You can select the driver you require using the ODBC Data Source Administrator in your Windows Administrative Tools.
Table column headers in the import source file must not contain any spaces. If a space
is inserted into a column header this results in the import failing.
You can import data from a database platform (for example, Oracle or SQL Server) other than your current Smart Instrumentation database platform. To do this, you must comply with the appropriate system requirements of the external database platform.
You can also import from database platforms other than those specified above. To do this, you need to provide drivers and modify the appropriate configuration files.