Database Direct

[Trevor Tinsley]

Good afternoon,

Firstly, apologies if i am going over old ground regarding what is feasible via Database Direct (DD).

I have a requirement to query and export HSM data on a daily basis for upload into our data warehouse.

I note that DD result sets may be exported to csv, which leads me to ask the following:

1) Is there a facility to trigger DD queries via a scheduled job?

2) Can a scheduled job be used to export csv output to a predefined on-premises location?

Regards.

Trevor. 

[James Ainsworth]

Hi @Trevor Tinsley

Have you had a look at our Data Export tool?

Let us know if you think that this would enable you to do what you are looking for.  You would need to use Windows Scheduler in order to schedule this.

Regards,

James

[Trevor Tinsley]

Hi James,

Thanks for the feedback.

Regards.

Trevor.