Oracle Database Settings

To create a Oracle database data mapping configuration, the following steps are involved

• Start by opening the Creating a New Data Mapping Configuration wizard.
• In the list, select Data mapping Configuration -> Databases -> Oracle and click Finish.
• Confirm the Database type is set to Oracle.
• Set the following properties in this dialog:
• • Server: Enter the server address for the Oracle database.
  • Port: Enter the port to communicate with the Oracle server.
  • Database name: Enter the exact name of the database from where the data should be extracted.
  • User: Enter a username that has access to the Oracle server and specified database. The user only requires Read access to the database.
  • Password: Enter the password that matches the username above.
• Optionally, click Test configuration to verify that the database can be accessed.
• Click OK to close the dialog and open the actual data Mapping configuration (See Creating the Data Mapping Workflow).