Data Islands is a robust ETL (Extract, Transform, Load) solution for seamlessly managing and analysing data from diverse sources.
Data Islands ensures complete control over your data’s location and flow by creating a data middleware platform. Use this tool for effective data sharing, integration, reconciliation or migration.
Isolated data has limited value, but Data Islands makes it easy to consolidate data from across your organization into a single, unified location—often referred to as a Data Mart.
Unifying your data enables seamless reconciliation across different datasets, ensuring your business operates smoothly. Integrate Accounting, ERP, and eCommerce data to match transactions and quickly identify discrepancies.
Easily schedule and automate data queries with scripts and task managers (such as Task Scheduler on Windows or CRON on Linux). Set SQL queries to run at specified intervals, enabling smooth data export and import across your business or external systems.
Easily and securely share and consume data with partners, resellers, suppliers, distributors, and customers. Data Regions let you isolate data, ensuring that only the relevant information is accessible to each third party.
There’s no need to open your network to external connections. Only selected data is sent out, eliminating the need for access points. Your data resides in the region of your choice—USA, Canada, UK, or Europe—allowing you to choose the data center that best ensures compliance with local data protection laws.
With Data Islands, all you need is the ability to write an SQL query. If you can craft an SQL statement, you can create an island from the query results, making it immediately accessible to users you grant access to—either through the console or the REST API.
The Data Islands web app lets you visualize data stored in the cloud within your chosen regions, as well as the data within the islands. You can also manage access permissions (read-only or read-write) and view other metadata associated with your Data Islands.
For software developers who want direct access to cloud data, we offer a straightforward REST API. We also provide a Postman script to demonstrate just how simple it is to use. Write once, and integrate anywhere.
If SQL alone doesn’t offer enough flexibility for your data transformation needs, you can also use JavaScript to modify data before creating an island. This is perfect for software developers who want to simplify ETL (Extract, Transform, Load) tasks and avoid the complexity of traditional ETL processes.
Outlook/Gmail Integration for Sage 300 & Outlook Integration for Sage 100 and Creatio – Seamlessly extract and integrate data into email, giving your team direct access to key information without leaving their inbox.
MobileX Solution for Sage 300 & 100 – A secure, user-friendly mobile interface for view-only access to essential data on the go.
Add Creatio as a local server and export/import data to it, coming soon in an upcoming release.