The following tasks are used when you define import links.
Create an Import Link for an ODBC Source
This procedure describes the setup for the ODBC platform.
Create an Import Link for an Oracle Source
Use this procedure to build a new link using a source database platform other than ODBC. To do this you must have access rights to the database server as well as the appropriate database drivers. You must also have the appropriate settings in the configuration files (for example, ini files) and in the Windows registry.
Create an Import Link for a File Source
Use this procedure to create an import link for a data source that is a predefined file containing tables with table columns and values.
Define a Data Import Source in Excel Spreadsheets
Use this procedure to define tables, table columns and column values in an Excel spreadsheet. You can then use this Excel spreadsheets as a source for data import.
Prerequisite for Using Microsoft Access as an Import Source
Before you create an import link for a Microsoft Access data source file, you need to perform the following procedure in Microsoft Access file containing the source data.
Using the Link Explorer Window
You use the Link Explorer window to move and copy links.
Use this procedure to change the path or name of the source file of an existing link when you need to update the source path. You can change the source path of a single link or you can set one default folder for all your links in that group.
Use this procedure when moving a link or exporting a group of links to another database or domain. When you export a group of links you transfer the information about a group of links to an ASCII file which has the .imp extension. You can then use the exported links in other domains or databases. The link information is saved to an ASCII file that you can use for import.
Use this procedure to import the link or group of links you exported. You can use a file with the .imp extension to create a group of links based on the information you have saved in this file.