Extract data for 10 oracle identical schemas

  • I am working on a datwarehouse which is based on 10 identical oracle schema

    Can comeone tell me how to use a single connection and a data source reader.

  • Hello,

    You have 2 solutions : in both cases, define your source connection strings with an expression filled by a variable value

    1 / define a job with 10 steps. In each step, define the connection variables depending on your source connect string.

    2 / create a table listing all your connection and their connect strings.

    Use a For Each Loop Container fetching this table and getting connect string values. Inside the Container , insert your data flow that will be launched as many times as there are lines in your connection table.

    JL

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply