Installing Data Mart ETL
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.
VersionOne runtime database server
- 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.
VersionOne runtime database
Specify the database user
How you answer this question determines which credentials are used by the ETL when connecting to the VersionOne 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 VersionOne 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. |
- 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
- 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
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. |
- 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
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
Specify the database user
How you answer this question determines which credentials are used by the ETL when connecting to the Analytics metadata 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 Analytics metadata 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. |
- 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.
Installation Directory
You can type another sub-directory name, or use the Choose" button to select an existing folder on your machine. We do not recommend that you change this sub-directory name, or location, unless absolutely necessary.
Should the database be preserved or deleted?
When removing an instance of the VersionOne Data Mart, you need to decide if you want the database destroyed. If you choose delete, the database is removed and cannot be recovered, unless you have a backup.
Setup is ready to perform the following actions:
Please wait while Setup installs ....
This panel allows you to view the progress of the changes being made.