A support forum for Data Center Operation, Data Center Expert, and EcoStruxure IT product users to share knowledge on installation, configuration, and general product use.
Send a co-worker an invite to the Exchange portal.Just enter their email address and we?ll connect them to register. After joining, they will belong to the same company.
You have entered an invalid email address. Please re-enter the email address.
This co-worker has already been invited to the Exchange portal. Please invite another co-worker.
Please enter email address
Send InviteCancel
Invitation Sent
Your invitation was sent.Thanks for sharing Exchange with your co-worker.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2022-04-2511:21 AM
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.