Data Sources Q&A

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

Hi, I need to connect  SAP Business One with HANA Database to connect to TimeXtender to extract the Data. Can you please share the prerequisites and steps to achieve the connection to extract the data.

I am getting a bearer token when i am running the json code below with the specified url, but i don`t know how to implement this json body in TimeXtender, is there any documentation available or a solution for this? {   "id": "",   "language": "en",   "data": {     "resourceType": "AUTH",     "item": {           "loginName": "api@user",            "password": "password",           "module": "API"     }   } }

Hi,I have couple of questions from a prospect who is using SAP.C​an we connect to SAP S/4 HANA Databased as Data Source, if yes how Once we get the data and create MDW/Data Mart, can we have endpoint as SAP Analytics Cloud (SAC) which is SAP’s Visualisation Tool.  

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,As mentioned here https://support.timextender.com/data-sources-112/advanced-rsd-file-options-884?postid=7688#post7688 I'm having some issues with nested API calls using the CData REST provider. It looks like it maxes out at 1,000 calls per iteration. Is this the expected behaviour or is there a setting I haven't found?Thanks!

I have an API that requires an access token to be retrieved using a POST request, which is returned as JSON. Most of the endpoints also return the data in JSON, which I can already extract using custom rsd files. However, there is one endpoint that returns custom reports in text/CSV format. So I'm looking for a way to retrieve the token from a JSON response and use it to do a second request to retrieve a CSV response.I've tried using the CSV provider to do this, but I get an error when I want to combine jsonproviderGet and csvproviderGet in a nested call using an rsd file based on my already working all-json rsd file: Is there a way to make this work? Thanks,Jasper 

Does anyone have experience with the “BI Cloud Connector“ of Oracle? They (Oracle supplier) say it could be used to extract data from Oracle Cloud to your local database.Currently we use scheduled CSV exports from Oracle to a SFTP location to load via ODX into TimeXtender. We wish to replace/remove this step and connect TX directly to Oracle Cloud.This Oracle BI Cloud connector inserts data into a database of choice (instead of the TX ODX pulling it out of a database). How can we integrate this with our TX environment?

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

I am having issues getting the new ODX TimeXtender Rest API to connect using OAuth2 and an authentication service to generate an expiring bearer token.I have been able to generate a token successfully using Postman, and I have been able to configure the standard ODX CData Rest datasource successfully with the authentication service. But using the same setup I am getting errors on the TimeXtender Rest service.This is the OAuth2 settings from the standard Rest Data SourceCData Rest OAuth settings that workThis is the OAuth settings from the new TimeXtender Rest datasource that don’t work.TimeXtender Rest APIThe only thing potenti

Hi all,I am using a Cdata Restapi to connect to a datasource, and it has been working fine up to now.It seems they have changed one of the fields, used for incremental loading, and this has now become too long to fit in a integer data type. I have had contact with the support team of the datasource and it seems the field had always been setup as a int64 field (not documented very well), but the value wasn't that big in the past. Now I get errors when retrieving data , stating that the field is too small. How can I adjust the field definition in TX so that it is a bigint field instead of int32? I tried with override datatype, but initially it still wants to load the data in int32.Using the TX 20.10 version, with business units and a cdata restapi connection. Has anyone experience with this? Kind regards,Jacqueline

Hello,I have difficulties connecting to SAP Hana (2.00.067.01) database using ODX Server version 20.10.47.64.I have a following connection string for the SAP connection: DRIVER={HDBODBC};UID=XXXXXX;PWD=XXXXXX;SERVERNODE=XX.XX.XX.XX:32215Machine where ODX Server resides has available connection to SAP HANA (using IP and Port i am able to telnet it). When i try to input the data into data source connection info in TimeXtender (either manually or as connection string) I am getting following errors: If the connector is SAP HANA 2022/23 the error is following: If the connector is SAP HANA 2019/20/21 the error shows that i am not connected

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 c

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

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.