Configuring Data Sources

Note

You must configure one Data Source per ERP system used, and one for the OLAP cubes.

Please refer to the ERP’s template documentation to configure them.

Environments and Data Sources

Tip

The description given to a data source created for the first time is used throughout the environments to describe this specific data source.

Give a generic description for the first time (e.g., ERP Data Source, Cube Data Source) and if necessary, rename it after the first environment has been created.

The following information is needed to configure the data sources:

  • Database server credentials: Server name, Instance, Authentication strategy.
  • Main ERP database information: Database and schema name.
  • Users: Make sure to have created SQL or Oracle users beforehand.

ERP Data Source

  1. In the upper-right hand corner, click on the to access the Administration section.

  2. On the left pane, select Env. & Data Sources.

  3. By default, there is already an environment called Production, which you can rename by double-clicking in the name box. Once changed, press the Enter key.

  4. In the Data Sources section, click Add to create the first data source.

  5. Complete the ERP Data Source configuration. See instructions for MS SQL Server and Oracle below.

  6. Click Validate and then Save to complete the configuration of the data source.

For the SQL Server database

Oracle instructions follow

ERP Data Source Fields for SQL Server Description
Data Source Description Universal Data Model Data Source
Type SQLSERVER
Server Database server of Universal Data Model
Database Name Name of the Universal Data Model database (beware of the case sensitivity)
Database Schema Name

Create the two following entries by clicking on the icon (replace DatabaseName by the appropriate value):

DatabaseName.dbo

DatabaseName.NEC_CUSTOM_SCHEMA

Note

This second line contains the Nectari Custom Schema.

You can use a different one, but we highly recommend following this naming convention:

  • Start with NEC
  • Use all capitals
  • Separate words by an underscore
Note  

The application searches for tables in the same order as the schemas are listed. As soon as a table is found in any schema, the application will stop searching. Therefore, if you have multiple tables with the same name in different schemas, please ensure that the schema containing the table you want to use appears first.

Important

Choose a unique Custom Schema name for each Environment.
Nectari schema Enter the chosen Nectari custom schema for the current environment
Authentication Strategy UseSpecific
User Name

SQL User accessing the Universal Data Model database. For example, sa.

This is the same user you created in Creating SQL Users .
Password The user's password.

For the Oracle database

ERP Data Source Fields for Oracle Description
Data Source Description Universal Data Model Data Source
Type ORACLE
Server Name of the Oracle server
SID Name of Universal Data Model database instance.
Port Port number of Universal Data Model database instance.
Database Schema Name

Create 2 entries by clicking on the + icon:

dbo

NEC_CUSTOM_SCHEMA

Note

This second line contains the NectariCustom Schema.

You can use a different one, but we highly recommend following this naming convention:

  • Start with NEC
  • Use all capitals
  • Separate words by underscore
Important

Choose a uniqueCustom Schema name for each Environment.
Nectari schema Enter the chosen Nectari custom schema for the current environment
Authentication Strategy UseSpecific
User Name

Name of user.

This is the same Oracle user you created in Creating Oracle Users and Tablespaces.
Password Password of the user

Cube Data Source

In the same Environment as the ERP Data Source, create a new Data Source for the OLAP Cube.

Complete the Data Source Definition with all the appropriate information.

Oracle instructions follow

OLAP Data Source Fields for SQL Server Description
Server Database server where the NectariOLAP For SQL Server package is installed.
Database Name NectariCube.
Database Schema Name

NectariCube.NEC_FOLDER (replace FOLDER by the folder name).

Where NEC_FOLDER (replace FOLDER by the folder name) is the schema used in the ERP Database of the same environment.
Nectari schema Enter the chosen custom schema for the current environment.
  1. Click Validate and then Save.
  2. Click Set as Data Warehouse to define the Data Source as a Data Warehouse.

  3. Enter the following information:

    1. Database warehouse schema: Enter the chosen Nectari custom schema again.

    2. Use MARS during the cube loading: Unchecked

  4. Click Validate and then Save.

Tip

Refer to Environments and Data Sources in the Administrator section for more details about the MARS option .

For Oracle Databases

OLAP Data Source Fields for Oracle Description
Server Name of the database server where the Central Point is installed .
SID SID of the Oracle database instance
Port Port of the Oracle database instance
Pooling Activating this option will improve performance (Refer to Environments and Data Sources for more details).
Database Schema Name

NEC_CUSTOM_SCHEMA

Where NEC_CUSTOM_SCHEMA is the custom schema used in the ERP database of the same environment

Nectari schema Enter the chosen Nectari custom schema for the current environment.
Database Warehouse Schema After saving the data source and set it as a data warehouse, enter the chosen Nectari custom schema for the current environment.
  • Click Validate and then Save to complete the configuration of the Data Source.