Hello,
I have this new task, and I do not know how to begin.

They have asked me to create a process to run automatically at a certain time in the day (every day): this process, read some data from an Oracle DB 10g and write the data into a table in another Oracle 10g DB.

The Master is already developed, The process has only read the data and place them in another table in another DB, every day at same time


I ask, I can do with WebFOCUS Developer Studio 7.6.10. ? or what tools would be possible to create the process?

Thanks for your help!

Saludos!

Tony

This message has been edited. Last edited by: Kerry,

You will have to create a fex with the fields you want and hold it to a Hold file in the location you want in the format you want.

Then you schedule it in ReportCaster.

Have you had any training?

hola!

I've had some experience in Developer Studio, creating basic FEX (40) and linking them to HTML.

Report Caster is a product that requires a license?

Thanks!

Tony

Yes, you need a licence.

The other ooption is the use an OS scheduler.

The windoes Scheduler, or CRON on Unix.

More than Dev Studio, what you have explained can be very well done with iWay DM using a simple transform. But agin, that needs a seperate licence.

Else, as said with a fex which has code to reterive data from one table and insert it into another table (SQL pass through is a much opt approach - if you need no change in the data migrating) and schedule that with a ReportCaster Job, on daily frequency.

Depends on your requirment though !

[CLOSED]
First I´ll try to use the option that proposes Waz (Windows Scheduler). I think it's interesting.

If it doesn´t working as I need, I will use the Report Caster

Thank you very much everyone for their ideas and responses

Greetings!

Tony

If you use the windoes scheduler, you will need to call edastart with the the option -x or -f.

Hi Waz,

It's a better idea to use a OS schedule.

I jus have a querstion here ...

Can a OS scheduler directly invoke a FEX and do the Job? Do'nt it need a OS specific script to do that ?

As mentioned in the post above, get the OS Scheduler to call edastart.bat with -x or -f options.

http://techsupport.information...utions/41352515.html


If you run edastart -?, it will show you the options.

Thank you Waz, for the Info.

I have used edastart in a unix shell script and it works perfect. However you need to set the environmental variables before calling edastart command (especially the oracle home path and stuffs).

Here is a command line to call a fex procedure:

/opt/ibi/srv77/wfs/bin/edastart -x "EX commission_statement/main &PARAM1=$BD" > ./WFlogs_$BD.log