Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
5 replies
Subscribers
5 subscribers
Views
2318 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Integrations
We're hosting an application on Appian cloud with VPN SQL server instance to
Mike
over 10 years ago
We're hosting an application on Appian cloud with VPN SQL server instance to our servers. The end-user of the application is our customer and they are required to provide SQL data views to application processes on a periodic basis. Their SQL views are not exposed via VPN and are not available to us through their firewall, so they need to deliver a back-up or snapshot of data that we then bring into process somehow. We're looking for ideas to read this data when it is not available for direct access. A thought is to have them upload a view or even a csv thru a task form into the knowledge center and then have process read and save the data into a data store. Any good ideas out there? Thanks!...
OriginalPostID-79151
OriginalPostID-79151
Discussion posts and replies are publicly visible
Parents
0
Sathya Srinivasan
Appian Employee
over 10 years ago
In similar line to CSV, is it possible for you to consume the CSV and update your SQL server database (creating temp materialized table, for eg). They can use Appian to upload the document and you can probably write a process to consume and update your DB all through process. The advantage of this approach is that you can work with a higher degree of flexibility in the process if your data is from a DB table rather than having to read the CSV file every time. It also allows you to write extended views etc., to slice and dice the data in the way you want which can be a bit tricky from a CSV.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Sathya Srinivasan
Appian Employee
over 10 years ago
In similar line to CSV, is it possible for you to consume the CSV and update your SQL server database (creating temp materialized table, for eg). They can use Appian to upload the document and you can probably write a process to consume and update your DB all through process. The advantage of this approach is that you can work with a higher degree of flexibility in the process if your data is from a DB table rather than having to read the CSV file every time. It also allows you to write extended views etc., to slice and dice the data in the way you want which can be a bit tricky from a CSV.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data