eksport data FROM DW database

Posted on 09/02/2007 14:50:26

How can i get data out of the DW SQL database into an CSV file in an automated routine without doing actual programming ?
SQL queries wil be ok !

Can i access the DW SQL database from another external SQL server ?

I need to export order headers and order ines on a daily basis and put tinformation on an AS/400 in a flat fixed file format.
I know how to do that, but how to get the data out of DW ?

One thing that would be neat, would be if it was possible to export data from the DW database into f.ex CSV files or another database using the integration module or via the datapublishing module.
Will that be possible ?
/Lars

Replies

Posted on 14/02/2007 21:49:02

Hi Lars, sorry for the late response, but I wanted to make sure, that I gave you the right answer.

In the next release there's an update to the Database Publishing module that enables you to access a DBPub view from the /Admin/Public folder and have the output printed (or download prompt) on the screen as CSV, XLS og XML, or have the file dumped in File Archive. That way you can have the AS/400 call (or do this with Scheduled Tasks) the page and either read the output or fetch the file via FTP.

Posted on 14/02/2007 22:15:59

Sorensen wrote:
Hi Lars, sorry for the late response, but I wanted to make sure, that I gave you the right answer.

In the next release there's an update to the Database Publishing module that enables you to access a DBPub view from the /Admin/Public folder and have the output printed (or download prompt) on the screen as CSV, XLS og XML, or have the file dumped in File Archive. That way you can have the AS/400 call (or do this with Scheduled Tasks) the page and either read the output or fetch the file via FTP.

Thanx. Looking forward to see that sometime next week then :o)
/Lars

You must be logged in to post in the forum

Developer forum

eksport data FROM DW database

Replies