Refreshing Data Automatically

[gatorfe]

Hello, we currently use a series of DOS batch files to refresh data from an ERP system(Infor ERP LX) to a data warehouse(SQL) which is were data in Cognos reports is pulled from.  This refresh happens nightly.  We receive a txt file from the ERP system that then triggers the batch files to run that are set on scheduled task.  We are wondering what other tools/products others use to run their refreshes from a source system to a DW.  Any suggestions would be greatly appreciated.  Thank you for your comments ahead of time.

[MFGF]

Many clients use ETL tools for these kinds of processes. If you wanted a fully integrated Cognos solution where you could use the Cognos 10 scheduler to control the process, Data Manager builds and jobstreams can perform this process and be deployed into your Cognos 10 BI environment for scheduling.

Cheers!

MF.