ION Anysql query output to local shared drive and scheduled?

orozcom1 · 2025-08-01T22:01:26+00:00

There was an error rendering this rich post.

I have a client that has created a AnySQL (Datalake) query workflow that queries a few tables and creates a view of that data. I know you can export to csv manually, be we would like to automate the process to run daily. I see that you can create a file connector, however, I have only seen it created for an SFTP location. Not local. How do I create a local shared drive, and add that Drive to export it to the folder? Do I need Enterprise connect for this?

I wrote a java app that will query Datalake via the JDBC driver and I can export the data to a file folder via .csv format. However, I can't schedule it to run daily unless I find some sort of tool to run cron jobs on my app on Windows server 2012.

Find more posts tagged with

ION Workflow

Comments

Carsten Steinhoefel

You are correct, you will need to install Enterprise Connector locally to create a File Connection point to an on-premise File Share (or FTP site).

orozcom1

Carsten,

Thank you. I have looked up and watch videos on installing the Enterprise connector. Seems straight forward enough. I also wrote a java app to connect to Data Lake (via JDBC), and query the data. I didn't need Enterprise File Connector, or a file Connection for that. The only thing that I do need is something to schedule and run the job whenever I need it.

Thank you again for the help. I will figure it out.

Kevin Heiman

Windows server has a built in scheduler, taskschd.msc.

orozcom1

Kevin,

Thank you for the comment. Yes, I saw that today. Seems like I could use that to schedule it to run.

I also thought about creating a .bat file to run the application. I might even create a html page with a button to run the application when you click on the button.

orozcom1

I have been looking more and more at the Enterprise connector and there are a lot of steps that you have to do in order to perform this task.

What I noticed was that if you use a FTP, or sFTP it does not seem like you need Enterprise connector. However, if you use a File connector, even a shared drive, then you have to use File Connector.

Another thing I don't understand.

I am trying to query a table in Datalake using ION - AnySQL. I like that you can schedule it to run, etc. But I am having issues understanding how to get the data and just send the file to a local shared directory? Do I really need Enterprise Connector for that?

So I need to install java jdk, Enterprise connector, and a database - SQL Server, SQL Server Lite, Postgress, just to move the file to a shared drive?

I have found documentation on Enterprise connector for sftp, IDM, etc., but not for a local shared drive.

When I use the ION JDBC drive and java code. I make a connection to Datalake, run my query, create my document, and put it in the shared drive. Then I can use Task Schedular to run the java app, when I choose.

Copyright © 2025 Infor. All rights reserved.