Data Sources Q&A

Hi, I am trying to connect with NetSuite ERP and created a data source. But when I am testing the connection getting following error. Please let me know how to correct, so I can establish the connection and also let me know if there are any pre-requisites for the same. Also if you can also share the Data Connection screen with information to be added, would be great. I am using NetSuite (CDATA) Connector for the same.Following is the error  Service request failed: Exception has been thrown by the target of an invocation. (System.Exc

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?

I have an API with the following documentation:• https://baseball.help.trumedianetworks.com/baseball/data-pro-api-docs According to the API documentation, a token must be generated and included as a parameter. This is done using a master token provided by the supplier. When testing in Postman, I receive a response in CSV format; however, the same does not work in TimeXtender. In Postman, the request automatically generates a header "cookie" containing an access token (through redirection). Is it possible to use a cookie container with a redirect option? In cases where a query is redirected to another URL and an authentication cookie obtained from the original URL needs to be set in the redirected request? If so, is this option available in TimeXtender's REST or RSD functionality?

I am trying to achieve something complex in the TX REST connector using table flattening.I have the following JSON response: [    {        "id": 1,        "submitted": "2024-06-26T12:11:42+02:00",        "answers": [            {                "question": {                    "id": 3,                    "label": "How do you evaluate this?",                    "type": "SINGLE"                },                "answer": 9            },            {                "question": {                    "id": 4,                    "label": "How do you rate the following elements?",                    "type": "MATRIX_SINGLE_CHOICE"                },                "answer": [                    {                        "ids": [                            55                        ],                        "labels": [

Hello, we would like to select the columns what are loaded from a data source to odx with a odbc connector. We tried it this way Click on datasource → Select Tables → Select ColumnsBut there are not columns what we can select from: How is it possible to select columns for data sources using the odbc connector?  Thank you and best regards,Julia

Hello,We have a REST API where we use both Dynamic Value and Pagination (replace URL). The issue is that the paging works fine but only considers the first Dynamic Value and skips the rest. The final result then returns all pages for the first dynamic value and no rows for the rest. Further we also use Table Flattening as well as the Exhaustive Metadata Scan Option.  How can we make it loop through all dynamic values as well as keeping the paging option? API request:https://{base_url}/{company_url} Paging:Replace URL with {nextLink} type XPath Dynamic Value query:SELECT company_url FROM [MDW_Dev].[SysTransform].[Company_information]

I am using a REST API (CData source) to get source data. Since I need to include a CSR_NONCE value in the header (unique key value), the REST api is set up as a POST. Is it possible to specify that you want to do a POST rather than GET in a CData source?  

Hello all,I am currently trying to retrieve all Google Reviews for multiple locations for one of my clients, who operates 35 locations. Some of these locations have over 50 reviews, and since Google Reviews uses pagination through a nextPageToken for more than 50 reviews, I need to handle this pagination effectively.The client is running TimeXtender version 20.10.52.64, and I am using the CData connector version 24.0.8999.0. I have reviewed the documentation on the TimeXtender support pages about nesting an API call and utilizing pagination. I am attempting to set up the Query Slicer to loop through the locations and retrieve all reviews per location, but I am encountering difficulties.Here’s what I have set up so far:I created two .rsd files:locations.rsd: Retrieves a list of all location IDs. This returns 35 locations, as expected. locationsReviews.rsd: Retrieves al

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

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.

The below image is the documentation for my endpoint. I can't get this to work. When I configure this in the portal I get back a 415 error. Any general guidelines on how to configure this? Update 2024-07-22The regular way:I’ve been doing some additional testing. Here's a more detailed description of my findings/problems. The API wants to receive a JSON body like so:{ "grant_type": "authorization_code", "code": "abc***123"}I tried to add fill out the portal like this:This doesn't work and returns the 415 error.Wh

Hi,I have used the SAP Cloud for Customer Connector to connect SAP C4C and setted up following parameters Getting the error, Need your help on the same as  I have a demo tomorrow ​But I am getting Error as Service request failed: Exception has been thrown by the target of an invocation. (System.Exception)Details:Service request failed: Exception has been thrown by the target of an invocation. (System.Exception)Module: TimeXtender.ODX.EngineTimeXtender.ODX.Engine.ODXFaultException   at TimeXtender.ODX.Engine.ODXEngine.SendServiceRequest[C](WcfServerSettings serverSettings, Action`2 action)   at TimeXtender.DataManager.Conn

Hi,We have a Midmarket customer in India who want to use TimeXtender for Analytics Purpose, but not keen to invest in Theobald. What is the most effective and reliable way to connect to SAP to extract Data to TimeXtender. Also if you can share step-by-step guide with example. 

Hi,We have a customer in India who is moving from SAP to some other ERP. They want to extract all the transactional data from SAP to Data Lake for future usage before discarding SAP. As it is one time activity, not interested in investing in Theobald.What is the best and most effective way to extract the Data to TX and then use with new ERP for Analytics Purpose.  

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.

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

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

I am dealing with an API that let’s me query its database. With LIMIT and OFFSET I want to fetch all the rows dynamically using an RSD file.Here’s the json response:{ "entities": [ { "Portfolio": { "id": "9999999999999999", "Name": "Test9" } }, { "Portfolio": { "id": "1111111111111111", "Name": "Test1" } } ], "paging": { "from": 2, "hasMore": true, "limit": 2 }}And here is my RSD file. I haven’t gotten it to work with pagination and I just get the errorThe attribute 'hasMore' does not exist.<api:script xmlns:api="http://apiscript.com/ns?v1" xmlns:xs="http://www.w3.org/2001/X

Hi,We have a prospective customer in India who is using SAP Public Cloud. Would like to know how can we connect SAP Public Cloud to TimeXtender. Need your inputs on the same as we need to start a PoC with them in this week.Have anyone tried and connected. If yes please share your experience. 

We have an issue with an Oracle data source, having a different “Owner” between the acceptance and production environments.We're on TimeXtender 20.10.51 using Business Units.The Oracle data source is configured using a global database. On acceptance it looks like this:When the data source is added on acceptance, objects are read as accpOwner.tableName.The production global database properties look like this, with a different owner:However, on production TimeXtender expects the same owner that was configured in acceptance:

HiThis is a somewhat similar question asked by Sturla SvendsenThe API I am using only returns data when fromDate and toDate are populated in the URL params.When setting up the Data Source (CData) I won't be able to fetch anything without these dates.I have tried creating the datasource with hard coded dates in the Edit-window in DH and altering the RSD-file the way that Thomas Lind informed Sturla about in the post linked above.However, when I delete the URL params in the Edit-window, and rely solely on the already created RSD-file, the connection won't work (401 as the url is invalid).When I try to add data selction rules and execute, it states the the input fields (that are written in the api:info-secion of the RSD-file) are unknown.I really coul

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.