General

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

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

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.

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

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.

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

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.

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.

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

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

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

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.

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

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

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

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 

I have created a new disk om ny TX server to move RSD files out of C-disk.I understand that i have to change certain settings so that when i run TX it connects to the new disk and not C-disk.Where do i go to change settings for that?

In TimeXtender 20.10.xx there was a button called “Find unused fields”. I have noticed that in version 6k there is no such button. Has it been moved or removed? Thx!

Hi,Has anyone used a Power BI dataset as a data source? I have tried using the CData SSAS connector but can not get it to work. Any advice would be appreciated.Best,//Pontus

Hi Everyone,---------BackgroundMy organization is trying to build a Supervisory Org tracking database. Our previous HRM system did this natively, and enough departments are tired of waiting for the new system quirks to be ironed out so I’m tasked with a work around. I can’t connect TX directly to the new system, but HR can download a csv that includes employee ID, Employee Name, Supervisor ID, Supervisor Name, Job Title, Work Location and various less critical fields.My plan then was to have an HR rep download the csv file once a week to a specific network folder, point TX at it with the Multiple Text File data source. I’d then use the DSA to perform some basic transformations and enable history on the DSA table. In theory this gives me a weekly update to an employee, tracking changes to key things like job title, supervisor, etc. We have a little over 1200 employees in the report, and 60-70k records a year shouldn’t be a problem. The initial ingest works well. TX reads the file, moves

Hi I am using TimeXtender 20.10.37.64 incl. ODX server. I am trying to get some data from XML files with a wildcard which have the filename as a reference to another file. I am using the Cdata XML connector. I managed to get the data from both files in TimeXtender but can’t find a way to include the original file name to the table/query. Is there a standard option for this or maybe a workaround? Hope someone can help me.

(Using Timextender 20.10.35.64)I have 2 date fields on a table. I want to load the row if one OR the other fields have changed in the data source. How do I do that?I tried doing this (see under)  but that caused duplicates because data had already been loaded (when only the loggedat field was the incremental field)  If I do this (see under) will it only load if both of the fields have changed? 

Hi everybody,Our client uses a SOAP API from a supplier. While TX supports SOAP the extraction requires multiple steps and string manipulation. The complete process is:For each table in the list of tables: Call the first SOAP endpoint to retrieve the names of the fields in the table Call the second SOAP endpoint to retrieve a page of data for the table Split the data into individual rows by splitting the string on the ^ character Split the rows into individual colums by splitting the string on the | character Fetch until the number of rows returned is less than the page size Move to next table We created a custom data provider for the TX custom data connector. This works fine in TX 20.10, but is not supported in 6221, so we need to create an alternative. I’m aware that you can use RSD files for more advanced logic, but as far as I can see this doesn’t include an option to perform the string manipulation (splitting). For the time being, we’ve ported the logic to a Python script

Hi all,We are trying to load CSV files into the ODX using the CSV data source. However we are getting errors on fields it is trying to interpret as int (housenumber), but some are filled in as 12-18 and therefor failing. We have tried to use the override data type option, but to no avail. What can we do about this?Kind regards,Maarten

Good DayI am setting up a new Data Source in TimeXtender. This dataset is very large and would like to eventually have this running as an incremental, but I have the task of importing the last 5 years of data first.I have tried to set this up with an Incremental Table setup in TX, but I keep getting a timeout setting. Iam wondering if I could set this table up as Simple for the historical load and then swap to Incremental but am worried my data would be cleared on changing the table type. Does anyone have any experience with loading in data with a similar scenario?Kerry