...
Both of these steps are explained in the following procedures.
| Anchor |
|---|
...
|
...
|
A database connection is a pathway from the Data Mart engines that builds data in tables to a database server where a mart schema housing those tables might reside. There are four types of connections:
Connection Type | Description |
|---|---|
1 | Connection to the DATAMART schema in the Eagle warehouse. |
2 | Connection to another Data Mart schema in the Eagle warehouse. |
3 | Connection to a Data Mart schema in another database, of the same type of database management system (SQL Server or Oracle) as the Eagle warehouse. |
4 | Connection to a Data Mart schema in another database, of a different type of database management system than the Eagle warehouse (SQL Server if Eagle is on Oracle or the reverse). Note that use of this connection type is an early adopter option in Eagle V10.0. |
- Connection Types 1 and 2 are both to the same database server, the one housing the Eagle data warehouse. This is the default connection and does not require any setup in the Manage Database Connections dialog box.
- Connection types 3 and 4 require setup in the Manage Database Connections dialog box. They involve links to database servers outside the Eagle warehouse. These servers can be located anywhere in the world. You can set them up with Mart instances as long as you can communicate with them and have privileges to write to the mart tables you create there.
...
Continue with the next procedure of Registration a Mart Instance..
...
| Anchor |
|---|
...
|
After you register a multiple marts database connection, you must then register a Mart instance in that database before you can configure it or load data to its tables. You do not have to do this for the default mart instance, the DATAMART schema in the Eagle data warehouse provided with Eagle PACE. However, you can use the access control settings on the right side of the dialog box to manage access to the DATAMART schema.
...
- From the Data Mart window, click Manage Data Marts.
You see the Define Data Mart Instance dialog box. - In the Name box, enter a name for the mart instance.
This name is important to the migration process for multiple marts. A given mart instance must have the same Name in all environments for which you want to use migration to update changes from, for example, Test to Production. - Enter a description of the Mart instance in the Description box.
Text you enter here appears in the Data Mart Instance dropdown list - In the Table Space box, enter the name of the database schema of this mart instance.
- In Database Connection dropdown, select a connection you previously registered in the Define Database Connection dialog box.
- To see if you should select the Enable Internationalization check box, refer to the section to Data Mart Multilingual Configuration.
- In the Comments box, enter any useful information about this instance.
- Select Give Access to Everyone or Give access to specified users or Business Groups to determine whether or not to restrict access to the Data Mart user interface for this instance.
If you restrict access, you must specify one or more users or business groups who can have access. This setting does not affect access to the tables of the database schema associated with this instance. That access is not controlled from the Eagle application.
...