Data Providers¶

The data provider component gives you a robust, easy way to connect to multiple data sources for quality control checks.

In this module: key concepts of the data provider · what the supported data providers are · connect and explore data · connect to a Business Central database · connect to an AdventureWorks SQL database

What is the data provider?¶

Data providers in Timextender Quality Control are the foundational connectors between your data sources and the quality monitoring framework. They ensure access to diverse data repositories, enabling real-time validation and quality assessment across systems.

To query data effectively, you need to set up data providers. That means connecting to whichever data provider you choose — the steps below establish these connections so you can access and query your data sources.

Connect to Business Central¶

1. Right-click Data Provider → New → Data Provider.
2. Select the data provider from the Data source drop-down. By default it is Transact-SQL.
3. Enter a title and description.
4. Enter the credentials:
   • Host: txtraining.database.windows.net
   • Initial Catalog: BusinessCentral Demo
   • User Name: txlogin
   • Password: from the source module
5. Generate the connection string, save, and test the connection.

Connect to AdventureWorks¶

1. Right-click Data Provider → New → Data Provider.
2. Select the data provider from the Data source drop-down. By default it is Transact-SQL.
3. Enter a title and description.
4. Enter the credentials:
   • Host: mp77op1ebc.database.windows.net,1433
   • Initial Catalog: AdventureWorks
   • User Name: tx_training_readonly
   • Password: from the source module
5. Generate the connection string, save, and test the connection.

Related reference¶

• What is Data Quality — the concepts behind these connections.
• Query Control — the next module: build a check on the data you just connected.