How to find the metadatabase in a Statistica Enterprise Installation?

How to find the metadatabase in a Statistica Enterprise Installation?

book

Article ID: KB0079235

calendar_today

Updated On:

Products Versions
Spotfire Statistica 10 and later versions

Description

PREREQUISITES:
1. A Machine with Statistica Enterprise installed (Server or Workstation )
2. Administrator privileges on the machine
3. Database login credentials.

Issue/Introduction

How to find the meta database in a Statistica Enterprise Installation?

Resolution

This is only applicable for Statistica Enterprise installations. Statistica Enterprise installations ask for a database during installation. This database is often referred to as the meta database for Statistica. If the user is unsure of which database the Statistica install is pointing to, the following steps can be performed on any machine with Statistica install.

1. Launch Control Panel>> System and Security>>Administrator Tools>> ODBC Data Sources (bit-width of installation). Switch to the 'System DSN' tab
 
User-added image

2.  There will be a DSN named 'SEWSS' . Click on configure. Enter Database credentials if you have to. This will be the database/schema that is Statistica's meta database.

User-added image