Installing PAI Advanced on the AutoPilot Server
Installing PAI Advanced on the AutoPilot Server with Linux
1. Sign in to the AutoPilot Server as the administrative user.
2. Edit the AutoPilotServer.properties file in the $SERVIGISTICS_HOME/AutoPilot/AutoPilotServer.properties directory and set the following properties:
◦ servigistics.analytics.sf.dburl=jdbc:snowflake://<account>.<region>.snowflakecomputing.com
◦ servigistics.analytics.sf.dbusername=<dbusername>
◦ servigistics.analytics.sf.dbpassword=<encrypted dbpassword>
◦ servigistics.analytics.sf.dbdriver=net.snowflake.client.jdbc.SnowflakeDriver
◦ servigistics.analytics.sf.dbtype=snowflake
◦ servigistics.analytics.sf.warehouse=<warehouse>
◦ servigistics.analytics.sf.database=<database>
◦ servigistics.analytics.sf.schema=<schema>
◦ servigistics.analytics.sf.internalStageName=<stage>
◦ servigistics.analytics.sf.csvpath=<directory path>
◦ servigistics.analytics.fillrate.horizonDays=30
◦ servigistics.analytics.jarurl = Path to svg-snowflake-analytics-<version>.jar on the server in the format: file:<jarpath>
◦ servigistics.analytics.sf.csvFileSplitRowCount=<maximum row count>
3. Open a command tool and run the following command to set the environment variables:
. <SERVIGISTICS_HOME>/Servigistics/bin/profile
4. Perform the following steps if AutoPilot is not installed on the same server as WebUI . If AutoPilot is installed on the same server as WebUI, skip to
step 6.
a. Run the following commands to create directories for installing the software:
▪ mkdir $SERVIGISTICS_HOME/PAI
▪ mkdir $SERVIGISTICS_HOME/PAI/dist
▪ mkdir $SERVIGISTICS_HOME/PAI/Jar
b. Run the following command to extract the contents of the distribution file:
unzip $SERVIGISTICS_HOME/PAI/dist/svg-snowflake-analytics-dist-<version>.zip -d$SERVIGISTICS_HOME/PAI/dist
c. Run the following command to copy the Snowflake analytics jar:
cp $SERVIGISTICS_HOME/PAI/dist/svg-snowflake-analytics.jar $SERVIGISTICS_HOME/PAI/Jar
d. Run the following commands to create directories for the scripts:
▪ mkdir $SERVIGISTICS_HOME/PAI/Scripts
▪ mkdir $SERVIGISTICS_HOME/PAI/Scripts/PAI
▪ mkdir $SERVIGISTICS_HOME/PAI/Scripts/SPO
5. Perform the following steps to use scripts for initiating the building of Intellicus Analytical Objects from the AutoPilot server.
a. Create directories for the scripts
▪ mkdir $SERVIGISTICS_HOME/PAI/Scripts/PAI/Intellicus
▪ mkdir $SERVIGISTICS_HOME/PAI/Scripts/SPO/Intellicus
b. Run the following command to extract the scripts for building Intellicus Analytical Objects for Foundation Reports:
unzip $SERVIGISTICS_HOME/PAI/dist/svg-foundation-report-scripts.zip -d$SERVIGISTICS_HOME/PAI/Scripts/SPO/Intellicus
c. Run the following command to extract the scripts for building Intellicus Analytical Objects for Advanced Reports:
unzip $SERVIGISTICS_HOME/PAI/dist/svg-advanced-report-scripts.zip -d$SERVIGISTICS_HOME/PAI/Scripts/PAI/Intellicus
d. Replace all occurrences of USER_INSTALL_DIR in the scripts with the path to the directory where Servigistics is installed.
e. Validate the following property settings in the AutoPilot.properties file.
|
Property
|
Value
|
|
servigistics.intellicus.reportserverurl
|
<Intellicus Server URL>
|
|
servigistics.intellicus.reportserveruser
|
<Intellicus User Id>
|
|
servigistics.intellicus.reportserverpassword
|
<Intellicus Password>
|
|
servigistics.intellicus.reportserverorganization
|
Servi
|
|
servigistics.intellicus.reportserverport
|
<Intellicus Port Number>
|
|
servigistics.intellicus.reportserverip
|
<Intellicus IP Address>
|
|
servigistics.analytics.pi.demandmiss.calc.horizonslices
|
Default is 12
|
|
servigistics.analytics.pi.demandmiss.retainslices
|
Default is 6
|
Installing PAI Advanced on the AutoPilot Server with Windows
1. Sign in to the AutoPilot Server as the administrative user.
2. Edit the AutoPilotServer.properties file in the %SERVIGISTICS_HOME%\AutoPilot directory and set the following properties:
◦ servigistics.analytics.sf.dburl=jdbc:snowflake://<account>.<region>.snowflakecomputing.com
◦ servigistics.analytics.sf.dbusername=<dbusername>
◦ servigistics.analytics.sf.dbpassword=<encrypted dbpassword>
◦ servigistics.analytics.sf.dbdriver=net.snowflake.client.jdbc.SnowflakeDriver
◦ servigistics.analytics.sf.dbtype=snowflake
◦ servigistics.analytics.sf.warehouse=<warehouse>
◦ servigistics.analytics.sf.database=<database>
◦ servigistics.analytics.sf.schema=<schema>
◦ servigistics.analytics.sf.internalStageName=<stage>
◦ servigistics.analytics.sf.csvpath=<directory path>
◦ servigistics.analytics.fillrate.horizonDays=30
◦ servigistics.analytics.jarurl = Path to svg-snowflake-analytics-<version>.jar on the server in the format: file:<jarpath>
◦ servigistics.analytics.sf.csvFileSplitRowCount=<maximum row count>
3. Open a command tool.
4. Navigate to the <SERVIGISTICS_HOME>\Servigistics\bin directory and run the following command to set the environment variables:
env.bat
5. Perform the following steps if AutoPilot is not installed on the same server as WebUI. If AutoPilot is installed on the same server as WebUI, then skip to
step 7
a. Run the following commands to create directories for installing the software:
▪ mkdir %SERVIGISTICS_HOME%\PAI
▪ mkdir %SERVIGISTICS_HOME%\PAI\dist
▪ mkdir %SERVIGISTICS_HOME%\PAI\Jar
b. Run the following command to extract the contents of the distribution file:
7z x %SERVIGISTICS_HOME%\PAI\dist\svg-snowflake-analytics-dist-<version>.zip -o%SERVIGISTICS_HOME%\PAI\dist
c. Run the following command to copy the Snowflake analytics jar:
copy %SERVIGISTICS_HOME%\PAI\dist\svg-snowflake-analytics.jar %SERVIGISTICS_HOME%\PAI\Jar
d. Run the following commands to create directories for the scripts:
▪ mkdir %SERVIGISTICS_HOME%\PAI\Scripts
▪ mkdir %SERVIGISTICS_HOME%\PAI\Scripts\PAI
▪ mkdir %SERVIGISTICS_HOME%\PAI\Scripts\SPO
6. Perform the following steps to use scripts for initiating the building of Intellicus Analytical Objects from the AutoPilot server.
a. Create directories for the scripts
▪ mkdir %SERVIGISTICS_HOME%\PAI\Scripts\PAI\Intellicus
▪ mkdir %SERVIGISTICS_HOME%\PAI\Scripts\SPO\Intellicus
b. Run the following command, or use the built-in Windows extract program, to extract the scripts for building Intellicus Analytical Objects for Foundation Reports:
7z x %SERVIGISTICS_HOME%\PAI\dist\svg-foundation-report-scripts.zip -o%SERVIGISTICS_HOME%\PAI\Scripts\SPO\Intellicus
c. Run the following command, or use the built-in Windows extract program, to extract the scripts for building Intellicus Analytical Objects for Advanced Reports:
7z x %SERVIGISTICS_HOME%\PAI\dist\svg-advanced-report-scripts.zip -o%SERVIGISTICS_HOME%\PAI\Scripts\PAI\Intellicus
d. Replace all occurrences of USER_INSTALL_DIR in the scripts with the path to the directory where Servigistics is installed.
e. Validate the following property settings in the AutoPilot.properties file.
|
Property
|
Value
|
|
servigistics.intellicus.reportserverurl
|
<Intellicus Server URL>
|
|
servigistics.intellicus.reportserveruser
|
<Intellicus User Id>
|
|
servigistics.intellicus.reportserverpassword
|
<Intellicus Password>
|
|
servigistics.intellicus.reportserverorganization
|
Servi
|
|
servigistics.intellicus.reportserverport
|
<Intellicus Port Number>
|
|
servigistics.intellicus.reportserverip
|
<Intellicus IP Address>
|
|
servigistics.analytics.pi.demandmiss.calc.horizonslices
|
Default is 12
|
|
servigistics.analytics.pi.demandmiss.retainslices
|
Default is 6
|