Export data from OutSystems application into a local SQL database?
Application Type
Traditional Web

Any ideas f it's possible to export data from a list maintained on the cloud in outsystems into a local SQL Server database so we don't have to maintain parallel systems please? Integration seems to be only seen as outsystems consuming data from external DBs but not giving any back!!!

HI Jane,

What do you mean by  local SQL database ? Is it like  Sql server database in your local machine ?

Best Regards

Devendra


Yes currently on a server but it could be moved either into the cloud or onto another server.

Hi Jane,

Integration with external DB means consume the data as well as manipulate / insert the data.  You can create a timer and can export the data  to external entities.

You can also use some extension which uses sqlbulkcopy like below to export bulk data

https://www.outsystems.com/forge/component-overview/1117/bulkinsert

Best regards'

Devendra

Thanks Devendra  that looks very promising. 

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.