TimeXtender Community

Recent activity
Help others
Categories

Dear Sir,The migration Tool is giving me this dialog.Is there anything I can do ?Regards,Arthur ExecuteBulkInsertQueryStep Failed at Step BusinessUnits.Adding to table [dbo].[ODXConnects]Violation of PRIMARY KEY constraint 'PK_ODXConnects'. Cannot insert duplicate key in object 'dbo.ODXConnects'. The duplicate key value is (47f7cfb0-0337-40bc-b508-79172aec7258, 99999999).The statement has been terminated.Details:SQL Server: 'sql-instances-prod-002.database.windows.net'SQL Procedure: ''SQL Line Number: 1SQL Error Number: 2627Violation of PRIMARY KEY constraint 'PK_ODXConnects'. Cannot insert duplicate key in object 'dbo.ODXConnects'. The duplicate key value is (47f7cfb0-0337-40bc-b508-79172aec7258, 99999999). ...

8 hours ago

avanrijnContributor

Ingest

Cdata Sharepoint connection Data Model feature

Dear Sir,I am connecting through Cdata to Sharepoint Online.I have hierarchies in my Sharepoint data, I can see them when I connect with PowerBI to my Sharepoint site. Can I use the Data Model feature ‘Flatten Documents’ like you can with JSon connectivity ?It looks like CData for Sharepoint Online doesn't have this capability. Can I somehow bring these ‘hidden fields’ into my TimeXtender project ?In the attachment (Knipsel.PNG) you can see the hierarchical option in PowerBI with PowerQuery. I miss these fields when I connect with TX Cdata to the same Sharepoint site.Hope you can shine a light on this.Thank you in advance for looking into this case. Regards,Arthur

9 hours ago

BernarddbTimeXtender Xpert

Ingest

Different output query tool vs transfer in the odx TX SQL connector (Classic)

We are experiencing a small issue with one of the connectors while using managed queries. When I use the query tool, we are utilizing the SQL endpoint from a Fabric Lakehouse to retrieve the data into the ODX. When I query the DBO table, I receive 12 records. For example, when running this query:SELECT [SinkCreatedOn], [SinkModifiedOn], [omoperatingunitnumber], [modifieddatetime], [modifiedby], [createddatetime], [createdby], [dataareaid], [recid], [tableid], [createdon], [modifiedon], [IsDelete] FROM dbo.[omoperatingunit] I also get 12 records. However, when we transfer this managed query, we only receive 11 records. This issue has occurred with multiple tables. We are not applying any filters to this dataset.Do you have any idea why this might be happening? Manually excluding or including all the columns is not manageable on the scale we are working with, so we rely on writing managed queries.

13 hours ago

Pontus OlaussonParticipant

Ingest

Error 'Buffer cannot be null' in ODBC Connection

Hi,I’m am trying to create a ODBC data source connection in the TimeXtender ODX portal.I have created a ODBC data source on the server on which TimeXtender is run, see picture below. This data source seems to work fine, I am able to test the connection with success and I am able to connect to the database and query the data through PSQL control center on the server.ODBC Data Source on TimeXtender VM In the TimeXtender portal, my configuration is as follows:TimeXtender portal configurationWhen trying to test the connection, I get the error “Buffer cannot be null. Parameter name: buffer”.I have tried adding buffer as an additional property without success.I am unable to find documentation or guidance on how to solve this issue. Since I am able to connect to the database and query the data through PSQL control center on the server on which TimeXtender is run, the ODBC data source on the server seems to be working correctly. It is only through the TimeXtender portal I am unable to use the

13 hours ago

Leo RogemanStarter

REST APIs

Paging and Dynamic value REST (Rest ODX)

Hello,We have a REST API where we use both Dynamic Value and Pagination (replace URL). The issue is that the paging works fine but only considers the first Dynamic Value and skips the rest. The final result then returns all pages for the first dynamic value and no rows for the rest. Further we also use Table Flattening as well as the Exhaustive Metadata Scan Option. How can we make it loop through all dynamic values as well as keeping the paging option? API request:https://{base_url}/{company_url} Paging:Replace URL with {nextLink} type XPath Dynamic Value query:SELECT company_url FROM [MDW_Dev].[SysTransform].[Company_information]

14 hours ago

rbrandsmaStarter

General

Connecting TimeXtender to Topdesk doesn't show all tables

A customer I am working with is trying to connect Topdesk to TimeXtender through an OData feed. A connection is made, but not all tables are available for ingestion.When the customer changes the connection url to connect to just 1 table, TimeXtender has no issues connecting to it and retrieving the data from that 1 table. To test if this there maybe was a setting in Topdesk that was missed we tried to connect from Power Query using the original url. This connection also worked perfectly, showing around 290 tables.How can we get TimeXtender to retreive the same amount of tables from Topdesk?Feed URL: https://<customer>.topdesk.net/services/reporting/v2/odataOAuth version: 2.0Provider: Managed ADO.NETProvider version: 24.0.8963.0OData version: AUTOAttached a screenshot of the output of a query to the datasource in TimeXtender ODX

14 hours ago

BennyContributor

REST APIs

REST connector can't handle empty return bodies

I have two particular use cases where I would like the TX REST connector to be able to handle nothing being returned. In one case I've configured the portal to do a PUT request. PUT's generally don't return any body. In a second case, the API is just configured to do this sometimes. We get ID's from another endpoint that we are then supposed to use dynamically like: endpoint/{ID}. The problem is that the source system can have phantom ID's, meaning that ID=13 doesn't really point anywhere. endpoint/13 then returns just a completely empty body. In both cases the problem seems to be that the connector can't handle this. We get back:Failed to execute endpoint 'xxx':Unexpected character encountered while parsing value: }. Path 'TX_Autogenerated_Element', line 1, position 28.Going of the error message, it would seem that the connector is assuming a json was returned and automatically starts trying to convert is somehow. I need to be able to handle these situations somehow, since I have no

15 hours ago

jasperpStarter

REST APIs

Passing a dynamic value as an additional column next to the output of the call it is used in?

I am using a Power BI endpoint (https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-refresh-history) where I need datasetIds to get the refreshes of that dataset. I am using the TimeXtender REST data provider, in which I loop over a list of dataset ids using a dynamic value. The problem is that in the output of the Get Refresh History endpoint the dataset Id is not included.Therefore, my question is: Is it possible to pass a dynamic value used in a call as an additional column next to the output of the call? I don't see any option for this in the portal. If I were to extract the data using Power BI, I would do the call for every row in a table containing the required dataset Ids and expand the resulting column. This way, the original table column containing the dataset Ids will always be related to the dataset refreshes. Can I do the same using TimeXtender?

15 hours ago

Dagný Björk StefánsdóttirCommunity Manager

General

Step-by-Step Guide to Download Executables for MDM and O&DQ

If you ever find yourself wishing you had access to all (older) versions of TimeXtender O&DQ and MDM apps here is your solution! Let's find out how to quickly download the executable versions of our solutions.Links below will guide you to public-facing SharePoint folders that will enable you to download and run multiple versions of O&DQ and MDM clients. These are not installable files, just follow instructions below to run each version.TimeXtender O&DQ: TimeXtender O&DQTimeXtender MDM: TimeXtender MDM TimeXtender O&DQOpen the link and select the version you are interested in.Next step will be to press "Download" and wait patiently as the zipped folder is downloaded. Extract the files from the folder and select "ExpectusAdmin.exe" to start the application TimeXtender MDMOpen the link and select the version you are interested in.Next step will be to press "Download" and wait patiently as the zipped folder is downloadedExtract the files from the folder and select "exMo

1 day ago

sigsolContributor

Ingest

How to use Rolllup task

Hello Community!When running a rollup task, the resulting rollup file ends up in a separate folder inside the same full load folder: After the rollup, new incremental files continue to appear in the DATA folder and the old incremental files are still there. What have we achieved by doing the rollup? Is the new rollup file being used at all? How can we delete the old incremental files given that the delete Storage Management task only removes entire full load folders and we don’t perform full loads?Currently I don’t understand how we can clean up the many incremental files, both for load performance and storage management.Please note: We cannot rely on doing regular full loads because of the size of the tables.Thanks!TX version: 6745.1Connector: TimeXtender SQL Data Source 21.0.2.1We are using Azure Data Lake and ADF.

1 day ago

avanrijnContributor

Legacy & Upgrades

Mirgration Tool Dialog Box Question

8 hours ago

BernarddbTimeXtender Xpert

Ingest

Different output query tool vs transfer in the odx TX SQL connector (Classic)

13 hours ago

Leo RogemanStarter

REST APIs

Paging and Dynamic value REST (Rest ODX)

14 hours ago

BennyContributor

REST APIs

REST connector can't handle empty return bodies

15 hours ago

jasperpStarter

REST APIs

Passing a dynamic value as an additional column next to the output of the call it is used in?

15 hours ago

mmax77Starter

Security & Compliance

Role Level Security Enforcement

Hi all, We implemented a semantic model on Azure, granting access to our users through Azure AD groups. By creating roles that include Azure Tenant IDs and enforcing Row-Level Security (RLS) dynamic settings.However, we’ve encountered a challenge: when changes are made to certain fields, the RLS configurations can sometimes fail to enforce restrictions properly. This can lead to unintended access, where users in an AD group suddenly find themselves with visibility into all data, rather than the limited data they should see.To address this, we’re exploring ways to implement a more restrictive access model within the RLS role configuration. Specifically, we’re considering options that would prevent any data visibility until RLS settings are confirmed to be operational.Proposed Solution:Initial Data Restriction: Until the RLS settings are validated, no users should have access to any data. Validation Checks: Implementing a validation mechanism to ensure RLS settings are working correctly

1 day ago

Roy VContributor

Prepare

Object reference not set to an instance of an object.

I am deploying a project to Snowflake.On a table I get the following error:Object reference not set to an instance of an object.As read in another ticket I did a ‘Save and reload' but unfortunately that did not solve the issue.It;s on deploying the data cleansing script however it does not show me the script in the deployment log, I only see the error message. Is there an easy way i can see what lookup column is causing the issue ?

4 days ago

hans.westerhofStarter

Jobs & Executions

TimeXtender API not showing all errors

Hi all,I have a customer that has to deal with an unreliable source system. During transfering specific query tables, it sometimes fails. As there is no retry option on this level, at least we can do right now is to inform the customer that things went wrong. Unfortunately the TimeXtender API does not tell us there is anything wrong with this run. The “State” is 2, and all the child “JobExecutionLogs” child entries below the job itself all have the “Severity” value of 0. Does someone recognize this situation? Anything we can do differently to inform the customer?

5 days ago

avanrijnContributor

General

Cdata Json

Dear Sir,I am trying to set up a CData Json datasource connection with TimeXtender.This is my connectionstring:Auth Scheme=OAuth;Data Model=Document;Initiate OAuth=REFRESH;OAuth Access Token URL=https://pilot.binnenbeter.nl/api/v2/login/venray;OAuth Grant Type=PASSWORD;OAuth Refresh Token URL=https://pilot.binnenbeter.nl/api/v2/login/venray;Row Scan Depth=100;User=api@venray.nlI am able to get the bearer Token with Postman with this:url: https://pilot.binnenbeter.nl/api/v2/login/venrayJSON Body:{ "id": "", "language": "en", "data": { "resourceType": "AUTH", "item": { "loginName": api@venray.nl, "password": "password", "module": "API" } }This is the documentation I used for the connectionstring:PasswordFinally there also is an Password method. It is similar to the others, in that it requires an Access Token URL and an Refresh Token URL, the difference is that it uses an User and Password instead of client and secret. Notice that these fields are

6 days ago

BennyContributor

Ingest

Failed to read metadata from XmlDocument for endpoint X with transformation 'T' Input string was not in a correct format.

The sync of my ODX datasource returns the following error. The datasource is a REST API endpoint of the form URL/{foreign_ID}, where foreign_id is a dynamic value that comes from a different endpoint within the same data source. The option "Perform exhaustive meta data scan” is enabled. The error returned is this:Failed to read metadata from XmlDocument for endpoint X with transformation 'T'Input string was not in a correct format.There is no further information. The sync does work when I replace foreign_ID by a fixed value. The endpoint contains a field that has a lot of values that look like integers, but some values contain letters. Since the above error message is the most verbose info I’ve got, I assumed that's probably the cause. However this conflicts with my understanding of what an “exhaustive meta data scan” should do. Any help is appreciated.

8 days ago

TimeXtender Desktop Q&A

Ask questions and find answers about the TimeXtender Desktop Application

Ingest

225 topics
1223 Replies

Prepare

220 topics
979 Replies

Deliver

64 topics
259 Replies

Jobs & Executions

115 topics
496 Replies

TimeXtender Portal Q&A

Ask questions about the TimeXtender Portal

General

34 topics
153 Replies

Data Sources Q&A

Ask questions of about setting up data sources

General

51 topics
258 Replies

REST APIs

33 topics
218 Replies

RSD File Customization

22 topics
149 Replies

SAP

8 topics
28 Replies

Oracle

8 topics
43 Replies

ODBC

7 topics
46 Replies

General Q&A

Ask general questions

General

31 topics
112 Replies

Interoperability with other Platforms & Tools

9 topics
38 Replies

Legacy & Upgrades

61 topics
228 Replies

Security & Compliance

5 topics
15 Replies

Infrastructure & Networking

8 topics
29 Replies

XPilot

0 topics
0 Replies

Learn & Share

Share tips and best practices, show what you've created and inspire others

Success Stories

4 topics
4 Replies

Tips, Tricks and Best Practices

18 topics
44 Replies

TimeXtender Tuesdays

29 topics
40 Replies

Community Announcements

Everything you need to know about this community

Getting started in the community

8 topics
5 Replies

Company Announcements

15 topics
25 Replies

Exmon

General

6 topics
17 Replies

Community Statistics

1,394: Topics
4,662: Replies
981: Members

Awarded Badges widget

Roy Vhas earned the badge Prepare Expert
rvgfoxhas earned the badge Deliver Expert
rvgfoxhas earned the badge Prepare Expert
rvgfoxhas earned the badge Ingest Expert
KajEmergohas earned the badge Ingest Expert

Show all badges

Leaderboard

Show full leaderboard

Ask Questions. Find Answers. Fast.

Download the latest version of TimeXtender Data Integration

Featured topics

The latest & greatest from the community

Community Statistics

Awarded Badges widget

Leaderboard

Need more help?

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded