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>
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 5.
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.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
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>
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 5
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.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