Datasources: Difference between revisions
From Data Islands
WikiSysopdi (talk | contribs) mNo edit summary |
WikiSysopdi (talk | contribs) No edit summary |
||
| (11 intermediate revisions by the same user not shown) | |||
| Line 10: | Line 10: | ||
# CSV | # CSV | ||
# FOLDERS/FILES | # FOLDERS/FILES | ||
# XERO (xero.com API) | # XERO (xero.com API)-readwrite | ||
# ProvideX - See [[Sage_100_ProvideX]] | |||
# Creatio -(oData REST API) readwrite | |||
| Line 19: | Line 21: | ||
You repeat steps a and b to get data from all your silos (systems) into one place and you can then use SQL to reconcile that data. | You repeat steps a and b to get data from all your silos (systems) into one place and you can then use SQL on the data warehouse to reconcile that data. | ||
Latest revision as of 15:37, 28 August 2025
Local Servers supported are
- MSSQL
- Postgres
- MySQL
- sqlite
- ODBC
- CSV
- FOLDERS/FILES
- XERO (xero.com API)-readwrite
- ProvideX - See Sage_100_ProvideX
- Creatio -(oData REST API) readwrite
a. A local server is a server that the console application can connect to. So if you have an e-commerce system you can install the console application, log in, and query the data you want to create an island from and push that into the cloud.
b. You might then want to get that data into a data warehouse so you again install the console app on that server and connect to the local warehouase db and pull the island data back down into that.
You repeat steps a and b to get data from all your silos (systems) into one place and you can then use SQL on the data warehouse to reconcile that data.
