Primary and Secondary Data Stores in Appian

Appian has a primary data store (i.e. database) that it uses to store Appian-related data records, such as the feed items in Tempo, each users’ followers, and locks when editing application objects in the designer. The data in this data store ensures that Appian is working properly.

Appian can be used to connect to secondary data store(s) that contain business data records, such as Purchase Orders, and Stock Inventory. Processes/Workflows in Appian perform operations on the data in these secondary data stores to complete business objectives. This allows the business to reuse their existing applications, instead of replacing them.

One example is to generate a Purchase Order report across the last 5 years. The Payment Advice records may exist in a separate legacy database that was previously set up. All Appian needs to do is to configure the legacy database as a data source, and the records within can be used.

The advantages of being able to add secondary data store(s) are:

  • Cost Effective – reuse existing data stores
  • Shorter Development Time – no migration of data
  • Use Existing Data Protection Mechanisms – no need to audit a new setup
  • Modular – Business databases can be scaled / modified to meet other requirements (e.g. audit) without impacting Appian’s primary data store

The primary data store is configured when installing Appian. The secondary data store can be added at installation time, or via the Admin Console after installation (recommended). This post will run through the steps for the latter approach.

Pre-requisite

  • A running instance of Appian
  • System Administrator account of the Appian instance
  • JBoss Application Server should have the corresponding connectors for the intended secondary data source

Steps

Step 1: Login as System Administrator, and open the Admin Console

Step 2: In the Left Menu Panel, select “INTEGRATION > Data Sources”

Step 3: In the “Data Source Management” (right panel), select “New Data Source”

Step 4: Enter the required details as follows:

  • Name refers to JNDI name of the data source
  • Type refers to the type of database (e.g MySQL, Oracle)
  • Username refers to the database user
  • Password refers to the database user’s password
  • Connection String refers to the database connection string, which should look like this: jdbc:(database)://(server IP):(port)/(database_name)

Step 5: Click on the “Test Connection” button to ensure that Appian can connect to the database

Step 6: Click on “Save” to save the new configuration

 

You’re good to go! 🙂

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s