Installing Appian Government Procurement Analytics Share Share via LinkedIn Reddit Email Copy Link Print On This Page This content applies solely to Contract Writing, which must be purchased separately from the Appian base platform. This content was written for Appian 24.3 and may not reflect the interfaces or functionality of other Appian versions. Introduction Installing Procurement Analytics (PA) consists of four main steps: Downloading the software package. Deploying PA plug-ins to the Appian environment. Creating the database objects in the business data source. Importing the PA application into the Appian environment. Before starting the installation process, review the System Requirements to ensure all minimum requirements are met. System requirements Appian version 24.3 for PA 1.1. Contract Writing 24.3.2.1 A supported version of a MariaDB or Oracle database as a business data source. Note: If you are not using a compatible version of MariaDB or Oracle, you will need to upgrade to a compatible version before installing PA 1.1. A supported web browser. Step 1: Downloading software package To install PA, you'll need to download the software package that contains the following files you'll use in the remaining setup steps. 01.ProcurementAnalyticsv1.1.0.sql: SQL script for creating the database objects needed for the PA application. ProcurementAnalyticsv1.1.0.zip: Application package to import into Appian. To download the software package: Go to the SUPPORT tab on My Appian. Click the DOWNLOADS tab. Click SOLUTIONS. Find and open Procurement Analytics v1.1.0. In Downloads, click the Procurement Analytics v1.1 link. Click PROCEED to agree to the License Agreement. Select your Relational Database Management System (RDBMS), Data Source, and Primary System Locale, then click CONTINUE. Click the Procurement Analytics v1.1 to download the ZIP file. Unzip the downloaded ProcurementAnalyticsv1.1.0.zip file to access the software installation files. Step 2: Deploying plug-ins You must deploy the Appian Solutions and Content Tools plug-ins for the PA solution to work. The steps for deploying plug-ins differ for an Appian Cloud or self-managed environment. Be sure to note which deployment steps you need for your environment. Appian Cloud Environments To deploy the plug-ins for an Appian Cloud environment: In the target environment, log in as the deployment user. Navigate to the Admin Console. On the left side of the console, click Plug-ins. Click ADD PLUG-INS. Search for and click Appian Solutions. Click DEPLOY. Search for and click Content Tools. Click DEPLOY. Self-Managed Environments To deploy the plug-ins for a self-managed environment: Find the necessary plug-ins on the AppMarket. Follow the Deploying Plug-ins instructions to deploy. Step 3: Creating database objects To create the structure for the database tables, views, and other objects that are a part of the PA application, you will need to run a DDL script in your database. To create the database objects: In your database, run the 01.ProcurementAnalyticsv1.1.0.sql DDL file downloaded in Step 1. Note: This DDL file is optimized for MariaDB or Oracle databases. If you are using a different type of database, the DDL file may need to be modified. Step 4: Importing the application The next step needed is installing the PA application by importing the application files into the target environment. To import the application: In the target environment, log in as the deployment user. Navigate to the Appian Designer. Click IMPORT. Click UPLOAD and choose the ProcurementAnalyticsv1.1.0.zip downloaded in Step 1. Click INSPECT. Review the inspection results. If there are no issues, click IMPORT PACKAGE. NOTE: The import may time out due to file size, but the import will continue in the background. Note: If the business database is not called Appian, a warning will occur when importing the data stores. To fix this, after the import is complete, open each data store object and update the Data Source dropdown list. Feedback Was this page helpful? SHARE FEEDBACK Loading...