Article referenced : https://support.tibco.com/s/article/How-to-Connect-to-Databases-and-Query-Datasets-in-Enterprise-Manager details how database connections can be made to relational data sources and how an enterprise data configuration can be created from the database connection. This article specifically details how a data configuration can be created for a Statistica spreadsheet stored in disk or in Enterprise Manager.

Prerequisites:
1. Statistica Enterprise Installation
2. User permissions in Statistica Enterprise that is System Admin (SADM) or alternatively Database Admin (EXTDB_ADM) and Data Admin (DADM)

How to create data configurations for Statistica spreadsheets ?

1. Login to Statistica Enterprise Manager as a user with permissions detailed in the prerequisites.
2. Right Click on Database Connections and choose "New OLEDB Database Connection"



3. In the Data Link Properties Dialog, Choose "Statistica OLEDB Provider " in the Provider tab and click Next.Note that this provider is installed for Statistica installations automatically.



4.  Select the folder that has the Statistica spreadsheets that you'd like to use as the data source. For illustration, we have used the example datasets that come by default with Statistica installation below. If the data source is a statistica spreadsheet/folder within Enterprise, the data source path can be entered "enterprise:/" followed by the system view path in the Enterprise Manager. The easiest way to get the system view path of an object stored in Statistica Enterprise manager is detailed in : https://support.tibco.com/s/article/How-to-get-the-system-view-path-of-an-object-in-Statistica-Enterprise-Manager

You can test the connection optionally and save the database connection with an appropriate name. If Enterprise is configured for Audit log reason, enter a reason when prompted and commit the changes with access permissions for the database connection as shown below.



5. In a System View Folder of choice, right click and choose "New Data Configuration"



6.Enter SDMS Versioning information if Enterprise manager is configured to version. Name your data configuration and pick the database connection created in Step 4. Click on New next to the Queries and then SQL Wizard to select the Statistica spreadsheet as if it were a table in a relational database. Define the query and click on the green arrow to finalize the query the data configuration will use.



7. Click Commit button on the left hand corner of Enterprise Manager to save the changes. Define Access permissions for the data configuration and Enter versioning information if prompted to save the changes. Explore the Data configuration to bring data back into Statistica to analyze the data in Statistica. Analysis configurations can be built off this Data Configuration in Statistica Enterprise. If using a workspace for the analysis, the Enterprise data configuration node can be used to make this spreadsheet part of a workflow.



 

https://support.tibco.com/s/article/How-to-Connect-to-Databases-and-Query-Datasets-in-Enterprise-Manager
https://support.tibco.com/s/article/How-to-get-the-system-view-path-of-an-object-in-Statistica-Enterprise-Manager