ITA ETL INTEGRATION

[silvio.filho]

Hello people!

I`m trying to do a ETL integration in ITA, but i had some doubts.

I have already read the documentation but i cant find some answers.

I need to to the ETL without model because i need to up data from a lot of devices like UPS, AC, and more.

I have created the ETL connection, my doubt are:

How i do the upload from the data? I`m trying to do this with a .xls fi

[gsterling]

Hello Silvio

We have a services team which normally provides functionality like this for customers so their is not a lot of detailed information regarding tasks like this.

However, the ETL engine in DCO and ITA is based on Pentaho's Kettle tool, which is a public product, so you don't have to rely on information for details you may need like this.

What you need to create is a transformation which can open an excel document and then transform the data in that sheet to database tables.

There are numerous online youtube video's and other documents which show users how to use the pentaho tools. For example this youtube video (non-Schneider) shows an example of creating a transformation which moves data from an Excel document to a mysql database.

https://www.youtube.com/watch?v=RDxdy_8mOa0

Regards

Greg Sterling