Interconnexion commcare and a SQL Server database

Hi
I want to have more information about commare database. If it’s
possible to connect commcare with SQL server. I want to exctract data from
the commcare db and load data to commcare db using SSIS in SQL Server azure
cloud.

How i can do it?

https://lh3.googleusercontent.com/-VNtP9U4jphA/WNpxn68UDNI/AAAAAAAAAHY/dQnc3K9kdHQSHrqM4vkUHrlBtzXh8xQUACLcB/s1600/Architecture.jpg
I provide the tehnical architecture of my project on it

Thanks to reply me

Hi Desir

You can use the commcare-export tool
https://confluence.dimagi.com/display/commcarepublic/CommCare+Data+Export+Tool
to
extract data from CommCare and save it to a SQL database. You could also
use the Data API’s
https://confluence.dimagi.com/display/commcarepublic/Data+APIsdirectly to
extract data.

··· On 28 March 2017 at 16:23, Desir Yrvel wrote:

Hi
I want to have more information about commare database. If it’s
possible to connect commcare with SQL server. I want to exctract data from
the commcare db and load data to commcare db using SSIS in SQL Server azure
cloud.

How i can do it?

https://lh3.googleusercontent.com/-VNtP9U4jphA/WNpxn68UDNI/AAAAAAAAAHY/dQnc3K9kdHQSHrqM4vkUHrlBtzXh8xQUACLcB/s1600/Architecture.jpg
I provide the tehnical architecture of my project on it

Thanks to reply me


You received this message because you are subscribed to the Google Groups
“commcare-users” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Simon Kelly
Director of Server Engineer | Dimagi