How to Connect to Databases and Query Datasets in Enterprise Manager?
Article ID: KB0074176
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 13.2,13.1 |
Description
Issue/Introduction
Resolution
Go to Enterprise Manager, there is a node named "Database Connection", right click on it, and select "New Database Connection".
In the dialog appeared, select the right OLEDB provider for your database where your data are stored,Â
Then click on "Connection" tab in the same dialog, Specify the database Server Name, login authentication for your database, database name, then click on "Test Connection" to make sure the connection is successful.
Click OK. Then give a name to the Database Connection, follow the Enterprise steps to specify access permissions, and then click "Commit" in Enterprise menu to save the database connection.
In Enterprise Manager, under root "Statistica Enterprise" node, create a new folder under that node, right click on the new folder created, select "New Data Configuration".
In the Data Configuration dialog, give a Data Configuration name, select the Database Connection created from step1, click on "New" to create a new data "Query".
In the "Query" dialog, give a name, click on "SQL Wizard" to open the SQL query dialog, Drag the specific data table of interest and select a subset of variables of interest, or write SQL code in the SQL code box, click on the green arrow to execute the SQL query to import the variables selected to Statistica.
The SQL scripts and the properties of the variable columns imported will be listed in Enterprise data query dialog. Click "Commit" to save the data query and data configuration.
3. Once the data table and variables are loaded in Enterprise data configuration, you can proceed to create a "Analysis Configuration" to do your analysis based on data retrieved by Data configuration.
Additional Information
Feedback
