Clarity

  • Private Community

  • 1.  Clarity DB and Datawarehouse DB in same database server

    Posted Feb 01, 2017 03:49 AM

    HI,

     

    Can we have both Clarity DB and Data warehouse DB in same database server? If we can have then do we still need the link to clarity database that has to be updated in CSA\Datawarehouse\PPM Database Link?

     

    Thanks in advance,

    Shiva



  • 2.  Re: Clarity DB and Datawarehouse DB in same database server

    Broadcom Employee
    Posted Feb 01, 2017 04:20 AM

    Even if you keep both the schema on the same server we would still need DB link as ETL job is dependent on that



  • 3.  Re: Clarity DB and Datawarehouse DB in same database server

    Posted Feb 01, 2017 04:30 AM

    Thanks Suman. I will test by creating the link and run the ETL job.



  • 4.  Re: Clarity DB and Datawarehouse DB in same database server
    Best Answer

    Broadcom Employee
    Posted Feb 01, 2017 04:57 AM

    Creating DB Link is must and not an optional to use DWH