Adding data source connections
DQO supports integration with different types of data sources. To monitor data quality in DQO, you must first add a data source connection. A data source connection specifies the parameters needed to connect to a database, such as a database location and authentication information. The data source connection information for each data source type may be different. Some data sources use existing database connection APIs (such as ODBC/JDBC), and others have proprietary APIs.
In DQO, you can add a new data source connection through the GUI, command line or DQO shell. For information on the parameters you need to specify, see the document dedicated to each data source.
DQO supports the following types of data sources.
| Data source | Description |
|---|---|
| BigQuery | BigQuery is a fully managed enterprise data warehouse from Google Cloud that helps manage and analyze data with built-in features like machine learning, geospatial analysis, and business intelligence. |
| Snowflake | Snowflake is a cloud-based data warehouse that separates storage from compute resources and requires little maintenance. |
| PostgreSQL | PostgreSQL is a powerful, open source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads. |
| Redshift | Amazon Redshift is a fully managed, petabyte-scale data warehouse service in the cloud from Amazon Web Services. Redshift can handle analytic workloads on big data sets stored by a column-oriented DBMS principle |
| Microsoft SQL Server | Microsoft SQL Server is a relational database management system developed by Microsoft that supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environments. |
| MySQL | MySQL is an open source, easy-to-use and flexible SQL database management system developed, distributed, and supported by Oracle Corporation. |
| Oracle | Oracle Database is a proprietary multi-model database management system produced and marketed by Oracle Corporation. |