Skip to main content
To homepage To homepage

TimeXtender Orchestration and Data Quality Q&A

TimeXtender Orchestration and Data Quality

18 Topics
G
Starter
gdlc_esculineStarter
asked in Orchestration
Orchestration: questions about custom SQL in schedule groups

Hi, I have two questions regarding Orchestration, schedule groups.(1) There is the option to make a schedule based on a SQL custom script. When I try to test this functionality out with the following statement:SELECT CAST('2025-06-10 01:00:00' AS DATETIME)It gives me the following pop-up:  Does someone know why I don't get query result = '10-06-2025 01:00:00’? The SQL statement produces a valid datetime value in SMSS.(2) I need to schedule a job that runs four times per day for a project. I wanted to build this schedule with the custom SQL option and by using a calendar table in our database from the Prepare Instance. Is this possible? Thanks in advance!

321
G
Community Manager
darrirafn
Starter
darrirafnStarter
asked in Orchestration
Power BI Refresh Package in TimeXtender Orchestration

Hello.We are working on adding PBI datasets to the Orchestration process. I have followed these instructions and up until no. 3 in the Power BI part, everything has been a success. However, I’m supposed to choose Orchestration > Packages, select New > Power Bi Refresh. But Power BI Refresh is not an option:  Is there a particular reason for this? I have added Power BI Refresh to the workspace (as a member currently, does it have to be an admin? That is not specified in the instructions at least.)I’m on TimeXtender Data Governance version 24.3.0.87Best regards.   

312
rvgfox
Problem Solver
K
Contributor
KajEmergoContributor
asked in General
Orchestration 'Retry on Failure' setting

In TimeXtender Orchestration, you have the option to set ‘Retry on Failure’ equal to True on a package (e.g. a TimeXtender Ingest package). What does this setting do? It will probably retry the package in a process if it fails? But can you set how many retries should be carried out if it keeps on failing? Also, the ‘Retry in (seconds)’ setting is probably the amount of time Orchestration waits before it starts the retry? I have searched the Community but I cannot find any proper documentation about this, or am I missing out on some article?  

202
K
Contributor
Roy V
Problem Solver
Roy VProblem Solver
asked in General
How to stop an execution in TimeXtender DG Desktop

How can I stop a process from running in the TimeXtender DG Desktop application?I see an article about a process queue but nor in the portal nor in the desktop application I can see this menu. Maybe that is a functionality in the old version?

14514
Christian Hauggaard
Community Manager
T
Participant
thzmanParticipant
asked in General
Exmon login error

Hi,Are there some specific ports or something that needs to be open for Exmon to work? When I’m at home Exmon DG Desktop works just fine, but when I’m at work I get an error as you can see in the attached picture. What SQL server is the application trying to reach? We don’t have any local databases configured for Exmon since we only use it for job scheduling in our SAAS environment.BRTomas Hertzman 

843
X
Contributor
G
Community Manager
gunnarsteinnCommunity Manager
published in General
Directly link to a record from data quality controls

The goal of Data Quality controls is to find and quickly fix data quality errors in source systems and processes. When the source system allows you to directly link into a specific record, you can direct data owners to that record for fast resolution.In this tutorial we will use Business Central as an example to link to. Understanding the URLFirst you need to understand the source system URL to be able to regenerate it.For example, Business Central URLs are of the type:https://businesscentral.dynamics.com/TENANTID/ENVIRONTMENT/?company=COMPANYAS&page=PAGENUMBER&dc=0&bookmark=BOOKMARK The page refers to the type and for example the G/L Account Card is number 15.Each record is identified via Bookmark which we can’t recreate but instead we can filter down to a single record with the “filter” parameter.So if we remove the bookmark parameter and instead add: &filter='No.' IS '10102'then we are linking directly to account number 10102.So the final URL becomes https://business

150
G
Community Manager
Paul McLeod Bespoke Analytics
TimeXtender Xpert
Paul McLeod Bespoke AnalyticsTimeXtender Xpert
asked in General
Exmon New Ingest Package selection issue 24.3.0.49

We have recently installed the new Exmon desktop V24.3.0.49 and have started migrating our TimeXtender SAAS packages to the new Ingest, Prepare and Deliver packages.Everything works fine in creating the packages.There is some strange behavior on the Ingest packages however!If you then open a fresh Exmon desktop instance and open an Ingest package definition it will show an abbreviated name of the task selected and the drop down will not be populated with the list of Ingest tasks, just the task selected.If you then refresh the list it will change the selected package to the corresponding package on a different ingest instance! Without any user interaction apart from pressing the refresh button.In our example it is changing dev ingest instances to production! This doe not happen for Prepare or deliver packages. Something to note and put on the hotfix list for Exmon.

471
Christian Hauggaard
Community Manager
Roy V
Problem Solver
Roy VProblem Solver
asked in General
Unit of measurement in timeout settings Exmon O&DG

Good moringI am in the TimeXtender DG Desktop version 24.3When I click on Tools → Configuration → Advanced I see a lot of timeout settings.I can not see what the unit of measurement is, are they all in minutes? Could not find this in the help.Greetings, Roy 

311
Christian Hauggaard
Community Manager
E
Explorer
EelcoHExplorer
asked in General
TimeXtender Orchestration wait for scheduled group

Is there a way in TimeXtender Orchestration (Exmon DG) to make a scheduled group (with a fixed start time, which cannot be earlier) wait for another delayed running scheduled group to finish?If the second scheduled group starts while the first one is still running, it will fail because it is not allowed to run at the same time.This can of course be solved by using the concurrent packages option in TDI, but that is not always desirable/useful.

512
E
Explorer
G
Community Manager
gunnarsteinnCommunity Manager
published in General
Waiting for executions before starting a processTutorial

How to Create a Data Provider Command Package to Wait for Another Job to FinishCreating a Data Provider Command Package to Wait for Another Job to FinishWhen working with data processes in TimeXtender Data Orchestrator, there are instances when you may need to wait for an unrelated job to complete before initiating another process. In such cases, you can create a Data Provider Command package that ensures the second process starts only after the first job finishes.Step-by-Step GuideCreate a Package > Data Provider Command Select the Data Governance Data Provider and Custom SQLCustom SQL CommandUse the following SQL command to create the wait mechanism:DECLARE @task_id int = 123 -- the task id of the schedule groupDECLARE @task_type varchar(20) = 'EBI_PACKAGE' -- the type of the object you are running within the schedule group, as we cannot wait for schedule groupsDECLARE @end_date DATETIMEWHILE 1=1BEGIN SELECT @end_date = end_date FROM reporting.execution WHERE task_id = @t

422
G
Community Manager
avanrijn
Contributor
avanrijnContributor
asked in General
Release 24.3 of TimeXtender Orchestration Exmon DG Client Desktop

Dear Sir,“ It’s our pleasure to announce the release 24.3 of TimeXtender Orchestration & Data Quality and TimeXtender Data Enrichment, featuring exciting new updates and enhancements. “So we are just migrating to TX 6766.1 and now our customer is asking for more options to Orchestrate their TimeXtender environment.Question:Where can we download the latest and the greatest of TimeXtender Orchestration 24.3 ?We would like to setup Exmon DG Client Desktop in our customers new TimeXtender environment.Thanks in advance for looking into this.Regards,Arthur

1151
Christian Hauggaard
Community Manager
Paul McLeod Bespoke Analytics
TimeXtender Xpert
Paul McLeod Bespoke AnalyticsTimeXtender Xpert
asked in General
TimeXtender Orchastration new TimeXtender Ingestion Package Source

I see that there is a new set of package types that can be added in the TimeXtender (Exmon) DG Desktop (v24.3.0.35)I have tried to use them but get an error that there was no prepare package found for my selected Data Provider.Can anyone provide any guide how to use this new feature, and if it is fully available yet?   

442
Paul McLeod Bespoke Analytics
TimeXtender Xpert
Paul McLeod Bespoke Analytics
TimeXtender Xpert
Paul McLeod Bespoke AnalyticsTimeXtender Xpert
asked in General
Exmon package synchronization issues

I have a scenario where Exmon periodically seems to loose synchronization, or perhaps has some status issue relating to a package, Where the TX package will just error out immediately on the process map with an error that the job is already running. I am using Exmon against the SAAS version of TimeXtender (holistic). The underlying package is definitely not erroring out or is running. But Exmon seems to think that the package/Job is running.So far the only way I have been able to correct this is by deleting the package and re-adding it. But this keeps reappearing randomly or different packages with the Exmon processes. Is there a way to clear the status of an Exmon package or is this a bug that needs addressing?Using TX 6645.1 and Exmon 24.2.0.28Help! finding it hard to explain this one away with the client!

764
Paul McLeod Bespoke Analytics
TimeXtender Xpert
sven.debie
Contributor
sven.debie
asked in General
Exmon run stats into PowerBI

Hi,How can I get execution stats of Exmon into PowerBI to make my own report out of it?

1337
rvgfox
Problem Solver
Paul McLeod Bespoke Analytics
TimeXtender Xpert
Paul McLeod Bespoke AnalyticsTimeXtender Xpert
asked in General
Switch Exmon Login Account on Desktop

Hi want to switch between a client’s Exmon environment and our partner Exmon environment.I have been using the Exmon desktop on my personal laptop connecting to the Clients Exmon environment. But I cannot seem to logout of the credentials used for the client so that I can log onto our Partner Exmon environment with different credentials.Is there a way to sign off from the Exmon Desktop so that it prompts you for the user credentials to use to sign in?

353
Paul McLeod Bespoke Analytics
TimeXtender Xpert
devin.tiemens
TimeXtender Xpert
devin.tiemensTimeXtender Xpert
asked in General
Stop/ kill a running execution within Exmon DG

Hi, Does anyone knows if it is possible to stop/ kill a running execution within Exmon DG? 

1132
devin.tiemens
TimeXtender Xpert
devin.tiemens
TimeXtender Xpert
devin.tiemensTimeXtender Xpert
asked in General
Exmon Lookup Column Empty

 Hi,I am not sure if I am doing something wrong or if it is a bug. But after I created a lookup column to another table; the values are all white when I want to select one of these values in Exmon DM Desktop.   Already restarted the program but still the same issue. Anyone got any idea or is this a bug which should be fixed?Regards,Devin

592
devin.tiemens
TimeXtender Xpert
oscarcleve
Contributor
oscarcleveContributor
asked in General
Exmon Gateway for Exmon Data Governance Report

I want to display data from my local SQL Server in the Report section of Exmon DG’s web interface. I have installed Exmon Gateway on my local machine which I want to connect to and created a Data Provider for the database I want to access. I can access this Data Provider through the Exmon DG Desktop and data is displayed in the report as intended (marked green).  Exmon DG Desktop Exmon GatewayIn the Exmon DG’s web interface, however, I get the following error message: Error message Exmon DG WebI have tried using ./computer name/localhost/ip address as Host Name in the Data Provider but I still get the same error. Any ideas on what might be the issue?    

1302
oscarcleve
Contributor

Badge winners

  • Certified Solutions Architect
    hay71has earned the badge Certified Solutions Architect
  • Certified Solutions Architect
    Himanshu Chhas earned the badge Certified Solutions Architect
  • Innovator
    oscarclevehas earned the badge Innovator
  • Certified Solutions Architect
    leo.noharethas earned the badge Certified Solutions Architect
  • Innovator
    Bernarddbhas earned the badge Innovator
Show all badges
Terms and ConditionsCookie settings