It's not enough to have the same column names in two different spreadsheets... What about all of your other data sources -- MS Word documents, Adobe PDF, unstructured customer emails, comments, etc? NNCompass provides an easy way to integrate and merge data from all the data you would want to take advantage of.
Watch the Data Integration Video
In-Memory Data Dictionary
Data Integration starts with getting a handle on not just what your data looks like (often referred to as schema), but how all of the data sources could interrelate. Our In-Memory Data Dictionary is easily accessible and represents a simple list across all of your data.
Analytics packages run across your data when it is first being ingested into NNCompass -- this means we do a lot of incredible things with the data when you first upload it. We look at where all of your data could interrelated, and give you recommendations on fields that are very similar.
Data Integration Tab
When you create a group from multiple data source uploads or database connections, NNCompass shows an easy-to-use Data Integration tab. From here you can select which fields you want to integrate, then merge all those sources together through an export or stream.
Start by Uploading Your Data Sources
Integrating data starts with you uploading your data sources. Remember, you can upload just about anything into NNCompass, and with NNCompass Business Platinum you can connect to SQL databases and whole lot more.
Then Transform, Wrangle, Cleanse & Normalize Your Data
Once you've uploaded or connected to a data source, NNCompass gives you the ability to transform the data, live and in-memory. We don't copy data from one location to another. You can perform dozens of transform operations on that data, view the profiling analytics, understand the in-memory schema (Data Dictionary) and see which fields might be similar across your data, and export or stream directly from the Data Source page.
Create a Group
Groups are collections of data sources based on a concept you define. Think of groups as a folder with a bunch of data sources that could be related. Create a group, then open that group page up to see how all of the sources in a group could related.
Data Integration Tab
This is where the magic happens. The Data Integration tab shows you all of the data fields across all the data sources in your group. And integrating data fields couldn't be simpler. Select which fields you want to integrate, give it a integrated field name, press "Integrate Selected Fields" and your data fields are now integrated. This effectively creates whats called a "primary key", which tells NNCompass and other databases that this field is exactly the same across all your data sources.