Organizations often have data spread across multiple systems. Whether it's in Salesforce, a relational database, and customer relationship management software, you need easy access to your enterprise data so you can quickly build modern applications.
Appian's data fabric allows you to connect, relate, and secure your enterprise data, regardless of where it lives, so you can easily access the data you need. Appian's data fabric is built using record types with data sync enabled, often referred to as synced record types for short.
As you build your data fabric, you may need to leverage additional design objects to connect and access the data you need, like:
| Record Types | Custom Data Types | Data Stores | Connected Systems | Integrations | Web APIs |
|---|---|---|---|---|---|
 |
 |
 |
 |
 |
 |
This page provides guidance on when to use different Appian design objects to access your enterprise data.
The table below provides a quick overview of when you’d use which object to work with your enterprise data.
| Object | What does it do? | When do I use it? |
|---|---|---|
| Record Type | Allows you to easily connect to data in a database, process model, Salesforce, or other web service. Extend your enterprise data using powerful data modeling capabilities like record type relationships and custom record fields to relate and transform your data. Then, secure it using record-level security. Seamlessly reference this powerful version of your enterprise data using unified record type references, records-powered components, and more. |
|
| Custom Data Type (CDT) | Allows you to define a data structure that represents a logical grouping of data. |
|
| Data Store | Allows Appian to connect to external relational databases to store and retrieve application data. This object is always used in conjunction with a CDT. |
|
| Connected System | Stores authentication and connection information so you can connect to external integrations and data sources. |
|
| Integration | Allows Appian to interact with other systems. Connect to external systems using integration objects and connected systems, then call your integrations in expression rules, interfaces, record types, or process models. |
|
| Web API | Allows other systems to contact Appian. Expose Appian data and services to outside systems using a web API object. |
|
The following examples illustrate the different objects involved in building your data fabric.
Let’s say that you’re building a customer support application to track and report on your support cases. Support engineers will also need to create new cases and update existing ones. Your data currently lives in a database, where you have multiple tables for case, customer, and case priority, and the largest table has 3.4 million rows of data.
Record types with data sync enabled
This is the perfect opportunity to create record types with data sync enabled:
All of your database tables are below the row limit, which means each table can be used to create a record type with data sync enabled.
Tip: If you need to sync more than 4,000,000 rows in a record type, use source filters to divide up large datasets into multiple synced record types, each with a specific purpose.
For example, you could have an Active Case record type to display all open or in progress cases, and a Closed Case record type to display all closed cases.
You can use the Write Records smart service to build processes that add or update data in your database and then automatically sync those changes in Appian. You can then start those processes as record actions in your grids, interfaces, and reports.
Learn more:
Now let’s say you’re creating an HR management application, and you want to add a point of contact for each of your employees. Each point of contact must have at least two methods of communication.
In your database, the point of contact and the contact methods are stored in two separate tables. However, it’s important that the contact and contact method are added at the same time to ensure you have the appropriate information in case of an emergency. In other words, you need to avoid a situation where a contact is added without any contact method information.
Record types with data sync enabled
To write data to different tables at the same time, you can:
On the Contact record type, create a one-to-many relationship with the Contact Method record type and allow it to write related records.
Then, to view the data, you can seamlessly reference the related contact information in queries, reports, and interfaces.
Imagine you’re building an expense report application. All of your expense data currently lives in a third-party system, and you need to pull that data into Appian so you can build an application that analyzes expense trends and patterns.
Connected system
Integration
Record types with data sync enabled
Since Appian needs to call another system in order to view and work with the data in your application, you need to create a connected system and integration specific to your third-party system. This integration will query data from the source system so it's available in Appian.
You can then create a record type with data sync enabled using your integration so you can quickly build insightful reports using your expense data.
Since this application focuses on reporting on existing data, a daily, full sync on the record type should be sufficient to keep the synced data up to date with the external source.
Tip: If you require more frequent syncs, or you want to sync data changed by the Call an Integration smart service, you can configure the Sync Records smart service to sync the records you need. See the scenarios below for more details.
See the Service-Backed Record Type Tutorial for step-by-step instructions on building this type of scenario.
Now let’s say you want to expand the expense report application mentioned in the example above. Not only do you want to create reports on existing expenses, you want to view and report on all unsettled transactions.
Unsettled transactions can occur anytime throughout the day, so you need to ensure that you have the latest data in Appian, even when data is changed in your third-party system.
Connected system
Integration
Web API
Record types with data sync enabled
Since unsettled transactions are logged in your third-party system, you need to create a web API to allow your source system to interact with Appian. Specifically, you need the external system to inform Appian whenever there is new data available so that we can sync the latest data.
To do this, you can generate a web API configured with the a!syncRecords() function. This function allows you to sync a record or set of records in a specific record type.
To generate this web API, you first need to configure a Sync Expression to enable Appian to sync specific rows of data from your external system. This expression requires an integration object that returns data from your source based on their identifiers. You can easily create this second integration object using the existing connected system from the first example.
Once you configure a Sync Expression, you can generate your web API directly from the record type. You can modify the web API as needed, and then add the web API's URL to your source system's webhook configuration.
Now, the source can notify Appian of changed data, and we can then sync the latest data in your record type—allowing you to see up-to-date transaction data.
Finally, let’s say your expense report application now requires a supervisor to approve any high-value expense reports before they can be submitted for reimbursement. To do this, you want to create a process that manages all approval tasks and sends a request to your third-party system to update the expense status.
Connected system
Integration
Record types with data sync enabled
In this scenario, you need to create an integration object that can update the status of an expense report once it is approved by a supervisor.
In the examples above, you created a connected system and an integration to query and view data from your external system. Now, you can reuse your connected system to create another integration object that modifies data in that same system. See the Integration Tutorial for step-by-step instructions on creating an integration that modifies data.
Once you create your integration, you can trigger a status update by adding the integration in your process model. After the approval task, add a Call an Integration smart service to write the latest status to the source.
But you're not done yet, you still need to sync the status change in Appian. To do that, you’d simply add a Sync Record smart service at the end of your process to sync the latest changes to the expense’s status.
Objects that Access Data
