To homepage To homepage

- - Knowledge base overview
Product Updates
Training
Portal
For Partners
TimeXtender Classic

Home
Community overview
Data Sources Q&A
General

General

General Questions about TimeXtender Data Sources

54 Topics
271 Replies

When you subscribe we will email you when there is a new topic in this category

54 Topics

Most replies

Most views

Newest first

Xiaoqing HuContributor

asked in General

Connect to JSON data source via api possible on on-prem but not cloud

Hello,With TimeXtender business unit on prem at an internal server, we were able to call an API via below settings, and load the data successfully. However, when we set up the same data source on TimeXtender Portal with basically the same setting. The data source tested either timeout or with error ‘Exception has been thrown by the target of an invocation.’, or connection tested okay but no metadata can be imported/synced. I have tried all below connection types but couldn’t get it work. Do you know why (for example to setup firewall or proxy) or have any advice? Thanks in advance.

151

19 hours ago

Xiaoqing HuContributor

asked in General

Error loading csv from Azure Blob Storage or Azure File Share

Hi everyone, We are trying to load csv file from Azure Blob Storage or Azure File Share with the guidance according to the posts below. But we are still receiving error: “Exception has been thrown by the target of an invocation.”Connect to CSV data sources | CommunityLoad CSV files from Azure Blob Storage | CommunityKindly see the connection details below. Could you help give some advice? Thank you! For Azure Blob StorageFor Azure File Share

avanrijnContributor

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

16715

1 month ago

truttafiskerParticipant

asked in General

Dynamic XML as datasource

Hi all,I’m still quite new to timextender so I appreciate all the help you guys give me.I have quite alot of different XML files containing alot of data. It’s product catalogs with porentially 40K products that contains different kind of parameters .. each product’s parameters varies from product to product .. som tell you the country of origin, som dont .. on some of the products there is information about delivery dates some and on some there aren’t.So all-in-all the different products and the different files varies a quite alot. The content of these files can change each day and some multiple times each day .. I would think that we all in all are talking about 600.000 different products.How would you approach this ?Is it possible for timextender to handle this or do I have to make some kind of XML-parser ?I guess I’m going to make a unique key there is based on the products no. and another parameter, but would you predefine the different parameters as a Field so I have to add a new

447

1 month ago

andriContributor

asked in General

BC Adapter - Merge extension tables option

In version 20.10.39 you sneaked in a new features in the BC Adapter data source: 17627: Business Central adapter - Merge extension tables option for SQL Server provider Added option to merge a table and its extension tables together as one table. This feature could be very useful but I can’t find any documentation on how it works and if there are any limits or considerations that need to be taken into account.Initial testing suggest that it works for some tables but maybe not for tables in extension modules?

25915

1 month ago

rbrandsmaStarter

asked in 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

695

2 months ago

jasperpStarter

asked in General

Can I retrieve the individual file names of an aggregated Excel table?

I have a folder that contains several Excel files I want to combine into one table. However, the week and year that the individual files refer to are only contained in the file names, not in the files themselves. Therefore, I have no way of knowing the week and year that a row of data belongs to when I aggregate the files using the Excel data source. Is there a way to aggregate all Excel files in the folder while also keeping information about which file a record came from? Or is making a separate data source for each file the only solution to keep this information?By the way, the Excel files are stored on a server requiring username and password, so the TimeXtender Excel data source is (currently) not an option.

524

3 months ago

pkaustubhaParticipant

asked in General

Microsoft Dynamics 365 Finance & Operation Data Source Connection

Hi,I want to connect Microsoft Dynamics 365 Finance & Operation - Cloud to TimeXtender. Need to your help to know the prerequisites and also the steps to connect the same to TimeXtender.

14417

3 months ago

marianaandradeStarter

asked in General

Issue while connection to Adventure Works

Hello! I’m new to TimeXtender and I was trying to complete the training but I’m having issues connecting to the Adventure Works database via TimeXtender. I connect just fine via SQL Server Management Studio 20: But when I try to connect with the same credentials and configurations via TimeXtender I get the following error message: Can anyone help me figure out what the issue is? At the moment this is really impacting my training Thank you in advance for your help :)

628

4 months ago

pkaustubhaParticipant

asked in General

Business Central Online Data Source Connection Error

867

4 months ago

Xiaoqing HuContributor

asked in General

Correct charset for special characters in CSV data source?

Hi TXD community: In ODX server we have built a CData data source connection with CSV 2023 provider. Kindly see the connection details below. The synchronization went successfully but the transfer task completed with one error and one warning.The error is :”System.Data.CData.CSV.CSVException (0x80004005): [500] Could not execute the specified command: Unable to translate bytes [E1] at index 3790 from specified code page to Unicode.” This error appears due to a strange character in a string ”Nicolás” in the source file and it shows as UTF-8 as below, as you can see from the connection details we have setup UTF-8 charset. So I have tried to ANSI charset but get the error “System.Data.CData.CSV.CSVException (0x80004005): [500] Could not execute the specified command: 500 -- 'ANSI' is not a supported encoding name. For information on defining a custom encoding, see the documentation for the Encoding.RegisterProvider method.” Do you know the valid encoding in this case or where is the docum

799

4 months ago

Xiaoqing HuContributor

asked in General

Load csv from Azure file shares with error "The given path's format is not supported"

Hi all, I am trying to connect to a CSV data source on Azure Storage Account File Shares. I have the CDATA configured as below according to Connect to CSV with CData – TimeXtender Support. But when I test the connection I got error “The given path's format is not supported.” Can you guys help me find the reason why? That would be much appreciated.

625

5 months ago

bjornStarter

asked in General

TimeXtender ver 6675.2

Hi,What happened to version 6675.2 of TX?regards,Bjørn A.

473

5 months ago

vw-victaContributor

asked in General

Loading Excel file from Sharepoint with Excel Online connector

Good day,for our customer we want to get data from an Excel file which is stored in their Sharepoint. We've used the documentation from this article.The authentication is successful and we are getting some results but not the Excel files. If we test it with our own (Victa) Sharepoint then we see many results and also Excel files.Below the screenshots from Victa and the second from our customer.Results loading from our own Victa Sharepoint (same connector and settings (entra id > app permissions)Same Excel Online connector but configured for the customer in their own Sharepoint.We cant figure out the difference because we use the same setup (clone) of the Excel Connector. Does the user who is authenticating the connector within TimeXtender need more rights on the Sharepoint side? We already gave for testing the account Owner rights and also added many API Permissions to the app registration.Hopefully somebody has an idea.

MarcContributor

Good Day All, At this moment we have the following challenge: Client is utilizing TX version 20.10.43.64. Client requested us to add new fields. We've modified the *.rsd file, columns are being created however data is not visible after we've deplooy and execute. We've verified the source and can confirm that data is entered. Is there something that we've missed or overlooked? Appreciate your support in here. Regards, Marc

556

6 months ago

Roy VProblem Solver

asked in General

Unstable TimeXtender API for Job/Execution data

We use the TimeXTender API (with settings as described in the following tutorial.We extract the following tables:The synchronization is succesfull however the extractions are very unstable: The error message is mostly:System.Exception: Invalid column count at DataStorageEngine.DataLakeGen2.DataLakeGen2TransferAny suggestions?I tried getting all columns in text but that did not solve it.

1348

6 months ago

Paul McLeod Bespoke AnalyticsTimeXtender Xpert

asked in General

Azure Data Factory - SQL Server (14.0.0.0) was not found

Hi I am trying to use ADF to connect to a on-premise SQL Database with some very large tables for transfer.I selected the Azure Data Factory - SQL Server (14.0.0.0) as the source and created the datasource.When I tried to Synchronize the ODX source in TX desktop (6521.1) I got the error message that the assembly for the provider is not installed.I cannot change the provider without creating a new data source (product enhancement request!), Do I need to upgrade the TX Desktop to get access to the drivers? Or is it some other install that I need to do? I cant find any documentation on this.

663

8 months ago

ignacioContributor

asked in General

Load CSV files from Azure Blob Storage

Hi everyone, I am adding a new data source to ODX, this connection has to load 6 cvs files from azure storage, could you help me to create the connection?Thanks Ignacio

HAlblasStarter

Good afternoon,We have a dsa table with data in one of it's columns in json structure. Can I translate this with a new data source or are there any other solutions?Thanks for contributing ideas.Kind regards, Heleen

474

9 months ago

anders.e.jonssonContributor

asked in General

Can you connect SQL Server database to ODX via a linked server?

Hi,A customer running version 6536.1 has provided us with a SQL Server database on a linked server (server L) as source, but we haven´t managed to connect to it so far.There is no problem running queries to that database on server L from management studio, when the query is run from the context of a database on server/instance where the linked server is added (server TX). This is a different windows server than the linked server.The appserver with the ODX-service is on yet another Windows server. The ODX database resides on server TX. Connecting to the ODX db and the TimeXtender MDW’s on server TX works fine.Is it possible to use a linked server as a source? If so, how should the server name(s) be specified in the connections settings in the portal?BRAnders

641

10 months ago

ManggaardStarter

asked in General

External Tables - Orchestration options

We are investigating the External Table feature to handle some special tables outside of TX, but still be able to utilize these for down-stream TX based processing.We would like to orchestrate the updates of these table from TimeXtender, but it seems like pre- and post execute scripts are not allowed on these tables.Can you confirm that pre- and post scripts are not available for external tables, alternatively provide a work-around to enable these. (It seems like a strange design choice to remove these hooks for this feature).Also, I find the schema option page grayed out on the table settings for an External table, would be nice to be able to put the generated views in some meaningful containers (not dbo).Thanks in advance.

353

10 months ago

JogchumSiRContributor

asked in General

Using App Registration for Authentication on Azure SQL DB

I was looking into using a managed identity (App Registration) to authenticate TimeXtender with Azure SQL DB resources, but can't get it to work. I couldn't find much documentation on the support site either.I created a login on the database using T-SQL. I can also login with SSMS using the Azure Active Directory - Service Principal method: I'm trying by using the Active Directory Password Authentication method in the Connection Settings dialog. Testing the data source in TimeXtender gives an non-specific error:Service request failed: One or more errors occurred. (System.Exception)Details:Service request failed: One or more errors occurred. (System.Exception)Module: TimeXtender.ODX.EngineTimeXtender.ODX.Engine.ODXFaultException at TimeXtender.ODX.Engine.ODXEngine.SendServiceRequest[C,T](WcfServerSettings serverSettings, Func`3 func) at TimeXtender.DataManager.EditDataSourceCommand.<Dialog_OnTestConnection>b__12_0() at TimeXtender.DataManager.ConnectingThread.ExecuteConnecti

6875

10 months ago

nohikhStarter

asked in General

Undetermined SQL Server version during read of source schema

Hi TimeXtender,Suddenly, we're encountering an SQL Server error: "Undetermined SQL Server version during read of source schema."We're currently using TimeXtender version 20.10.14.64. My question is: Does TimeXtender support the following SQL Server version?Microsoft SQL Server 2022 (RTM-GDR) (KB5032968) - 16.0.1110.1 (X64) Nov 9 2023 22:31:58 Copyright (C) 2022 Microsoft Corporation Standard Edition (64-bit) on Windows Server 2022 Standard 10.0 <X64> (Build 20348: ) (Hypervisor)Thank you!Regards,Ismail

1035

10 months ago

LorenzoContributor

asked in General

Properties Global database settings

Where can I find a description of the properties of the Global Database settings in general and in my case regarding a SQL server DB especially the “max rows to copy”. I have used 0 (hopefully then there is no limit but I have also seen that values are used).

1764

10 months ago

LorenzoContributor

asked in General

Source table dependency

Hi,We use BU's and some sources are created in another TX project.How can I verify / check the dependency of a source in this case a SQL table?For example I have in the BU a SQL table (using global database) that is created in another TX project.How can I check which TX project has created this table?And also in general, how can I create a dependency list of a TX projects (dependency with other TX projects)?Is this stored in the repository? Regards,Lorenzo

1425

11 months ago

Page 1 / 3

Badge winners

Dikshahas earned the badge Certified Solutions Architect
brett.taylorhas earned the badge Certified Solutions Architect
RobvdBrinkhas earned the badge Certified Solutions Architect
aftabphas earned the badge Ingest Expert
Leo Rogemanhas earned the badge Certified Solutions Architect

Show all badges

Terms and Conditions Cookie settings

Sign up

Already have an account? Login

Login with SSO

SSO login

Username *

E-mail address *

Full Name

(Private)

Only you and moderators can see this information

TX Partner / Customer *

Company

(Private)

Only you and moderators can see this information

Password *

I accept the terms & conditions

loginBox.register.email_repeat

Login to the community

No account yet? Create an account

Login with SSO

SSO login

Username or Email

Password

Remember me

Forgot password?

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.