Ask our Experts
Didn't find what you are looking for? Ask our experts!
Schneider Electric support forum about installation and configuration for DCIM including EcoStruxure IT Expert, IT Advisor, Data Center Expert, and NetBotz
Search in
Link copied. Please paste this link to share this article on your social media post.
Posted: 2020-07-02 10:54 PM . Last Modified: 2024-04-09 01:18 AM
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: 2024-04-09 01:18 AM
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: 2024-04-09 01:18 AM
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.
You’ve reached the end of your document
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.