Welcome to the new Schneider Electric Community

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

  • Explore the new navigation for even easier access to your community.
  • Bookmark and use our new, easy-to-remember address (community.se.com).
  • Get ready for more content and an improved experience.

Contact SchneiderCommunity.Support@se.com if you have any questions.

Close
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
84589members
353854posts

General system recommendations for external ETL database servers

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.

Solved
DCIM_Support
Picard
Picard
0 Likes
2
221

General system recommendations for external ETL database servers

This question was originally posted on DCIM Support by Greg Sterling on 2017-01-23


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)


Accepted Solutions
DCIM_Support
Picard
Picard
0 Likes
0
221

Re: General system recommendations for external ETL database servers

This answer was originally posted on DCIM Support by Jef Faridi on 2017-02-02


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)

See Answer In Context

2 Replies 2
DCIM_Support
Picard
Picard
0 Likes
0
222

Re: General system recommendations for external ETL database servers

This answer was originally posted on DCIM Support by Jef Faridi on 2017-02-02


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)

DCIM_Support
Picard
Picard
0 Likes
0
221

🔒 Closed

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