• State Not Answered
  • Replies 1 reply
  • Subscribers 11 subscribers
  • Views 7 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Data and Records

How to View On-Premises SQL Server Data via Appian

hatsuneo5962
Certified Associate Developer

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

  Discussion posts and replies are publicly visible

  • 0
    Certified Lead Developer

    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!

© 2025 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.