Data Quality¶

Define tests over your data, group them, and manage the exceptions they raise.

How-to¶

• Create a Test Group from a template

Articles by topic¶

How-to guides · Install, upgrade & migrate¶

• Install Timextender Orchestration and Data Quality On-Premise
• Installing multiple Gateways on the same server
• Moving from Timextender Orchestration and Data Quality on-premise to cloud

How-to guides · Monitoring recipes¶

• How to find files that have not been updated for some time?
• Monitor website SSL certificate expiration
• Monitoring disk space with Timextender Orchestration and Data Quality
• Monitoring lower toner in printers using Timextender Data Quality
• Monitoring unapproved invoices in Navision or Axapta with Timextender Data Quality

How-to guides · Notifications & webhooks¶

• Configuring Custom Webhook Settings in Turnkey
• Configuring email notifications in Timextender Data Quality
• Setting Up Custom Webhooks for Notifications with Zapier
• Trigger Condition and Email Notifications

How-to guides · Other¶

• Clearing Old Exceptions
• Clearing Old Executions
• Customizing the Portal's theme
• Generate Data Quality Rules with Xpilot

How-to guides · Queries & data access¶

• Add an Oracle Data Provider in Timextender Data Governance
• Calling a JSON service from Timextender Orchestration and Data Quality
• Changes to package parameters
• Configure a data quality control to an Excel document
• Create a link to an underlying data source
• Create dynamic packages that accept parameters
• Enabling and editing retry SQL connection in Timextender Orchestration
• Extract-Refresh Data Sources for Tableau Online, in Timextender Orchestration and Data Quality
• How to query OData services from Business Central
• Import from Excel
• Running Linux commands in Timextender Orchestration
• Send parameters to Query and Compare Query

Reference · Best practices & security¶

• Improve IT security with Timextender Orchestration and Data Quality
• Timextender Data Quality Best Practices (1/3)
• Timextender Data Quality Best Practices (2/3)
• Timextender Data Quality Best Practices (3/3)

Reference · Data providers & parameters¶

• Data Provider Groups in Timextender Orchestration and Data Quality
• Data Provider Parameters
• Global Parameters
• How do I send parameters to Query and Compare Query?

Reference · Exceptions¶

• Exception Manager Process Type
• Tagging Exceptions in Timextender Orchestration & Data Quality

Reference · Integrations & gateways¶

• Fetching data from Salesforce with Timextender Orchestration and Data Quality
• PowerShell in cloud
• Timextender Ingest SaaS Integration
• Timextender Internal Gateway
• Timextender On-Premise Integration
• Timextender Orchestration and Data Quality Integration Actions

Reference · Notifications & email¶

• Custom Webhook Notifications
• Dynamic Exception Owners with User Mapping
• Dynamic email recipients with CC User Mapping
• Email template designer
• Exception Emails
• Hiding exception data in email notifications
• Timextender Data Quality – Teams Notification Integration Guide

Reference · Other¶

• Data Quality controls on Power BI Datasets
• Data quality control on Snowflake data
• How can I remove the Expectus Command Service Trace Log file?
• How do I use dimensions in Timextender Data Quality?
• Powershell Data Factory in Timextender Orchestration
• Powershell Power BI Refresh in Timextender Orchestration
• Vendor Bank Account Validation

Reference · Package types¶

• Azure PowerShell packages in Timextender Orchestration
• Azure Synapse packages in Timextender Orchestration
• Data Factory packages in Timextender Orchestration
• Data Provider Command packages in Timextender Orchestration
• Microsoft Fabric packages in Timextender Orchestration
• Power BI Refresh Package in Timextender Orchestration
• Transferring data with Data Transfer packages

Reference · Process maps & groups¶

• Process and Object Group Overview
• Timextender Orchestration Process Maps

Reference · Queries & monitoring¶

• Check if a Windows Service is running and restart if not
• Find out if a file is open in another program
• Notify when text files contain a pattern using PowerShell and RegEx
• Notify when there is a new file in a folder
• Query Value Comparisons
• Query Windows Service Status and Restart with Timextender Data Quality
• Query XML data with Powershell in Timextender Orchestration and Data Quality

Reference · Users & groups¶

• Ensure all Timextender Orchestration & Data Quality users are enabled in Active Directory
• External Systems and Users
• User Groups in Timextender Orchestration and Data Quality

Tutorials & walkthroughs¶

• Compare Query Walkthrough
• Configuring Exception Management in Timextender Data Quality (Tutorial)
• Create a Compare Query (Tutorial)
• Create your first query in Timextender Data Quality
• Create your first query in Timextender Data Quality: monitor discounts of 30% or more
• Data Provider Walkthrough
• Deploying Objects (Tutorial)
• Dimension Walkthrough
• Getting Started with Timextender Orchestration
• Getting started in Timextender Orchestration & Data Quality
• Query Walkthrough
• Scheduling Objects (Tutorial)
• Using the Timextender Orchestration and Data Quality Portal (Tutorial)

Concepts & overviews¶

• Choosing the correct primary key
• What is Timextender Data Quality and Orchestration?

Troubleshooting¶

• Could not find column definitions for the test
• Data Quality Portal Not Showing Any Exceptions After Upgrade
• Gateway troubleshooting
• Process and Object Group Failure Types
• Troubleshooting Errors When Running a PowerShell Package via Gateway