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-03 10:16 AM . Last Modified: 2024-04-08 02:36 AM
Customer asked whether we have general system requirements for an external ETL database server. I cannot find this info in our documentation.
Customer is specifically looking for cpu, memory, and disk space recommendations. I see we mention the remote database can be postgres, MS SQL Server, or MySQL. Are there specific versions of these databases we recommend?
(CID:110019809)
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-03 10:16 AM . Last Modified: 2024-04-08 02:36 AM
Hi Greg,
Sorry for the delay - I had a brief discussion with our developers and it seems the most obvious reason for not being able to provide a "general system recommendation" (in this case) is basically it just really depends on the task. And concerning the disc space (for export), I think that could be some percentage of the DCO database itself (roughly saying not bigger than the unzipped backup file).
As far as I know, we have tested with MS SQL server 2008 and 2012, and PostgreSQL is usually tested with the shipped version (currently PostgreSQL 9.5.5).
Kind regards
(CID:110792721)
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-03 10:16 AM . Last Modified: 2024-04-08 02:36 AM
Hi Greg,
Sorry for the delay - I had a brief discussion with our developers and it seems the most obvious reason for not being able to provide a "general system recommendation" (in this case) is basically it just really depends on the task. And concerning the disc space (for export), I think that could be some percentage of the DCO database itself (roughly saying not bigger than the unzipped backup file).
As far as I know, we have tested with MS SQL server 2008 and 2012, and PostgreSQL is usually tested with the shipped version (currently PostgreSQL 9.5.5).
Kind regards
(CID:110792721)
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-03 10:16 AM . Last Modified: 2023-10-22 02:07 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.