Skip to main content Skip to complementary content

Isolating Workday accounts in Euros and sending them to an Oracle database table

This scenario aims at helping you set up and use connectors in a pipeline. You are advised to adapt it to your environment and use case.

Example of a pipeline created from the instructions below.

Procedure

  1. Click Connections > Add connection.
  2. In the panel that opens, select the type of connection you want to create.

    Example

    workday
  3. Select your engine in the Engine list.
    Information noteNote:
    • It is recommended to use the Remote Engine Gen2 rather than the Cloud Engine for Design for advanced processing of data.
    • If no Remote Engine Gen2 has been created from Talend Management Console or if it exists but appears as unavailable which means it is not up and running, you will not be able to select a Connection type in the list nor to save the new connection.
    • The list of available connection types depends on the engine you have selected.
  4. Select the type of connection you want to create.
    Here, select Workday.
  5. Fill in the connection properties to access your Workday account as described in Workday properties, check the connection and click ADD DATASET.
  6. In the Add a new dataset panel, name your dataset. In this example, a query is used to retrieve information about currency from financial accounts.

    Example

    account currency
  7. Fill in the required properties to query the table located in your Workday account and click VIEW SAMPLE to see a preview of your dataset sample.
    Configuration of a new Workday dataset.
  8. Click Validate to save your dataset.
  9. Do the same to add the Oracle database and table that will be used as destination in your pipeline. Fill in the connection properties as described in Oracle properties.
    Configuration of a new Oracle dataset.

    In this example, an Oracle table named euro_accounts is used.

  10. Click Add pipeline on the Pipelines page. Your new pipeline opens.
  11. Give the pipeline a meaningful name.

    Example

    From Workday to Oracle - isolate accounts in €
  12. Click ADD SOURCE and select your source dataset, account currency in the panel that opens. You can preview a sample of your data that contains information about currency.
    Sample of the currency data.
  13. Click add processor and add a Filter processor to the pipeline in order to filter the bank accounts and keep only the ones that use euros as their main currency. The configuration panel opens.
  14. Give a meaningful name to the processor.

    Example

    filter on accounts with €
  15. In the Filter area:
    1. Select .accountCurrency.descriptor in the Input list, as it is the field that contains the currency information.
    2. Select NONE in the Optionally select a function to apply list, as you do not want to apply a function while filtering records.
    3. Select == in the Operator list and type in EUR in the Value field as you want to filter on bank accounts that use euros.
  16. Click the ADD DESTINATION item on the pipeline to open the panel allowing to select the Oracle table in which your output data will be inserted.
  17. Give a meaningful name to the destination; € account table for example.
  18. In the Configuration tab of the destination, click Main and select INSERT in the Action list to insert the data into the table when executing the pipeline.
  19. Click Save to save your configuration.
  20. (Optional) Click the last processor to preview the processed data.
    In the Output data preview, 11 records match the criteria.
  21. On the top toolbar of Talend Cloud Pipeline Designer, click the Run button to open the panel allowing you to select your run profile.
  22. Select your run profile in the list (for more information, see Run profiles), then click Run to run your pipeline.

Results

Your pipeline is being executed, the account data that was stored on Workday has been processed and the output flow is inserted into the Oracle target table you have defined.

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