SYNCING DIRECT WITH MARIADB OR POSTGRESQL

[munirmdee1]

Hi CSPro Users,

I'm working with different surveys, then only way to Sync Data to the server are:
1. CSWEB
2. FTP
3. Local Folder
4. Bluetooth
5.....

But due to the current emerging technologies from new requirements from system users, we now need a way that we can synchronize direct with Postgresql or MariaDB direct without using the above mentioned methods.
The only way to get data someone must download first, in different formats, then you can upload them to those databases. The first methond (csweb) it does syncing with MAriaDB but you cant get the data direct from the MariaDB without Downloading it with CSPro first, now we need a feature that we can synchronize from devices direct to Postgresql or other Relational databases.

That will help us in many ways, first, if we develop our own dashboard which displays status and progress of a survey in real time. but now what we do is first downloading it with CSPro then export in either CSV or other format and then upload them to relational database, this doesn't give us a real time dashboard, and also it will help us from doing some works around to implement it, or using a lot of tools sideways just to archieve it.

Please can this be implemented so that we interact with relational databases in an easy way?

Thank you...

[savy]

While cases in the database are stored in compressed JSON, you can use the blob breakout feature to breakout case data to relational tables. Please see the help documentation here.
https://www.csprousers.org/help/CSWeb/d ... tings.html
The relational table data can be used for reporting or exporting it to other databases. Hope this helps.