Welcome to the new Schneider Electric Community

It's your place to connect with experts and peers, get continuous support, and share knowledge.

Close
Important Announcement: WELCOME to the Schneider Electric Community! We have moved to a new address: community.se.com — bookmark it today and contact SchneiderCommunity.Support@se.com if you have any questions!
Invite a Co-worker
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.
Send Invite Cancel
82794members
350631posts

Load data to DCO ETL import database

EcoStruxure IT forum

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.

DCIM_Support
Picard
Picard
0 Likes
2
142

Load data to DCO ETL import database

This question was originally posted on DCIM Support by Momen Samy on 2019-04-09


Hi,

Kindly i need to ask if the DCO ETL job can access a .csv file in a specified path in a remote server, and the .csv file is updated frequently with another SCADA system.

Please note that we cannot upload the .csv file manually in the DCO Pentaho import folder, as i've mentioned the .csv file is updated frequently.

(CID:141272543)

2 Replies 2
DCIM_Support
Picard
Picard
0 Likes
0
142

Re: Load data to DCO ETL import database

This answer was originally posted on DCIM Support by Ed Tarento on 2019-04-10


Hi Momen

Can the remote location where the CSV file is stored be accessible to the DCO server?  e.g. via SMB or NFS?

If not, perhaps you can develop a routine on the same system where the CSV is stored to write directly to the Import DB on the DCO server.

I can't recall but it may also be possible to create an ETL Import DB on a server remote to the DCO server, perhaps even the same place the CSV file is maintained?

You don't mention what type of data is to be imported?

Cheers

Ed

(CID:141272835)

DCIM_Support
Picard
Picard
0 Likes
0
142

🔒 Closed

This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.