General system recommendations for external ETL database servers

DCIM_Support · ‎2020-07-03

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?

DCIM_Support · ‎2020-07-03

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

See Answer In Context

DCIM_Support · ‎2020-07-03

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

DCIM_Support · ‎2020-07-03

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