General

Hi all, Does anyone have experience with or managed to do a “dynamic” kind of flexi multi key join in TimeXteder? Example like this --- a.[BUYER_GROUP_CD], b.[BUYER_GROUP] FROM [DSA].[SYNAPSE_SILVER] a LEFT JOIN [DSA].[XLS_PURCHASING_GRP] b ON a.[BUYERGRP] = b.[BUYER_GROUP] OR ON a.[BUYER_GROUP_DESC] = b.[BUYER_GROUP_ID] OR ON a.[BUYER = b.[BUYER_GROUP_WORKSPACE_ID]

Hi. Is it possible to move my current community account to my new e-mail address? I could not find anywhere to update this on my profile.

Hi! I have just installed TX 20.10.66.64 on a new server for a customer and following the steps of the “Configure Multiple Environments” article. Created a service account and setup the Windows Services through TimeXtender. Logged in on TimeXtender with the Service account for prod and linked it to the prod repository (which is on a different server). Now I'm trying to setup the production environment in TimeXtender. I opened Environment properties and clicked New Environment, gave it a name and filled in the address of the server (and instance) containing the prod repository. Filled in the ports. When clicking OK to close the Add Environment window I almost immediately get the error from the printscreen below: Has anyone come across this before?

Hi! I am currently investigating something for a customer of ours. They just switched their Telephony system to Teams Telephone and want to use a dashboard in Power BI to show the current queue of callers. The data can be extracted from Teams Telephone by MS Graph API. This customer has a TimeXtender environment in production, so adding a new datasource (TimeXtender REST connection to the MS Graph API) will not be the hardest part. But, they want the dashboard to show (near) real-time data. Is it possible for TimeXtender to take in data, prepare it for the report and refresh the semantic layer within seconds and then start again? I am aware MS have created a plugin for Teams to show these numbers in a dashboard of their own in the application, but our customer would like to know if it is possible to create this in Power BI using TimeXtender. Kind regards, Richard

Hi! A customer I am working for recently did an upgrade to TX Classic 20.10.66.64. After switching all data sources from ODX to Business Units not all datatypes are set correctly in TimeXtender. Especially the columns containing the datatype “time(7)”. When you check the fields in the new datasource the datatype for that field is shown as unknown, while sql recognizes the source as a “time(7)” field. We were able to resolve this with the overrule datatype option, but would like to have it investigated to check if this is desirable. TimeXtender: SSMS: Datasource: Any Source ADO.net Dataprovider: SQLClient Data Provider (.Net Framework data provider)

Hi Just installed TX 20.10.66.64 on a new server for a customer and connected to the server where the txrepository is kept, all without any problems. Now I need to setup the Prod environment and therefore start the service I created for that, but this keeps showing an error message: From the application log of the server:

Hi! A customer I am working for has been wanting to upgrade their TimeXtender version to the new V25 / Classic. According to this article: Important information regarding TimeXtender 20.10 (V20), TimeXtender Data Integration (TDI), and TimeXtender Classic (V25 / Classic) the release would be end of march. But until now there has been no update on this new version. Would it be possible to get an update on the release date so they can decide which version to upgrade to?

is it possible, as the title says .. to Copy and entire semantic layer to a new semantic layer, or copy the exsisting tables with relations from 1 semantic layer to a new one ?

At one point you had a link to describe how to write a custom data source so it will show up in the list of Custom Data Sources in TX. Can you link me to that documentation?

Hi, I have a virtual machine that is currently hosting the ODX service and I would like to get my local machine up and running with TX desktop. I have installed the application but am getting an error that can be found below. I have looked through the documentation regarding this but it seems that the legacy documenation is all I can find with anything relevant. In the screen shots it is asking to review settings in the ODX tab and the Project repository tab which are non existent in the latest TX version I am using. I only see General and Customer editors when looking at Tools>options. ERROR> A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) Details: SQL Server: 'sql-instances-prod.database.windows.net'SQL Error Number: 64

We are suddenly having issues with opening last saved project in TimeXtender. The error says: An error occurred while fetching data from the database.Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints. Location: Table: SelectionRuleFieldsForeignKeyConstraint DataFields_SelectionRuleFields requires the child key values (5b2c48b9-abad-4a3b-a9b2-002fedfc582a) to exist in the parent table.. We have tried to go back to the project that we saved before the lastest one. We are able to open that it not able to save it. The errror says: An error occurred while saving the project to the database. An error occurred while fetching data from the database.Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints. Location: Table: SelectionRuleFieldsForeignKeyConstraint DataFields_SelectionRuleFields requires the child key values (5b2c48b9-abad-4a3b-a9b2-002fedfc582a) to exist

In the TimeXtender Classic training, I only see 4 modules, while Peter Jensen (element61) sees 5 modules. See below screenshots. We are wondering why Peter has a module named ‘Business units’ that I don’t see.

hi there After the latest update executionengine_x64 and Jet datamanager server takes 100% of my cpu .. are there anyone who have experienced the same ?

We're experiencing projects to open very slowly using TX 20.10.38 (we're above version 10000 of the project) Is there an easy way to remove old versions of a project ? We are using multi environment with global databases, and don't want to go through the export, create new repo DB and import hustle.We're also trying to delete the logs, but deleting them from within TX seems to take forever.

Good Day One of our clients who use TimeXtender (20.10.47.64) experiences a Server Memory issue in Production when IT Operations opened the Multiple Environment Transfer Window. IT Operations reported that the window took ages to open but did eventually open. The Network Administrator did then have to hard reboot the server in order to get it to respond. Attached are the messages reported within TimeXtender.

Hi, I am currently working in TimeXtender Data Integration (version 6766.1) and would like to view the relationships between my tables. However, when I access the “Relation Diagram,” I do not see any relationships—neither between tables across different data areas (e.g., DSA and MDW) nor between tables with lookup fields. Is there a specific setting I need to enable to view these relationships? The data lineage for specific fields is functioning perfectly.

Hi, I previously obtained my TimeXtender Solutions Architect certificate. How can I get the badge to show up in the community? Kind regards, Ludwig

Hi, Is there a way to view the data lineage for tables populated using the Custom Table Insert method? When we select the “Data Lineage” option for a column in a Custom Table Insert table, it only shows the data lineage with that table as the source, rather than displaying the tables used within the Custom Table Insert itself. I saw that this post had a similar question like mine, but I couldn't find an update about it: data lineage for custom table insert | Community Thank you in advance!

Hi everyone, we're migrating from onprem to an azure SQL db. (version 6x). What would be the approach to migrate history tables? Can't find much on the forums that fits our usecase.

Hi all, our customer has tables that are SCD2 historized with valid_from and valid_to columns and a “version” column, where 1 is the most recent entry, 2 the next older entry and so on. Is there a possibility to load these tables into TimeXtender, preserve the history (make it useable for TimeXtender) and continue historizing in TimeXtender, so that they can turn off the historization in their source table?

Dear Sir, I am looking for a sql query on my local sql repository to create a list of all my datasources in my projects.I am using v20.10.45. Thanks in advance. Regards, Arthur

I would like to know what the best way of working is if you have multiple environments (DEV, TST, PRD) with the new version. In the old version you had to open a different project repository that you could set a different color, so you were always aware on what you had open. In the new version all the environments are available in the desktop and a mistake is very easily made on what environment you open. Names are also shared between environments so you never know what DSA you have open. Love to hear some comments on how other customers are working.

Hi, Is Acrobat Reader a pre-requisite for ETL Agile scheduler to work? We have a client that has uninstalled Acrobat Reader Pro and now the Excel Macros no longer work. The Acrobat Reader was uninstalled on a client PC/laptop. Thanks & Regards Shahid

Hello, TimeXtender 20.10.40.64. In one of our projects we are adding descriptions to every column in a table and we want to be able to get this data querying the database. However, we can’t find a good place in the repository where the description is stored on a column level and how to effectively exctract this data. Looking at the [TxObjectDescriptions] table in the repository there is a column called Description that is a long string. This string includes the description we added to the field, however it also has alot of other data. On top of this, the string seems to have different structures from case to case and I can’t find a good way to always get the value we need. Does anyone have a good way to get this data or knows if there is data saved in another place in a better format? Thank you,Victor

We are in a process of moving from on-prem to AZURE Why do i get this error? How do i solve it? The user svc_timextender is local admin and its alreay running ODX. Why cant i start it for TiimeXtender Server Service?