Skip to main content
H
hatsuneo5962
December 17, 2025
Question

How to View On-Premises SQL Server Data via Appian

  • December 17, 2025
  • 1 reply
  • 0 views

Hi everyone,

We are planning to connect Appian to an on-premises SQL Server environment.

Due to security and network restrictions, Appian developers do not have direct access to the on-premises SQL Server. As a result, we are unable to directly inspect table structures or view data stored in the database during development.

To support smoother development, investigation, and testing activities, we are exploring whether it is possible to view and reference on-premises SQL Server data from Appian.

Specifically, we would like to understand the following:

  • Is it possible to synchronize or replicate data from an on-premises SQL Server to the Appian Cloud Database?

  • If so, is there a way to browse and inspect table data using a GUI similar to the Appian Cloud Database?

Thank you in advance for your help.

Hatsune

1 reply

D
daiw
December 17, 2025

Thats going to be challenging to not see the schema!

A few things I would try ...

  • Ask for Read Only Access to the database in a lower environment maybe?
  • Ask for access to the source control for the database,
  • Ask for someone to run a create script for the database and associated objects, stored procedures, functions etc and create a local install of SQL Server, or other DBMS tools that will work with the flavour of TSQL ... not all work in my experience
  • You might be able to then use this to create a database on Appian Cloud Database as well but it might need some tailoring ... AI is good to help with this. 

Let me know how you get on, but the other thing to consider is to consider how Appian will interact with this database? It sounds like you will not be using Records from what you are saying and how locked away it is?

If you are using Records then consider the ways in which Appian will interact with the database via Records in Design and also execution of data.

Hope this helps!

Terms & ConditionsAccessibility statement