What action do you want to take?
If an existing instance of the Data Mart ETL is detected on the machine, you are presented with a panel that requires you to choose an action before proceeding. The default action is to upgrade the existing instance. You may also remove an instance or install a new instance.
Select from these installed instances
When upgrading or removing an instance you must specify an instance for the action. This panel is only presented if more than one instance is installed on the machine. Once you choose an instance, the next button is enabled.
Agility runtime database server
The Data Mart setup utility will configure the ETL connection to the Agility runtime database. Therefore, Setup needs to know which database server hosts the Agility runtime database. On this panel, you must specify the database server hosting the Agility runtime database and provide the credentials that Setup will use to connect to that server.
Note
The credentials provided here are only used by Setup; these are not the credentials used by the Data Mart ETL application.
How do I resolve the "Cannot Connect to Database" error message?
This error indicates that Setup cannot connect to the database server you specified. A common cause for is specifying only the machine name and omitting the SQL Server instance name. To include the instance name, use the format "[machine_name]\[instance_name]." For example, if you're installing on a local server in which both IIS & SQL are running, and the instance name is SQLEXPRESS (the name that express uses when installing), you would use "(local)\SQLEXPRESS." If the server is a remote server, use the actual machine name.
Digital.ai runtime database
On this panel, specify the Agility runtime database that will be used by the ETL when extracting data. You can think of this as the ETL source database. Each time the ETL is executed, it will read from this database.
Specify the database user
How you answer this question determines which credentials are used by the ETL when connecting to the Agility runtime database. Your options are:
| Option | Description |
|---|---|
| Let setup create a user | With this option, Setup will create a new user on the database server and assign that user to the Agility database. The username and password are randomly generated. Additionally, when the instance is upgraded, new credentials are created. |
| My DBA Provided Credentials |
In some environments, access to databases is controlled. If your DBA provided you credentials, choose this option and enter the credentials you were given. These credentials are kept in a user.config file located in the ETL sub- directory. |
Note
If you choose the "My DBA Provided Credentials" option, Setup will not manage your user credentials on upgrade. If you need to change the credentials at a later date you will need to edit the user.config file to perform the update.
Data Mart database server
The Data Mart setup utility will configure the ETL connection to the Data Mart database. Therefore, Setup needs to know which database server is hosting the Data Marat database. On this panel you must specify the database server hosting the Data Mart database and provide the credential that Setup will use to connect to that server.
It's important to note that the credentials provided here are only used by Setup; these are not the credentials used by the Data Mart ETL application.
How do I resolve the "Cannot Connect to Database" error message?
This error indicates that Setup cannot connect to the database server you specified. A common cause for this error is specifying only the machine name and omitting the SQL Server instance name. To include the instance name, use the format "[machine_name]\[instance_name]." For example, if you're installing on a local server in which both IIS & SQL are running, and the instance name is SQLEXPRESS (the name that express uses when installing), you would use "(local)\SQLEXPRESS." If the server is a remote server, you'd use the actual machine name.
Data Mart database
This is where you specify the actual name of the Data Mart database. You can think of this database as the ETL destination database. Each time the ETL is executed, it will write data to this database.
The default name for this database is "[Agility Database Name]-datamart." For example Agility-datamart. This name helps you quickly identify the Agility instance used to populate the Data Mart. We do not recommend changing the database name.
Specify the database user
How you answer this question determines which credentials are used by the ETL when connecting to the Data Mart database. Your options are:
| Option | Description |
|---|---|
| Let setup create a user | With this option, Setup will create a new user on the database server and assign that user to the Data Mart database. The username and password are randomly generated. Additionally, when the instance is upgraded, new credentials are created. |
| My DBA Provided Credentials |
In some environments, access to databases is controlled. If your DBA provided you credentials, choose this option, and enter the credentials you were given. These credentials are kept in a user.config file located in the ETL sub- directory. |
Note
If you choose the "My DBA Provided Credentials" option, Setup will not manage your user credentials on upgrade. If you need to change the credentials at a later date you will need to edit the user.config file to perform the update.
Analytics metadata database server
Customers that have the Agility Ultimate edition, will see additional panels necessary to configure the Analytics metadata database.
For Ultimate Edition customers, the Data Mart setup utility will configure the ETL connection to the Analytics metadata database. Therefore, Setup needs to know which database server is hosting the Analytics meta-data database. On this panel, you must specify the database server hosting the Analytics metadata database and provide the credential Setup will use to connect to that server.
It's important to note that the credentials provided here are only used by Setup; these are not the credentials used by the Data Mart ETL application.
How do I resolve the "Cannot Connect to Database" error message?
This error indicates that Setup cannot connect to the database server you specified. A common cause for this error is specifying only the machine name and omitting the SQL Server instance name. To include the instance name, use the format "[machine_name]\[instance_name]" For example, if you're installing on a local server in which both IIS & SQL are running, and the instance name is SQLEXPRESS (the name that express uses when installing), you would use "(local)\SQLEXPRESS." If the server is a remote server, you'd use the actual machine name.
Analytics metadata database
This is where you specify the actual name of the Analytics metadata database. This too is a destination database to the ETL. Each time the ETL is executed, it will write data about Custom Attributes defined in your Agility instance to this database.
The default name for this database is "[Agility Database Name]-analytics"; for example, Agility-analytics. This name helps you quickly identify the Agility instance used to populate this database. We do not recommend changing the database name.
Comments
Please sign in to leave a comment.