Trevor Tinsley Posted April 3, 2019 Share Posted April 3, 2019 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. Link to comment Share on other sites More sharing options...
James Ainsworth Posted April 3, 2019 Share Posted April 3, 2019 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 Link to comment Share on other sites More sharing options...
Trevor Tinsley Posted April 11, 2019 Author Share Posted April 11, 2019 Hi James, Thanks for the feedback. Regards. Trevor. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now