Data Sources Q&A

When attempting to connect to the MySQL database using the ODBC Connector, we are encountering an issue where ENUM data type fields are not displaying. However, when manually inserting the field headers into the query, the values are visible.

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.

In many of the tutorials for dealing with specific types of APIs reference is made to internal variables like {TX_CurrentPage} and others that can be leveraged to implement things like pagination. As far as I can find there does not seem to be a list of such items and what they do. Could this be made available? 

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.

I'm trying to connect to an InfluxDB source, where a POST request is expected, including flux script in the body to filter data. The output is in CSV format. I have this working in Postman, but how should I configure this in TimeXtender? Anything I try results in the error below, which also means no RSD is generated.[500] Could not execute the specified command: HTTP protocol error. 405 Method Not Allowed

Hi,I'm using the TimeXtender REST Data Source (5.0) and trying to set up pagination.Right now the relevant table from the data source contains 3999 rows.However the table should contain 4092 rows.In the API documentation I couldn't find a XPath or a header containing a link to the next page.Could someone help me with configuring the pagination in the portal. (maybe by looping over the max row count) Thank you. 

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

Hi all, I have an api which is connecting to a restlet endpoint. trying to get this in timextender but I'm getting errors all the time. to set this up in Postman I have added a screenshot of the values i'm adding to my call, which is then added as a header to the call (see header png).Transferring this to TX gives me a 403 forbidden. I'm thinking this is because of encoding or the HMAC signing. But I have tried a lot of things but not getting the call through. Any suggestions as to how I can add a restlet with Oauth1.0? If more information is needed please let me know   

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

Hey, I have a question about our REST API. We need to implement client certificates, similar to here in Postman: Is this possible with the new REST provider? If not, what are the steps to do it with the old one?

I am trying to get data from Business Central dimensionSetLines for generalLedgerEntry using a cdata REST connector.I have copied the functionality for nested API call from https://support.timextender.com/data%2Dsources%2D112/advanced%2Drsd%2Dfile%2Doptions%2D884?tid=884#Using+nested+calls+to+get+data+from+multiple+pages.However, I get error message: [500] Could not execute the specified command: Formatter [ file_id ] failed in the evaluation of [fileout.file_id]. The error was:The value of the attribute could not be accessed: The attribute does not exist.Can you see anything wrong about the file?timeXtender version is 20.10.26.64 <api:script xmlns:api="http://apiscript.com/ns?v1" xmlns:xs="http://www.w3.org/2001/XMLSchema">  <!-- See Column Definitions to specify column behavior and use XPaths to extract column values from JSON. -->  <api:info title="GetAllStops" desc="Generated schema file." xmlns:other="http://apiscript.com/ns?v1">    <!-- You can modify the nam

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 

Hi, I have some trouble setting up a SOAP API within the RSD file. The envelope returns data as follows : <s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/"> <s:Body> <getCertificateListByCompanyResponse xmlns="http://tempuri.org/"> <getCertificateListByCompanyResult xmlns:a="http://schemas.datacontract.org/2004/07/" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <a:ObtainedCertificate> <a:CategoryName>text1</a:CategoryName> <a:CertificateCode>12345</a:CertificateCode> <a:CertificateID>12345</a:CertificateID> <a:CertificateName>text2</a:CertificateName> <a:CertificateNumber/> <a:DateAssigned>12345</a:DateAssigned> <a:DateExpire/> <a:DateObtained>12345</a:DateObtained> <a:Expired>false</a:Expired&g

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?

Hi I have a REST API that uses an item index as part of the URI, in the format https://<URL>/LocationPerilGroup/{PerilGroupID}.So an example call might be https://<URL>/LocationPerilGroup/12.This is a small lookup table and I was hoping that i could use an enum to repeatedly call the API while iterating through the list (40 items) to return the table to the ODX.My enum does iterate, but I only get output from the first record.Can this be done? Is there something I have missed? Please help.RSD file content below: <api:script xmlns:api="http://apiscript.com/ns?v1" xmlns:xs="http://www.w3.org/2001/XMLSchema">  <!-- See Column Definitions to specify column behavior and use XPaths to extract column values from JSON. -->  <api:info title="locationPerilSets" desc="Generated schema file." xmlns:other="http://apiscript.com/ns?v1">    <!-- You can modify the name, type, and column size here. -->    <attr name="LocationPerilSetsRecord_id"    xs:type="integer

Hi,I have a setup of a TimeXtender 20.10.41.64, ODX, ADL, ADF, Self hosted IR which I get to work just fine. I need to extract data from an IFS10 source, Oracle database, and the sync is too slow so it times out and fail after 2 hours. The data source is provided by a third party and which means that the customer doesn’t have control to change any settings and 2 hours should be enough time for a sync. The customer have a couple of TX environments After many tests and discussing with the customer a similar problem have occurred before, but in an environment not using ODX server, where a sync took over 2 hours and this was fixed in Timextender release 20.10.3, issue “8889: Oracle slow synchronization - affects all bit specific data sources”. After this release the customer says the sync only takes about 10-15 min. Could this be a problem in ODX server as well? I managed to get a successful sync with version 20.10.40 which took about 2 hours but after an upgrade to 20.10.41 I’ve  managed

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 having some trouble in using the nested REST API in combination with paging. The extensive description on how to use the nested call in the RSD-file was very helpfull. The only thing I cannot get working is the paging at the first level.Two different cases, but I think the same underlying issue. In the first case the pageoffset is used as a parameter, in the other one it uses a pagetoken (the nextmarker in a blobstorage). In the output, I do see that paging is applied, but the problem is that it starts at the first page again. I seems that when using the input- and output files the correct information about the next page is not being picked up by the api-call.I have tried the call without nesting (so only on the first level) and without qualifiying the parameters and then the paging is working correctly, but when I switch to in and out again, I get false results.Does anybody recognize this isse and solved it somehow? Kind regards,Jacqueline Hofmeijer