ETL (Extract Transform Load) functionality in Automize

Discuss Task Sequences and Scripting related issues.

ETL (Extract Transform Load) functionality in Automize

Postby melvin » Tue Apr 28, 2015 10:16 am

User support request:
Can you please let us know if there is any ETL (Extract Transform Load) functionality available within the Automize?
We are currently looking at some solution to Extract data from a txt file and load into database.
melvin
Site Admin
 
Posts: 979
Joined: Thu May 25, 2006 10:20 am
Location: Santa Barbara, california

Re: ETL (Extract Transform Load) functionality in Automize

Postby melvin » Tue Apr 28, 2015 10:17 am

You could try the text search task or a CSV read/loop task.
then use the variables created to put data into a database using a Database sql task.

If you send us example text files and example data that needs to be extracted, we can help you better.
melvin
Site Admin
 
Posts: 979
Joined: Thu May 25, 2006 10:20 am
Location: Santa Barbara, california


Return to Task Sequences, Chains and Scripts

Who is online

Users browsing this forum: No registered users and 1 guest

cron