Skip to main content
To homepage To homepage

General

General Questions about TimeXtender Data Sources

  • 62 Topics
  • 314 Replies
62 Topics
L
Contributor
Leo RogemanContributor
asked in General
How to load data from an XML-RPC API (Odoo)?

Hello,I'm trying to load data from an Odoo system that only exposes an XML-RPC API (no REST or SOAP). I want to bring this data into TimeXtender Portal, but I’m working under a few constraints: I do not have TimeXtender Premium, so I can't use custom scripts or PowerShell. I don’t want to introduce any external tools like Python wrappers or middleware. I can successfully call the XML-RPC API in Postman and retrieve data. I'm looking for a way to either automate or streamline this process without Premium features or external software. I’ve considered the XML data source, but it seems incompatible with XML-RPC since it doesn’t support HTTP POST or dynamic method calls.Has anyone found a way to work with XML-RPC APIs in TimeXtender under these limitations, or automated a file-based import process from tools like Postman?Any suggestions or workarounds would be appreciated.Let me know if you want to see the xml script. 

5913
Thomas Lind
Community Manager
M
Starter
matthieu.carratStarter
asked in General
Data source : Table/Field renaming in data source (Display Name)

Dear All, We have a “Dynamics Business Central (NAV)” data source with multiple adapters (multiple ERPs). We recently needed to “synchronize” the object to get the last BC evolution (new fields, ...). Unfortunately, the “Display name” of some tables/fields changed. 😒 Ex:-“Lot”“Lot No_ Information” table is now named “Lot No. Information” -“Demand Forecast”“Production Forecast Entry” table is now named “Demand Forecast Entry” Our default was to use “Display Name” (instead of Database Name) in the data selection and staging deployment. Our main concern is our significant number of sql views associated to these selected tables/fields with “hardcoded” name. We know that is recommended to use parameters to avoid problem with renaming but we didn’t implement the params in this case missing time and practicality with the sql code. 😥 Do we have an alternative solution without significant adjustments in our tables/fields selections and associated staging sql custom views ? TXT version: OnPrem

402
M
Starter
T
Starter
Tim TurnerStarter
asked in General
Excel Connector beyond 256 COlumns

Hello,We have a case in TimeXtender Classic where we need to read more than 256 Columns from the Excel connector.My understanding is that the underlying driver does support it, but by default it will only Return the first 256 Columns, and thus that is all we see when reading objects from the DataSource.Does anyone know if there is a way to expose more columns beyond the 256 already shown?ThanksTim

434
T
Starter
rbrandsma
Contributor
rbrandsmaContributor
asked in General
Prod execution fails after changing names in a table in Dev

Hi!Recently I have helped a customer upgrade their TX environment to version 20.10.66.64. With this upgrade it was advised to switch from an ODX setup to Business Units. So we recreated all datasources in the BUs and chose to set up just 1 BU for a datasource to service both Dev & Prod. Now the customer had to rename 2 column names in a table in the datawarehouse DSA on Dev. The next morning the execution package for Prod had halted with an error message stating there were 2 invalid column names. It could not find the 2 new columns. Performed a deploy on Prod and it ran normally. The next morning the Dev environment had not finished because of an error. There were 2 invalid column names, but this time the error message mentioned the old/original column names. We think the cause for this is in using only 1 BU for both Dev and Prod. And see 2 kinds of solutions Use 2 BUs, which would result in Using 2x as much data storage Retrieving data from the original sources 2 times to retriev

284
rory.smith
TimeXtender Xpert
M
Starter
MvHollandStarter
asked in General
Issue using multiple BC adapters at the same time.

Hi,We are currently experiencing a problem with using multiple BC  (NAV) Adapters at the same time. The two connectors are set up with individual app registrations as one is in the same Azure Tenant as where we are kicking off the execution, and one is in a different tenant all together. When I execute these tables one at a time or one source at a time, it runs smoothly with no issues. The issue is trying to run both sources at the same time. When I try that, it gives the following error:  The connectors are set up correctly as I am able to run them seperately. Does anyone have a fix or workaround for this issue? For the record: we are on Version 20.10.44.64 and we are using Business Units. 

668
M
Starter
B
Contributor
bjornContributor
asked in General
Snowflake as data source

Hi,I need to connect to Snowflake as a data source.I have downloaded the latest odbc version for windows from https://www.snowflake.com/en/developers/downloads/odbc/ and installed the provider.From XPilot I get an answer how to configure the odbc data source, but I cant find the “Private Key” field in no 4. That field seem to be “missing” in the config dialog.  Step 3: Configure the ODBC Data Source with the Private KeyOpen the ODBC Data Source Administrator Application and go to the System DSN tab. Press "Add" and select SnowflakeDSIIDriver. Click Finish. In the Snowflake Configuration Dialog, provide a name for the data source. Enter the connection details: User: The Snowflake user name. Private Key: The path to the rsa_key.pem file. Database, Schema, Warehouse: Specify the database, schema, and warehouse. Tracing: Set to 0. Test the connection to ensure it is successful. Press OK. Any suggestion on this? Where should I to put the filepath?regards,Bjørn A.

1186
B
Contributor
J
Starter
JakubStarter
asked in General
Empty data source provider list

Hi, I’m trying to add new data source provider but it looks like all of them dissapeared. Last week everithing works well. Licence is active, I using version 2.10.36.64. Any idea about the root cause?

1304
Christian Hauggaard
Community Manager
S
Explorer
Stijn HensenExplorer
asked in General
Unable to add new CData Data Source

Hello,I understand support for CData has been removed, see However, we cannot use existing drivers anymore either, as we don’t have the option anymore to add a CData Data Source via ODX.  If we click on Add Data Source, we only see some standard data sources, no CData drivers anymore.  If we click on Manage Data Source Providers, we do see the installed CData drivers. We use a lot of different Sharepoint connections to import certain data, and we cannot create a new Sharepoint connection now, without upgrading.  How can we add a CData Data Source now?  Upgrading of the client is currently not possible. This is a blocking issue!  How can we still add a CData data source?Thanks,Stijn Hensen

601
Christian Hauggaard
Community Manager
rvgfox
Problem Solver
rvgfoxProblem Solver
asked in General
Microsoft Dataverse Connector

I cannot see it in the Data Source Providers:Can you give me a setup guide? 

1613
Christian Hauggaard
Community Manager
X
Contributor
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. 

442
Christian Hauggaard
Community Manager
X
Contributor
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 

813
X
Contributor
avanrijn
Contributor
avanrijnContributor
asked in 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

20915
Christian Hauggaard
Community Manager
T
Participant
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

697
Thomas Lind
Community Manager
andri
Contributor
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?

30815
Christian Hauggaard
Community Manager
rbrandsma
Contributor
rbrandsmaContributor
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 

905
rbrandsma
Contributor
J
Starter
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.

714
Christian Hauggaard
Community Manager
P
Participant
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.

24117
Christian Hauggaard
Community Manager
M
Starter
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 :)

728
Christian Hauggaard
Community Manager
P
Participant
pkaustubhaParticipant
asked in General
Business Central Online Data Source Connection Error

Hi All,I am trying to connect a Business Central - Online Datasource and I completed all the Prerequisites as per the Training Documents, but when I am testing the connection on the Portal, it’s not giving me success and following is the error. Need your helpError opening connection to BC Cloud: System.ApplicationException: User must authenticate connection. at Jet.NavMetadataPlugin.ApiHelper.GetAccessToken(String filePath) at Jet.NavMetadataPlugin.ApiHelper.GenerateRequest(String url, String method) at Jet.NavMetadataPlugin.ApiHelper.<>c__DisplayClass29_0.<ApiGetResponse>b__0() at Jet.NavMetadataPlugin.ApiHelper.HandleThrottling(Func`1 action) at Jet.NavMetadataPlugin.ApiHelper.ApiGetResponse(Boolean needCompany, String apiName, Boolean& timedOut, String basUrl) at Jet.NavMetadataPlugin.BCCloudMetadata.GetTableViaStandardAPI(Boolean needCompany, String api) at Jet.NavMetadataPlugin.BCCloudMetadata.Initialize() at Jet.NavMetadataPlugin.BCCloudMetadataPlugin.Open(Boolean

1407
Christian Hauggaard
Community Manager
X
Contributor
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

1159
Christian Hauggaard
Community Manager
X
Contributor
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.

755
Thomas Lind
Community Manager
B
Contributor
bjornContributor
asked in General
TimeXtender ver 6675.2

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

593
Christian Hauggaard
Community Manager
vw-victa
Contributor
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.

1495
J
Participant
M
Contributor
MarcContributor
asked in General
Data not visible

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

706
M
Contributor
Roy V
Problem Solver
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.

1538
Roy V
Problem Solver

Badge winners

Show all badges
Terms and ConditionsCookie settings