A Data Middleware Platform

How it works as a Data Middleware Platform

Your data (that you select to copy to Data Islands) lives physically where you want it to live (We have servers in the USA, Canada, Europe and the UK). Our databases and API’s are all geographically coded so that you control where the data lives (we use digitalocean) and flows (AWS Gateway API) through the data middleware. If you are in the USA for example your data never travels from that geographic region (unless you want it to). 

With Data Islands you do not need to open any ports or access to your network. You only export data you have defined (using SQL for example) out (as opposed to it being pulled out direct from an incoming connection) and so there is no risk or need for trust with those you give access to. 

This is possible by installing our console app (see image) in the secure location that can access your data and the data is pushed out (exported) to the Data Islands Middleware Platform.

This is achieved using simple commands and so can be scripted and automated to run at intervals. 

console status

Data Connectors

ETL projects are hard. You have to define table structures in one database and try map them in another. With Data Islands the data just moves seemlessly with the destination (table or file) just created. It just works.  Extract data from MSSQL and import into MySQL/Postgres/SQLite/csv and it just works in a single command. .SQL, Postgres, CSV, xero, ODBC etc

Supported connectors include

benefits

Data Islands Benefits

Data Islands tick

Data Silos

Data living in isolation has little value but Data Islands makes it easy to get data from anywhere in your organization into one place (sometimes called a Data Mart).

Data Islands tick

Reconcile Data

Bringing your data together allows you to reconcile different datasets ensuring that your business is running correctly. Bring your Accounting, ERP and e-commerce data together and match transactions highlighting any descrepancies.

Data Islands tick

Automate

Using a script and a task manager ( on Windows or CRON on Linux) you can have your data queries (SQL) run at set intervals and export and import your data from across your business or externally.

Data Islands tick

B2B Data Middleware Platform

You can confidently share data and consume data from your partners, resellers, suppliers, distrbutors and customers. Data Regions allow you to segregate data so that only the data that a 3rd party should see is even there to accessed.

Data Islands tick

Data Security and Local Laws

No need to open networks for a system to connect in. Selected Data is only sent out ensuring that no access point in is needed. Your data physically lives where you decide. We have 4 regions covered (USA, Canada, UK and Europe) and you decide which data centre holds the data allowing you to be compliant with the local data laws.

Data Islands tick

Only SQL is needed

To work with Data Islands you only need to know how to write an SQL query. If you can write an SQL statment you can create an island for the SQL query results and right away it is accessible to users you share access with (via the console or from the REST API).

Data Islands tick

Web App

The Data Islands web app allows you to visualise the data stored in the cloud in your regions and the data in the islands as well as seeing what access is allowed (readonly or readwrite) and other metadata on your Data Islands.

Data Islands tick

REST API

If you are a software developer and want to access the data on the cloud direct there is one simple to use REST API to do this. We provide a POSTMAN script that shows how simple this is. Write once and use anywhere.

Data Islands tick

ETL

If SQL on its own does not provide you with enough power to alter the data then you can also use Javascript to update as you need before creating an island. Ideal for software developers looking to avoid the heavy lifting of most ETL (Extract, Transform and Load) projects.

Web App

The Data Islands web app allows you to visualise the data stored in the cloud in your regions and the data in the islands as well as seeing what access is allowed (readonly or readwrite) and other metadata on your Data Islands.

The web app is build using the REST API (see below).

REST API

Most ETL’s now allow you to create and define your own REST API. Why do that when our single API works for all your data. Code once and you are done. We also provide a POSTMAN configuration showing your how to use this.

Need more? Contact us for a demo!

Get Data Islands Console and Web App Links

Request a Demo

Request a Call