A Banking customer needs to deploy DCE & DCO over SQL Server (As I understand the data base in DCO & DCE is postgres). Some questions about it:
1. As i understand there is a ETL to extract data from DCO to my own database, e.g., Microsoft SQL Server. Question: ¿Do you have a procedure and best practices about it? ¿Is there any success story about it?
2. In case customer don´t want to go on with ETL option, is there any alternative to deploy DCE & DCO over SQL server ?
That´s the case customer is so comfortable with Power monitoring expert based on SQL and they want the same for DCE & DCO.
Thank you in advance.
Solved! Go to Solution.
Hi @SESA380953 ,
I don’t know with 100% certainty about DCO but I do not believe that is an option. I will defer to anyone with more info.
As for DCE, there is no option to change the database or directly access the Postgres database. The only option is to use the API if you need direct information from the system.
DCO/ITA cannot be deployed on other systems/databases. However it is possible, both in DCO and ITA, to integrate with external systems through the ETL integration. Based on the ETL system it is possible to develop custom solutions integrating DCO/ITA with a broad range of data sources such as MS SQL. More info available here:
ETL development/integration can be complex and may require advanced engineering knowledge. There is a dedicated team (CSP team) that have a great experience with custom integrations, which you can turn to. If needed you can contact the CSP team for project details, price, etc. Please let me know if you would like to contact the CSP team (I can send you the contact info), thanks.
Hello Victor, you can reach out to Mike Stacey at email@example.com for more information.
He manages the CSP team in NAM.
Discuss challenges and get support in energy and automation with 30,000+ experts and peers.
Over 10,000+ support articles are available to help you find answers to your product and business challenges.
Find peer based solutions to your questions. Provide answers for fellow community members!