Enhanced Data Pipeline is available to customers that are on Premier Support with High Availability. Customers must also be using Appian version 18.3 or higher. Appian customers must purchase Premier Support to use the functionality described below. The functionality described below is not included in the base Appian platform.
Appian Cloud provides customers with a dedicated RDBMS instance to optionally use as a business data source.
Appian Cloud customers enrolled in Premier Support can connect directly to their business data source and utilize their data management tools such as Extract Transform Load (ETL) processes, business intelligence, data warehousing and reporting.
Enhanced Data Pipeline enables a native endpoint to connect to the business data source on an Appian Cloud instance and to integrate it further with your data processing procedures. Some benefits include:
Appian Premier Support will create a database user in your business data source with read-only privileges for client authentication purposes. You will then configure your database client tools with these credentials, along with required security connection parameters.
Database traffic between your tools and the business data source will be forwarded over an IPSec VPN tunnel established to your Appian Cloud instance. As an additional security mechanism, connections to your business data source will be encrypted using SSL/TLS to a custom hostname
<your-instance>.db.appiancloud.com. To prevent certificate errors in your applications, you may need to install the
*.db.appiancloud.com certificate in the appropriate trusted certificate stores for your tools and systems. Installing third-party certificates varies on each tool and platform. Please consult your tool’s documentation on how to connect to an external database using SSL/TLS and how to import a third-party certificate.
Customers who want to leverage this service are advised to test and plan for the additional database load and processing generated by the external queries accordingly. Appian recommends extracting customer's data from the Cloud business data source during periods of low usage. Typically, connecting data analysis tools directly to production transactional databases is not considered a good practice as queries generated by heavily used reporting tools could have performance implications in production instances.
|Premier Support (including High Availability Order Form||This offering is available via Premier Support (including High Availability)||Business relationship owner|
|Upgrade to Appian 18.3 or most recent release||Appian Cloud site(s) with this feature enabled should be running version 18.3 or above.||Authorized Support Contact|
|Set up IPSec VPN Tunnel||Configure VPN tunnel(s) from your corporate network to your Appian Cloud instance.||Network Administrator / Authorized support contact|
|Set up name resolution||Your database tools and any other on-premise systems will connect to your business data source using the FQDN
<newpassword>with a random value that you generate.
1 ALTER USER USER() IDENTIFIED BY '<newpassword>';
On This Page