Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Automatic transformation

Automatic transformation 6 months 2 days ago #18913

Hello

I need to automate the process of converting a QVD to CSV, I got the project to do it but I having a bad time looking for documentation on how to automate it.

Can I use terminal/cmd to do this with out open the GUI or a user making the process?


This will be on a Windows machine that have a folder wich other bat process populate with QVD files every day so the ETL tools need to take it, run the transformation process and generate a csv file into a seperate forlder so another .bat file send it to SugarCRM using REST Json WebServices. By the way it could be wasom if this ETL tool can call REST Json too! Note: it is necesary to call a WS to get a token and then use that token on the header of every request/call to SugarCRM REST WS.

So I need a way to schedule the ETL tool to go into a folder and read some file, transform it and then save it as csv. Or if is it posible, a way to pass some parameters on CMD to start the transformation process ondemand.

Please Log in or Create an account to join the conversation.

Automatic transformation 6 months 2 days ago #18914

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7572
  • Karma: 33
  • Thank you received: 415
Wiki has all the answers.

Please have a look at this article

www.etl-tools.com/wiki/aetle/execution_automation
Mike

Please Log in or Create an account to join the conversation.

Automatic transformation 5 months 4 weeks ago #18916

Hello.

How is it going?

Do you have any more questions?

Please Log in or Create an account to join the conversation.

Automatic transformation 5 months 4 weeks ago #18917

Hello

Hi Maria, thanks for asking, I'm still checking the documentation to start some test over it and determinate if this is the proper tool fro this job, since we only choose it due to the fast it process QVD files to csv, so in the worst case we will only use it for the transformation process and all integration process within SugarCRM with other tool or as we always do on linux.

I will feedback as soon as I finish the documentation reading.
By the way, can I run this ETL tool on linux?

Please Log in or Create an account to join the conversation.

  • Page:
  • 1

We have 182 guests and no members online