TimeXtender Community

Recent activity
Help others
Categories

sven.debie

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?

10 hours ago

dennishanssenStarter

Ingest

Error when filtering columns BC Online

Using the TimeXtender Dynamics 365 Business Central - Online connector, I'm having trouble filtering columns in the ODX. With all columns selected everything is fine, but once I make a selection in columns I get the error below when running the Transfer Task. Any ideas on why this is happening and how to fix it? (TX Version 6XXX) Executing table customer:failed with error:Exception Type: System.InvalidOperationExceptionMessage: Sequence contains no matching element Stack Trace: at System.Linq.Enumerable.First[TSource](IEnumerable`1 source, Func`2 predicate) at TimeXtender.ODX.Account.BC365CustomDataSource.ExecutionHelper.GetIncrementalLoadPartitionSetups(AccountBC365CustomDataSource accountBC365CustomDataSource, TableModel tableModel) at TimeXtender.ODX.Account.BC365CustomDataSource.AccountBC365CustomDataSource.GetIncrementalLoadSetups(TableModel tableModel) at DataSourceEngine.Custom.CustomSourceEng

12 hours ago

rory.smithTimeXtender Xpert

Deliver

What security options are supported for Deliver REST endpoints

Hi,which kinds of security are available for REST Endpoints and how should they be implemented? Can you directly use row-level security in the Deliver instance?

14 hours ago

mirjam.bleuminkStarter

RSD File Customization

Is it possible to use POST for a REST API?

I am using a REST API (CData source) to get source data. Since I need to include a CSR_NONCE value in the header (unique key value), the REST api is set up as a POST. Is it possible to specify that you want to do a POST rather than GET in a CData source?

14 hours 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?

15 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.

16 hours ago

Roy VProblem Solver

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 ?

1 day ago

FenchContributor

General

Update repository version

Dear all,Upon trying to migrate the mdw instance from DEVelopment to PRODuction environment, the following error message appears:Error: Target repository version 5.0.0.0 does not match source repository version 5.0.2.0DEV and PROD environments are both in the same TX desktop app, version 6766.1In the portal, under Data estate > Instances > mdw development instance and mdw production instance, i can’t find any version info.Any suggestions welcome.

1 day ago

Dagný Björk StefánsdóttirCommunity Manager

TimeXtender Orchestration

Configuring Azure Cloud Optimizer Package

In this article you will learn about the new Azure Cloud Optimizer package type, how to create one in TimeXtender Data Orchestration and run it.When using cloud resources, such as Azure virtual machines and Azure SQL databases, leaving them idle at high resource usage levels, or running at all, when they are not truly needed can quickly become very expensive. The Azure Cloud Optimizer package type for TimeXtender Data Orchestration allows you to create packages that can switch Azure Virtual Machines on or off, and reboot them should that be required, or scale Azure SQL databases up or down, between purchasing models, tiers and the different available capacities. These packages can be run before and after other processes, making sure those processes that need powerful virtual machines running that nothing else uses, or that require databases to process much more data than they otherwise do very quickly, have what they need, but then going back to the less expensive configuration afterwa

301

1 day ago

avanrijnContributor

Legacy & Upgrades

Mirgration Tool Dialog Box Question

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). ...

1 day ago

dennishanssenStarter

Ingest

Error when filtering columns BC Online

12 hours ago

rory.smithTimeXtender Xpert

Deliver

What security options are supported for Deliver REST endpoints

Hi,which kinds of security are available for REST Endpoints and how should they be implemented? Can you directly use row-level security in the Deliver instance?

14 hours ago

hans.westerhofStarter

Jobs & Executions

TimeXtender API not showing all errors

15 hours ago

BernarddbTimeXtender Xpert

Ingest

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

16 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]

2 days 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

2 days 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

3 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

8 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.

10 days ago

rory.smithTimeXtender Xpert

REST APIs

Get value of parent node instead of expanding to children

I am trying to achieve something complex in the TX REST connector using table flattening.I have the following JSON response: [ { "id": 1, "submitted": "2024-06-26T12:11:42+02:00", "answers": [ { "question": { "id": 3, "label": "How do you evaluate this?", "type": "SINGLE" }, "answer": 9 }, { "question": { "id": 4, "label": "How do you rate the following elements?", "type": "MATRIX_SINGLE_CHOICE" }, "answer": [ { "ids": [ 55 ], "labels": [ "Drinks" ], "value": [ "Good" ] },

3 months ago

TimeXtender Desktop Q&A

Ask questions and find answers about the TimeXtender Desktop Application

Ingest

226 topics
1232 Replies

Prepare

220 topics
984 Replies

Deliver

65 topics
259 Replies

Jobs & Executions

115 topics
497 Replies

TimeXtender Portal Q&A

Ask questions about the TimeXtender Portal

General

35 topics
155 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
152 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
230 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
18 Replies

Community Statistics

1,399: Topics
4,686: Replies
983: Members

Awarded Badges widget

dennishanssenhas earned the badge Certified Solutions Architect
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

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