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-02 10:54 PM . Last Modified: 2 weeks ago
Has anyone got any experience creating the DCO 7.5 ETL Export DB on SBO Reports Server (MS SQL Server). Thanks
(CID:105461840)
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-02 10:54 PM . Last Modified: 2 weeks ago
Hi Ed, not specifically on SBO Reports Server but I have successfully created and used SQL Server as staging db, please follow the 'External Database' instructions on ETL Database Configuration page.
That said, I would not recommend hosting SBO Reports Server and DCO staging db on the same SQL Server installations, we've seen issues with upgrades and outages when db instances are shared across PME and SBO. If this is for testing/demo purpose, you should be fine, but these databases should be separated out for production.
(CID:105461885)
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-02 10:54 PM . Last Modified: 2 weeks ago
Hi Ed, not specifically on SBO Reports Server but I have successfully created and used SQL Server as staging db, please follow the 'External Database' instructions on ETL Database Configuration page.
That said, I would not recommend hosting SBO Reports Server and DCO staging db on the same SQL Server installations, we've seen issues with upgrades and outages when db instances are shared across PME and SBO. If this is for testing/demo purpose, you should be fine, but these databases should be separated out for production.
(CID:105461885)
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-02 10:54 PM . Last Modified: 2023-10-31 10:49 PM
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 forum - and gain access to more than 10,000+ support articles along with insights from experts and peers.