Main Page: Difference between revisions
No edit summary |
WikiSysopdi (talk | contribs) No edit summary |
||
| (20 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
<strong> | <strong>Welcome to the Data Islands Help</strong> | ||
Check out our website at [https://crmtogether.com/products/data-islands/?utm_source=mediawiki&utm_medium=online+help&utm_campaign=acbot&utm_id=dihelp here] | |||
''-What is Data Islands?'' | |||
Data Islands is an online service that allows you to move data from various data sources securely (data integration). | |||
You can also create Micro Data Warehouses (or Data Mart) and manage access to that Data. | |||
''-What is a Micro Data Warehouses?'' | |||
A Micro Data Warehouses is a collection of datasets that contain small amounts of data fed from your "Data Silos" EG: databses (MSSQL, MySQL,Postgres), CSV,XERO api and Creatio API (or any REST API). | |||
-''Why would I need a Micro Data Warehouses?'' | |||
Its a great way to protect sensitive data by limiting what data is available in the mart. Micro Data Warehouses contain aggregated and subsets of data making them more easily consumed by end users. | |||
''-What is a Data Silo?'' | |||
A Data Silo is a dataset/database/csv that is not accessible outside of your network or a subset within that network. | |||
Typically a single Data Silo will be an ERP or Accounting system or a CRM system or even CSV files. It could be any proprietary database also. | |||
This data is isolated ("siloed") for various reasons, typically security and also confidential information. | |||
''-So would I be sharing confidential information?'' | |||
No you don't have to as you can run SQL queries that consolidates information and provides data with totals for example (sales of a product per region) and this allows you to provide data to analysts without compromising your data silo. | |||
You might also want to provide your partners or customers with access to their invoices for example without sharing confidential information that might exist on an invoice record. | |||
You just select the columns you want to share for a given customer. | |||
That data is then created as an Island of data on its own (outside your silo and) consisting of records for a given customer alone. | |||
''-Okay so how does it work?'' | |||
Once you have an account you can create a region. Regions contain islands of data. Access is controlled at the region level. | |||
So for example you would create a region for a customer and within that region create data islands and provide that customer with access to the region. | |||
The customer can then pull the data down onto their own server or view it via the web app (coming in Feb 2022). | |||
Latest revision as of 15:32, 28 August 2025
Welcome to the Data Islands Help
Check out our website at here
-What is Data Islands?
Data Islands is an online service that allows you to move data from various data sources securely (data integration). You can also create Micro Data Warehouses (or Data Mart) and manage access to that Data.
-What is a Micro Data Warehouses?
A Micro Data Warehouses is a collection of datasets that contain small amounts of data fed from your "Data Silos" EG: databses (MSSQL, MySQL,Postgres), CSV,XERO api and Creatio API (or any REST API).
-Why would I need a Micro Data Warehouses?
Its a great way to protect sensitive data by limiting what data is available in the mart. Micro Data Warehouses contain aggregated and subsets of data making them more easily consumed by end users.
-What is a Data Silo?
A Data Silo is a dataset/database/csv that is not accessible outside of your network or a subset within that network.
Typically a single Data Silo will be an ERP or Accounting system or a CRM system or even CSV files. It could be any proprietary database also.
This data is isolated ("siloed") for various reasons, typically security and also confidential information.
-So would I be sharing confidential information?
No you don't have to as you can run SQL queries that consolidates information and provides data with totals for example (sales of a product per region) and this allows you to provide data to analysts without compromising your data silo.
You might also want to provide your partners or customers with access to their invoices for example without sharing confidential information that might exist on an invoice record.
You just select the columns you want to share for a given customer.
That data is then created as an Island of data on its own (outside your silo and) consisting of records for a given customer alone.
-Okay so how does it work?
Once you have an account you can create a region. Regions contain islands of data. Access is controlled at the region level.
So for example you would create a region for a customer and within that region create data islands and provide that customer with access to the region.
The customer can then pull the data down onto their own server or view it via the web app (coming in Feb 2022).
