EcoStruxure IT forum
Schneider Electric support forum about installation and configuration for DCIM including EcoStruxure IT Expert, IT Advisor, Data Center Expert, and NetBotz
Link copied. Please paste this link to share this article on your social media post.
Posted: 2020-07-05 06:49 PM . Last Modified: 2024-04-03 02:51 AM
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)
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2020-07-05 06:49 PM . Last Modified: 2024-04-03 02:51 AM
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)
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2020-07-05 06:49 PM . Last Modified: 2023-10-22 02:57 AM
This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.
Link copied. Please paste this link to share this article on your social media post.
Create your free account or log in to subscribe to the board - and gain access to more than 10,000+ support articles along with insights from experts and peers.