Skip to main content

Data Sources Q&A

Ask questions of about setting up data sources

122 Topics
J
Visitor
jasperpVisitor
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.

2
Christian Hauggaard
Community Manager
1 day ago
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.

14
Christian Hauggaard
Community Manager
1 day ago
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 :)

8
Christian Hauggaard
Community Manager
5 days ago
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

7
Christian Hauggaard
Community Manager
5 days ago
G
Contributor
GardarContributor
asked in RSD File Customization
Pagination using "hasMore" response

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/XMLSchema"> <!-- See Column Definitions to specify column behavior and use XPaths to extract column values from JSON. --> <api:info title="entities" desc="Generated schema file_" xmlns:other="http://apiscript_com/ns?v1"> /> <attr

9
Thomas Lind
Community Manager
8 days ago
P
Participant
pkaustubhaParticipant
asked in SAP
SAP Public Cloud - TimeXtender Connection

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. 

1
rory.smith
TimeXtender Xpert
10 days ago
MartinMemelink
Contributor
MartinMemelinkContributor
asked in Oracle
Oracle data source Owner (schema) different between environments

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:And these selected tables don't exist in the production database, because they exist as prodOwner.tableName.This means that the tables cannot be found in the data source, and consequently cannot be executed. When syncing data source on prod all tables are dropped from the business unit, losing mappings to DSA, and no production tables are selected.One solution I can think of is to add ACCP and PROD tables in both environments, and use an environment variable to compens

4
Thomas Lind
Community Manager
11 days ago
K
Visitor
kenneth.bergVisitor
asked in RSD File Customization
REST API: Dynamic Dates, inputs and Data Selection Rules

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 could use an complete answer as to how to connect to an API with dynamic dates in the URL params.The guides/documentation found on this webpage is fragmented and doesn't work with the use case above.Thank you Kenneth

9
E
Explorer
12 days ago
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

9
Christian Hauggaard
Community Manager
15 days ago
P
Participant
pkaustubhaParticipant
asked in SAP
SAP Business One with HANA Database Connection with TimeXtender

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.

5
rory.smith
TimeXtender Xpert
15 days ago
R
Starter
r.brummansStarter
asked in REST APIs
Authorization with bearer token and json body

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"     }   } }

4
R
Starter
17 days ago
P
Participant
pkaustubhaParticipant
asked in SAP
SAP Analytics Cloud (SAC) as Endpoint for Visualization

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.  

4
Christian Hauggaard
Community Manager
17 days ago
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.

5
Thomas Lind
Community Manager
29 days ago
B
Participant
BennyParticipant
asked in REST APIs
How to configure an REST API endpoint with this kind of authorization?

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.What should I fill out in stead? My cicumvention (doesn't suffice). I configure one endpoint (access_token) to be a POST request (the request that will give back my bearer token). I then configure a second endpoint (Products) and use a dynamic value based on access_token and use it in the header Authorization. See images below.A POST request that will return my bearer token.A GET request that uses the bearer token value returned by the previous endpoint.This method does “wor

9
B
Participant
1 month ago
R
Contributor
RLBContributor
asked in REST APIs
Nested API calls maxes out?

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!

9
R
Contributor
1 month ago
avanrijn
Participant
avanrijnParticipant
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

8
Christian Hauggaard
Community Manager
1 month ago
J
Visitor
jasperpVisitor
asked in REST APIs
Load CSV Data from API

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 

1
Christian Hauggaard
Community Manager
1 month ago
J
Contributor
juriaan.hensbroekContributor
asked in Oracle
Oracle BICC (BI Cloud Connector)

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?

3
Christian Hauggaard
Community Manager
1 month ago
B
Starter
bjornStarter
asked in General
TimeXtender ver 6675.2

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

3
Christian Hauggaard
Community Manager
1 month ago
Paul McLeod Bespoke Analytics
TimeXtender Xpert
Paul McLeod Bespoke AnalyticsTimeXtender Xpert
asked in REST APIs
TimeXtender Rest Datasource with OAUTH2 Generated Bearer Token

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 potentially unusual was that when setting up my postman request to generate the Bearer Toekn the connection instructions specifically stated to setup the body as follows:Postman However I did not have to set the encoding in the standard CData Rest.I did try generating the bearer token in postman and then using that as a not expiring Bearer token to verify my core URL an

7
Thomas Lind
Community Manager
2 months ago
J
Contributor
jacqueline.hofmeijerContributor
asked in REST APIs
Field with Integer Datatype not valid in RestAPI

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

6
J
Contributor
2 months ago
G
Contributor
gediminas.juskenasContributor
asked in SAP
Unable to connect SAP to ODX Server (Cdata connector)

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 Is this a connectivity issue or am i doing something wrong / missing something? Note that i am not using DRIVER={HDBODBC} in connection string and i am not specifying any database to connect to. The above connection string works in Azure Data Factory. Thank you!

5
G
Contributor
2 months ago
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.

5
J
Participant
2 months ago
rory.smith
TimeXtender Xpert
rory.smithTimeXtender Xpert
asked in REST APIs
Get value of parent node instead of expanding to children

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": [                            "Drinks"                        ],                        "value": [                            "Good"                        ]                    },     

0
rory.smith
TimeXtender Xpert
2 months ago
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

6
M
Contributor
2 months ago

Badge winners

  • Certified Solutions Architect
    gfredheihas earned the badge Certified Solutions Architect
  • Innovator
    Bennyhas earned the badge Innovator
  • Certified Solutions Architect
    Roy Vhas earned the badge Certified Solutions Architect
  • ODX Expert
    ignaciohas earned the badge ODX Expert
  • TimeXtender Xpert
    danielhas earned the badge TimeXtender Xpert
Show all badges
Terms and ConditionsCookie settings