Data Stores are containers for tabular information coming from internal or external data sources, and are the starting point for all data exploration performed within Data360 DQ+.
Note: To create a data store, you must have Create Data Store and Write permissions to a pipeline.
There are two types of data store:
- Internal data store - An internal data store can hold data pushed from another (external) application, such as Assure DQ or ER DQ, or it can hold data from other data stores that are already set up within Data360 DQ+. These types of data stores are typically outputs from other data stages, such as an analysis that transforms a set of data stores to create a new one. Additionally, internal data stores can be used to hold the detail records for case stores within a database. See Creating an internal data store.
- External data store - An external data store points to data coming into Data360 DQ+ from an external source, allowing for the exploration of virtually any set of data. You can create an external data store by uploading a file directly or by uploading data to an external location and then pointing to that location. This can take the form of uploading a file to an external repository and then pointing to that repository, or pointing to an existing database that contains your data. See Creating an external data store.
A data store is highly configurable. For example you can modify existing fields or add new fields, and profile the data and view metrics based on the data profile. For more information, see the topics in the Configuring data stores section.