Skip to main content Skip to complementary content

Configuring the components

Procedure

  1. Double-click the tOracleInput to open its Basic settings view.
  2. Define the Oracle connection details. It is recommended to store the database connection details in the Metadata folder of the Repository tree view in order to retrieve them easily at any time in any Job.
  3. Define the schema, if it is not stored in the Repository. In this example, the schema contains four columns as follows: ID_Contract, ID_Client, Contract_type and Contract_Value.
  4. Define the tFileOutputDelimited component parameters, including output File Name, Row separator and Fields delimiter.
  5. Double-click on the tOracleBulkExec to define the database populating properties.
  6. In the Property Type list, select Repository if you stored the database connection details under the Metadata node of the Repository or select Built-in to define them manually. In this scenario, use the Built-in mode.
  7. Set the connection parameters in the following fields: Host, Port, Database, Schema, Username, and Password.
  8. Fill in the name of the Table to be populated and the Action on data to be carried out. In this use case, select insert.
  9. In the Schema list, select Built-in, and click the [...] button next to the Edit schema field to define the structure of the data to be passed to the next component.
  10. Click the Advanced settings view to configure the advanced settings of the component.
  11. Select the Use an existing control file check box if you want to use a control file (.ctl) storing the status of the physical structure of the database. Or, fill in the following fields manually: Record format, Specify .ctl file's INTO TABLE clause manually, Field terminated by, Use field enclosure, Use schema's Date Pattern to load Date field, Specify field condition, Preserve blanks, Trailing null columns, Load options, NLS Language and Set Parameter NLS_TERRITORY according to your database.
  12. In the Encoding list, select the encoding, or enter the encoding between double quotes if it does not exist in the list.
  13. In the Output list, select to console to output the standard output of the database in the console.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here