Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Create Muliple Jobs in Data Sync

Received Response
22
Views
2
Comments
Samarendra Ora
Samarendra Ora Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server

Summary

Create Muliple Jobs in Data Sync

Content

Hi,

Can we able to create multiple jobs in Data Sync as below

Job 1 -- Will move data from Source System to Cloud Stage Schema

Job 2 -- Cloud Stage Schema to Final Cloud Schema (DW Schema)

I created Connection As below

And Created 2 Jobs:

In Job1 - Mentioned Source as "Src" and Target as "Cloud_dw_stg"

In Job2 - Mentioned Source as "Cloud_dw_stg" and Target as "Cloud_dw"

I created these jobs and update jobs, but when i executed all tasks are present in both Jobs.

Can we segregate Task based on our Source-Target Connection details.

I am using Data Sync Version : Oracle Business Intelligence Cloud Service Data Sync (2.3)

Answers

  • Samarendra Ora
    Samarendra Ora Rank 3 - Community Apprentice

    I did a work around,

    I created 2 Projects and 1 job in each project

    Poject1--Source-to-Stage-Extract : Job - Mentioned Source as "Src" and Target as "Cloud_dw"

    Project2--Stage-to-Target-Extrcat : Job - Mentioned Source as "Cloud_dw" and Target as "Cloud_dw"

  • User743400-Oracle
    User743400-Oracle Rank 3 - Community Apprentice

    thats the best way to organize.  You can also chain the jobs to run one after the other.  Refer at on-demand-etl.xml file where you can trigger a job based on a file signal.  At the end of every job, in the log\jobsignal directory, you will find <Job_name>_StartSignal.txt, <Job_name>_CompletedSignal.txt,  or <Job_name>_FailedSignal.txt.   Using these files, you can configure it to run Job1, look for Job1_CompletedSignal.txt to start Job2.