Connecting CXO-Cockpit to databases on a different SQL server

Owned by Former user (Deleted)
Last updated: Jul 06, 2016
3 min read

In some cases it might be necessary to move the databases used by CXO. CXO always uses at least 2 databases, cxo_master and a cxo_repository database. If you use HFM with CXO there will also be a cxo_staging and a cxo_fact database, there will also be a SSAS cube database, but we can create a new one out of the fact and staging databases.

Prerequisite; 

  • Make sure the same user is created on the new SQL environment with db_owner access for the CXO databases or create a new user that has db_owner access to the CXO databases
  • If you use HFM together with CXO make sure SQL Analysis Server is also included on the new SQL environment

Here are the steps described for connecting CXO to databases on a different SQL server:

  • Check which SQL user CXO uses, you can find the correct username when you start the CXO configurator:
  • Stop all services through the CXO configurator Maintenance tab and close the CXO configurator:
  • Move/copy the databases to the new SQL server and make sure the CXO SQL user has access to the same databases with db_owner access
  • If you copied the databases you can start the CXO configurator and change the master database connection by entering the new SQL connection details:
  • If the "old" SQL environment/databases is not available anymore the configurator will ask for the CXO_master details and you can enter the new SQL connection details in the same screen.
  • Now click on the "Upgrade config files", this will make sure the new master connection is updated in all the CXO configuration files.
  • Go to applications and change the repository database connection to match the new SQL environment, click OK and Save.
  • Connecting CXO-Cockpit to databases on another SQL server is now finished

 

  • The following steps are only needed if you extract HFM data into CXO
  • Start the CXO design studio and go to the maintain system settings
  • Make sure the new Microsoft Analysis Server name is correct and click save and click "Create New"
  •  
  • Click "Create OLAP database" and click "OK". Do note, that depending on how big your fact database is this can take anywhere from 5 minutes to 1 hour.
  • After it's finished this message will appear
  • Connecting CXO-Cockpit to databases on another SQL server together with the SQL CXO SSAS cube is now finished

 

 

 

 

 

 

 

 

Â