Datamart Setup Command Line
Use these commands to install Datamart from the command line.
Setup [action] [instance] [options]
Note that you need a colon between the argument and the value, like this:
Setup-VersionOne.DatamartLoader-17.3.1476.2 -Quiet -Action:Install -InstanceDir:"c:\Program Files\VersionOne\VersionOne173 to VersionOne173-datamart" -EnterpriseDbServer:dnix\versiononesql -EnterpriseDbName:VersionOne173 -DatamartDbServer:dnix\versiononesql -DatamartDbName:VersionOne173-datamart -AnalyticsDbServer:dnix\versiononesql -AnalyticsDbName:VersionOne173-analytics
| Argument | Values | Comments |
|---|---|---|
| (default arg) | Instance Name | This is the default argument for setup |
| -Action | Install, Uninstall, Upgrade | |
| -LogFile | FileName.txt | default is "setup.log" |
| -Quiet | (none) | Suppress all wizard/confirmation UI; Will show error messages. Good for automated setups run by humans. |
| -VeryQuiet | (none) | Suppress all UI, including error messages. Good for full automation (e.g. Hostess). |
| -DeleteDatabase | true,false | Will remove Datamart database (uninstall only) |
| -InstanceDir | Installation Path | Default is %ProgramFiles%\Instance Name> |
| -EnterpriseDbServer | SQL Server Address | |
| -EnterpriseDbUser | username | SQL user for installation work. Omit for integrated auth. |
| -EnterpriseDbPassword | password | SQL password for installation work. Omit for integrated auth. |
| -EnterpriseDbName | Database name | SQL Database where Digital.ai Agility (Core) data will be loaded from. Must be an Enterprise or Ultimate Product |
| -DatamartDbServer | SQL Server Address | |
| -DatamartDbUser | username | SQL user for installation work. Omit for integrated auth. |
| -DatamartDbPassword | password | SQL password for installation work. Omit for integrated auth. |
| -DatamartDbName | Database name | SQL Database that ETL will load. Will be created if it doesn't exist. |
| -AnalyticsDbServer | SQL Server Address | |
| -AnalyticsDbUser | username | SQL user for installation work. Omit for integrated auth. |
| -AnalyticsDbPassword | password | SQL password for installation work. Omit for integrated auth. |
| -AnalyticsDbName | Database name | SQL Database Analytics application data. Will be created if it doesn't exist. |
| -UseExistingUser | true/false (false is default) | |
| -cleanlog | (none) | Reset datamart load (for when it is stuck at a certain percentage) |