NOTE: The other Enterprise meta database should belong to that of the Statistca installation of the same version. For example, Statistica 13.5 can only be pointed to Statistica 13.5 meta database. If pointed to an older Statistica install, this process will upgrade the meta database to Statistica 13.5 meta database possibly rendering the meta database unusable for older version of Statistica. It is advised that the database is backed up for the older version if there is meta database belongs to an older version of Statistica 

PREREQUISITES:

1. An existing Statistica Enterprise installation (Server or Workstation)
2. Another Enterprise metadatabase (with Statistica Enterprise tables)
3. Server and credentials of the Enterprise meta database
4. Administrator privileges on the machine (Server or workstation)

This article details how Statistica Enterprise can be pointed to another environment (or to a different Statistica meta database)

1. Login as administrator on the machine where Statistica is to be pointed to a different DSN (Data Source Name).
2. Launch Control Panel>>System and Security>>Administrative Tools>>ODBC Data Sources (bit width of Statistica installation)
3. Click on System DSN tab. You will see the Statistica default DSN: SEWSS listed. Click on Add and enter credentials to connect to the Enterprise Database you intend to add.



4.Click OK twice and close the ODBC Data Sources dialog.
5. If Integrated login is enabled in Statistica Enterprise, hold down the shift key while launching Statistica/Statistica Enterprise Manager to bring up the login prompt.
6. Choose the non-default DSN that was defined in Step 3 and enter credentials necessary to login.



7. You may optionally make it user default DSN by enabling User default DSN checkbox while logging in. To make this system default DSN, launch Statistica /Statistica Enterprise Manager as an administrator while also holding the shift key and enable the option to 'Set as system Default DSN'