Hi, i would like to ask the question about publishing from Contribotor to Oracle in my case, may be someone has bigger experience in this, i hope so.
Well, I have data in an application, table view layout. I can see my data in Oracle.
The question is â€" does the data loaded in application will publish automatically in dw, or i have to make manually jobs and publish every time i need updated data in DW?
By manually jobs i mean publishing in cognos administration.
Any ideas?
What version of contributor are you using?
Version 8.3.
I am trying to think that this is hopefull :-\
do u want to automate the process- publish to DW update?
You can facilitate event studio to track a change in the value of 'last data change' for you elist items and trigger an automatic publish, may be even an incremental one.
Yes, i want to automate the process- publish to DW update
If you don't like the event studio way you can publish your macros (in your case a 'publish macro') to connection (checkbox available in CAC macro options since 8.2). You'll then find this macro in the admin section of Cognos Connection in the folder Planning>Macros. In the properties of this item you can specify the job schedule to run.
But the event triggered way might be more interesting if you look for near-time publishes instead of nightly batches.
recently i setup this automation at one of sites using Informatica (ETL tool) and ContrlM (Scheduler)
1) set incremental publish macro
2) set ETLs in Informatica
3) Create jobs in ControlM (scheduler) for Publish and ETls and create ETL dependency on Publish job
Every 2 hours these jobs run automatically w/o any intervention.
the same thing can be done without using Informatica and ControlM.
1) Macro Step1: create incremental publish macro
2) Macro Step2: create execute Command Line macro to run SQLs (ETLs)
3) use event studio to schedule above macro execution
Thank you very much!:)
Life became easier:)
Last comment - look at the P_JOB table within your planning store.