From Data Islands

Local Servers supported are

  1. MSSQL
  2. Postgres
  3. MySQL
  4. sqlite
  5. ODBC
  6. CSV
  8. XERO ( 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 on the data warehouse to reconcile that data.