Datasources: Difference between revisions
From Data Islands
WikiSysopdi (talk | contribs) (data sources) |
WikiSysopdi (talk | contribs) mNo edit summary |
||
| Line 11: | Line 11: | ||
# FOLDERS/FILES | # FOLDERS/FILES | ||
# XERO (xero.com API) | # XERO (xero.com API) | ||
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 to reconcile that data. | |||
Revision as of 13:47, 4 August 2022
Local Servers supported are
- MSSQL
- Postgres
- MySQL
- sqlite
- ODBC
- CSV
- FOLDERS/FILES
- XERO (xero.com API)
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 to reconcile that data.
