Export Query to FTP Site

  • 36Views
  • Last Post 02 February 2018
0
votes
Patrick Wambach posted this 27 January 2018

I have successfully created a query that formats the data the way I need it but I can't seem to find a way to automatically export the query results to an FTP site in csv format.  All I see is the option to manually click csv.  I looked at the intergration option but it won't let me choose a query that was already created as the source.   Can this be done.  I need the query to run once a day at a specific time so that it exports the file to the FTP site where another system will process it?  

Please let me know, asap.

 

Order By: Standard | Newest | Votes
0
votes
Mariia Zaharova posted this 29 January 2018

Unfortunately, currently it is impossible to use queries in the integration packages. However, we are considering the possibility to implement this functionality. We will inform you if any results regarding this are available.

If you have any further questions, feel free to contact us.

0
votes
Patrick Wambach posted this 31 January 2018

Well that was the main reason for using your system.  I have downgraded my account back to a free account.  Can you refund my account as the product was unable to do what I needed it to do?

0
votes
Mariia Zaharova posted this 02 February 2018

Sorry for the delay in response. Your full satisfaction from Skyvia is our top priority, so we'd be more than happy to provide you with all possible solutions.

We can propose you this option: you can create new Export package with SFTP connection as a Target, add tasks for all the necessary objects and specify SQL queries you would like to execute for these objects. We will study them and, if it is possible, we will change SQLs that are used for execution of your Export package according to your goal. 

Currently, this functionality can be implemented only with our interaction. Does this option suit you?

 

Looking forward to your reply.

 

Best regards,

Mariia

 

Close