Registering File-Based Source Systems

Use this procedure to register a file-based source system to use in Data Management.

The source system page displays all registered source systems in a table in the Summary pane. By default, the following columns are displayed:

• Name—Name of the source system

• Type—A file-based source system is the only supported source system.

• Description—The description that you entered when you registered the source system.

• Drill URL—The drill URL you entered when you registered the source system.

Note:

You must manually create a source system and initialize it, before artifacts (such as the import format, or location) that use the source system are imported. You must manually create a source system and initialize it, before artifacts (such as the import format, or location) that use the source system are imported using Migration import.

To add a file-based source system:

1. On the Setup tab, under Register, select Source System.
2. In Source System, click Add.
3. Enter the source system details:
   1. In Source System Name, enter the source system name.
   2. In Source System Description, enter a description of the source system.
   3. In Source System Type, select File as the source system type.
   4. In Drill Through URL, enter the URL hyperlink for the drill through link by specifying the protocol identifier and resource name.

      Drill through is the navigation from a value in one data source to corresponding data in another file-based source system. Use drill through when you are working on data in EPM applications and want to understand the source of a data value.

      The protocol identifier indicates the name of the protocol used to fetch the resource. The Hypertext Transfer Protocol (HTTP) serves up the hypertext documents. HTTP is just one of many various protocols used to access different types of resources. Another protocol is file.

      The resource name is the complete address to the resource. The format of the resource name depends entirely on the protocol used, but for many protocols, including HTTP, the resource name contains one or more of the following components:

      • Host Name—Specify the name of the machine on which the resource lives.

      • File Name—The path name to the file on the machine.

      • Port Name—The port number to which to connect (typically optional).

      For example, specify http://machinename.us.server.com:portnumber

      For more information about defining a drill through, see Using Drilling Through.

   5. In ODI Context Code, enter the context code.

      The ODI context code refers to the context defined in Oracle Data Integrator. A context groups the source and target connection information.

      The default context code is GLOBAL.

   Watch this tutorial video to learn more about loading data by a file in the Planning and drilling down with Data Management.

   Tutorial Video

4. Click Save.

   After you add a source system, you can select the source system in the table, and the details are displayed in the lower pane.