Hi I am having 2,60,000 of data in MS SQL Server. How can I bring all the data from MS SQL Server and store it in Appian Cloud database.
Discussion posts and replies are publicly visible
Export -> Import ...
Do you have a specific question?
yes stefanThis is an onsite data i dont have sufficient access to login into ms sql , we have to do it via connected sysyem
Do you need to do this only once?
If yes, I really suggest to ask someone to export the data.
Else, you implement a web API on the target system, and call it from the source system. Send the data in batches.
No It was not a one time processMS SQL Data was real time data every day new data get added into the tables We have to sync it daily & bring that newly added data daily
Did you consider to create a synced record directly on top of that SQL server?
yes we can use that My exact point is to bring that SQL Data and store it in Appian cloud data base, because I need to use this data to run some stored procedures , the SQL data is an On site data don't have sufficient access to use it.
IMHO Appian is not the best option for doing this kind of data transfer.
So, if you have read access from Appian to that SQL server, the implementation seems rather simple. Two records and a looping process to copy the data in batches.