Products | Versions |
---|---|
Spotfire Statistica | 12.5 and higher |
Is it possible to use two/multiple database connections in the same data configuration in Enterprise Manager?
When creating a data configuration in Enterprise Manager,only one database connection can be mapped. You will need merge data from different databases before querying them in the same data configuration.
It is recommended customer first create database connections for each different database (e.g. one for Oracle, and the other for SQL), then create data configuration to query the datasheets from each database connection, merge the datasheets into a single combined datasheet, and then create a data configuration querying that merged datasheet.
For example, merge two datasheets from two databases (e.g. Oracle, SQL) and then bring the combined datasheet into Statistica data configuration.
1. First create database connections & data configurations to query the specific datasheets from different databases
2. Merge the multiple specific datasheets into a single one through workspace
3. Bring the merged datasheet from workspace to Enterprise Data Configuration
There are two methods to proceed for this step:
3.1. Use a "write spreadsheet back to database" node.
This will allow user to write the merged spreadsheet back to one of the databases (e.g. Oracle or SQL database connection), if the user has the permission to write back to the databases. Once the merged dataset is written back to the databases, then user can create a simple Enterprise data configuration to query the merged data through database connection. This would be preferred because it would not need any custom SVB code.
3.2. Create and customize a SVB data configuration that call the workspace & deploy the output data from workspace (Note: customized SVB codes need to be developed).