To homepage To homepage

ODX

Ask questions about TimeXtender ODX Instances

  • 169 Topics
  • 964 Replies

169 Topics

K
Contributor
KajEmergoContributor
asked in ODX

Connection issue ODX Server upgrade

When launching the newly installed ODX Server configuration (20.10.45), we get the following error:First, we thought this was a Firewall issue on our (Azure VM), because this test-netconnection did not work (see the second one failing):When I try to reach that second address from my local laptop, I get the same failure. Could you explain what is going on here? When using the ‘tracert’ to timextender-api.azurewebsites.net command in the command prompt on my local machine I see that it forwards to waws-prod-am2-061.cloudapp.net. When we try to do the same on the TX Azure VM, it times out on the first step. Do you have any advice on how to proceed here? Could it still be a Firewall issue on our VM?

5
G
Community Manager
3 months ago
D
Contributor
dsvartzmanContributor
asked in ODX

Error 503 (ODX)

hi, Lately were are getting alot of 503 exceptions.  Error message is typically: The task '983693' failed:System.AggregateException: One or more errors occurred. ---> System.AggregateException: One or more errors occurred. ---> System.Net.Http.HttpRequestException: Response status code does not indicate success: 503 (The server is busy.).   at System.Net.Http.HttpResponseMessage.EnsureSuccessStatusCode()   at Azure.Management.REST.RestWebRequestManager.<SendRequest>d__6.MoveNext()--- End of stack trace from previous location where exception was thrown ---   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)   at Azure.Management.REST.RestWebRequestManager.<SendRequest>d__5.MoveNext()--- End of stack trace from previous location where exception was thrown ---   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()   at System.Runtime.CompilerSe

4
Christian Hauggaard
Community Manager
3 months ago
P
Contributor
pontus.berglundContributor
asked in ODX

Limiting data ingested into Dev DW Instance

Hi,In version 20, we have a setup with two environments, a dev and a prod, that ingests data via a business unit. We are limiting the data ingested into dev by using the “Environment name” project variable together with a date filter, much like what is described here:https://legacysupport.timextender.com/hc/en-us/articles/360032668012-Creating-Dynamic-Data-Selection-Rules-using-Project-VariablesWhat is the equivalent of doing this in the latest version of TimeXtender? The client’s setup has one ODX and two DW instances (dev and prod). Their need is to limit the amount of data ingested into the Dev DW instance. Is this possible with the features available in version 6436.1?Best,Pontus Berglund

4
P
Contributor
4 months ago
P
Contributor
pontus.berglundContributor
asked in ODX

OAuth with authorization prefix "Bearer "

Hi,I am trying to connect to a REST API that uses OAuth2 authentication.The API documentation is very clear on what to include in the authentication:  I have entered all this information in the REST CData provider and I can successfully use the provider’s “Authorize OAuth” button.However, when I try to test the connection, error “401 - Unauthorizated” is returned.In the API documentation, they state that the token needs a prefix “Bearer “.I suspect my error is caused by the REST CData provider sending the authorization header without the Bearer prefix, like so:Authorization: {ACCESS_TOKEN}Which the API of course does not accept. Is there any way to include a prefix to the token in the authorization header?

23
Thomas Lind
Community Manager
4 months ago
rvgfox
Problem Solver
rvgfoxProblem Solver
asked in ODX

Azure Active Directory data source conector

Hi, can you provide me with detailed instructions on how to set it up?

3
Thomas Lind
Community Manager
4 months ago
K
Contributor
KajEmergoContributor
asked in ODX

Sharepoint data source 'Authorize OAuth' not working

When configuring the CData Microsoft Sharepoint (23.0.8669) provider for extracting a Sharepoint List, we encounter a problem with the button ‘Authorize OAuth’. We are configuring the data source in ODX Server 20.10.40 and TX version is also 20.10.40.The following settings are configured:According to the CData documentation AzureAD should be used as Auth Scheme to leverage OAuth to authenticate, we also use this exact same setting and the same app registration for another data source using the Excel Online provider for which all is ok.However, when using ‘Authorize OAuth’ with the Sharepoint provided, we get the following error:What could be causing this? Changing the file or location for OAuth does not matter at all, we have also tried other versions of the provider but they all give this error. Also, changing Initiate OAuth to ‘REFRESH’ does not have an effect.

3
Christian Hauggaard
Community Manager
5 months ago
K
Contributor
KajEmergoContributor
asked in ODX

Using open source API with download link

In order to retrieve meteorological data from The Netherlands, we want to use the Open Data API developed by the Dutch Meteorological Institute (KNMI). This website contains all relevant information on using the API.In summary, these are the steps that we want to undertake. Anyone can do this, because of the anonymous API key that is open to public:Locate the ‘Anonymous API key’, can be found on the KNMI documentation website Determine the dataset name, version and filename to establish the correct endpoint In this example we want to use the following endpoint: https://api.dataplatform.knmi.nl/open-data/v1/datasets/etmaalgegevensKNMIstations/versions/1/files/KIS___OPER_P___OBS_____L2.nc/url Execute the GET call (make sure to use Authorization header in combination with the anonymous API key The GET call returns a download URL pointing to the KNMI Amazone AWS storage which can be easily used in Postman to retrieve the data (in x-netcdf format)Would you like to try the above in Postman a

8
K
Contributor
5 months ago
sierd.zuiderveld
Contributor
sierd.zuiderveldContributor
asked in ODX

Best Azure VM size for ODX

Our ODX is hosted on a separate VM in Azure. We followed the suggestion to use the size DS2_v2, but we encountered frequent “System Out of Memory exception was thrown” errors that caused the ODX to stop. We are planning to switch to E2_ads_v5, which has twice the memory, but I am curious if anyone else has faced this issue and has any advice.

3
M
Employee
5 months ago
S
Contributor
Søren SørensenContributor
asked in ODX

varchar(max) fields not coming through in ADLS Gen2

I have a table with a varchar(max) field (stored in Dedicated Pool, which is a data source). and it won’t come through to ADLS Gen2 (ODX, version 6284.1). I’m using the Azure Synapse provider.The longest field contains almost 4 million characters, but I’ve been unable to figure out whether this is a limitation in TX or Azure. Does anyone know?

5
Christian Hauggaard
Community Manager
5 months ago
L
Starter
lukas.gStarter
asked in ODX

Cannot find files in Excel Online (Sharepoint with Delegated Permission)

We use Sharepoint for multiple data sources. Connecting the Sharepoint Lists works fine and I have a OAuth for Excel Online running as well, but my data source throws an error: Cannot find file.  I need to handle multiple files according to this documentation:https://support.timextender.com/data%2Dsources%2D112/connect%2Dto%2Dexcel%2Dfiles%2Dwith%2Dexcel%2Donline%2D628 What’s the reason for this?  My App Permissions are set accordingly: My Setup looks like this:  

9
Christian Hauggaard
Community Manager
5 months ago
andrew.gebhard
Participant
andrew.gebhardParticipant
asked in ODX

Nested API Call with case / if statement in RSD file

Hi community, I am trying to work with the LinkedIn API to retrieve details about UGC posts (i.e. engagements, clicks, etc.). This information is not part of the LinkedIn Marketing Solutions CDATA connector, so I am using the CDATA provider for REST 2022. I first made a call to the posts API to ‘Find Posts by Account’: Posts API - LinkedIn | Microsoft Learn. After that I need to pass each Post ID into the Organizational Entity Share Statistics API to ‘Retrieve Statistics for Specific UGC Posts’: Organization Share Statistics - LinkedIn | Microsoft Learn. The problem I am facing is that the Posts API returns two types of posts (which cannot be filtered in the API): shares and UcgPosts. Each of those types of posts needs a different URL format in the ‘Organizational Share Statistics’ API. So, I need a way to only pass one type of post into the second API. UCG posts are posts where the ID starts with 'urn:li:ugcPost:'The file RSD 1.txt works, until the first ID from the Posts API is a Ucg

4
Christian Hauggaard
Community Manager
5 months ago
erik.van.mastrigt
TimeXtender Xpert
erik.van.mastrigtTimeXtender Xpert
asked in ODX

SAP Table Data Source in ODX Server v21 - table filtering doesn't work properly

I’m struggling with the TimeXtender SAP Table Data Source version 18 in ODX Server v6429.1. In our current setup we use Table Name filtering like this: Please see the wildcards used. How does this translate to ODX Server v21? I have these three rules: The latter does not seem to work. I tried many variations (and did a sync data source consecutively), but when I click Select Tables under a transfer task, it only comes up with the tables matchin an equal-rule. Tables that should match a like-rule never show up: Using equal and wildcards doesn’t work either Any advice on how I should filter tables properly?

3
bas.hopstaken
TimeXtender Xpert
5 months ago
erik.van.mastrigt
TimeXtender Xpert
erik.van.mastrigtTimeXtender Xpert
asked in ODX

ODX Server and unicode data source fields

Hi community,I have a MariaDB data source which I connect to using ODX Server (v 6346) and the CData/ADO.net connector for MariaDB v 23.0.8565.0.The source database is set to collation utf8mb4_general_ci. I noticed by copying from ODX Server to a Data Area that some special characters are slightly different than the source/ODX. I can fix this by manually changing the data type to nvarchar instead of varchar, but that is a lot of field editing.The Override Data Type function can help as well, but as we have a wide range of field lengths, this also means a lot of override rules.Is there a way to tell ODX Server that all varchar fields should be unicode/nvarchar by default (eg. based on the source database collation)?Example from ODX Server. These fields should all be nvarchar(xx) instead of varchar(xx): Implementing this idea would work for me as well :) In TX v20 Business Units, we had this option: 

6
erik.van.mastrigt
TimeXtender Xpert
5 months ago
anders.e.jonsson
Contributor
anders.e.jonssonContributor
asked in ODX

Error when creating ODX Notification on Critical Errors

Hi,We are unable to set up Notification on Critical Errors for the ODX Server. Both service and database for the ODX is on prem. The Exchange Server is deployed as a hybrid. TimeXtender version 6221.1This is the error message:  Setting up notification for the executions in the MDW’s and SSL’s is no problem. No authentication is required by the Exchange server.BRAnders

16
anders.e.jonsson
Contributor
5 months ago
Bernarddb
Contributor
BernarddbContributor
asked in ODX

Execution log warning column already exists

Hi all,For one of my current client's we are rectrieving a warning while syncing the odx. The task is completed and we can transfer the data. but the warning is a bit odd.We already tried to remove the folder from the data lake and try a full load. but this didn't fix the warning. Anyone any ideas?

9
Christian Hauggaard
Community Manager
5 months ago
rvgfox
Problem Solver
rvgfoxProblem Solver
asked in ODX

Error in full load packages with the last version 6429.1

I’ve detected an error (sended to support) with the packages that use full load and if the incremental rule it’s defined with a datatime field.The error it’s in the ODX transfer and I’m using a SQL data source.Hope this help you.

8
Thomas Lind
Community Manager
5 months ago
ignacio
Contributor
ignacioContributor
asked in ODX

ODX task scheduke is not working

I am working on a project with 3 environments Dev, UAT, and Prod. I scheduled ODX transfer task to run every 15 minutes.But any scheduled tasks are not working, I have to run the transfer tasks manually  Regards 

15
ignacio
Contributor
5 months ago
P
Starter
Pieter-JanStarter
asked in ODX

ODX Read multiple json files from same directory

I’ve a location with multple different json files. Can i use one connector to this directory and transfer each json file, or need i to make one connector for each file? For csv files i can use one connector, for json it doesn’t seem to work this way...

4
Thomas Lind
Community Manager
6 months ago
I
Visitor
Ikemike
asked in ODX

Documentation to connect Hubspot

Hey.This is maybe obvious - but I’m struggling to find the proper documentation, hoping someone can point me. We have TimeXtender version (20.10.42.64) on a remote server at the company I’m with, and I'm new in a data analyst role. We have the need to connect a new data source, Hubspot, to TimeXtender.  Is there only general documentation to connect new data sources or is there specific documentation related to Hubspot?     

1
Christian Hauggaard
Community Manager
6 months ago
P
Contributor
pontus.berglundContributor
asked in ODX

Parse CSV in JSON object

Hi,I have a JSON data source that looks something like this{ "company": { "companyId": 1, "name": "AdventureWorks", "description": "" }, "hierarchies": [ { "depths": [ { "depth": 0, "name": null }, { "depth": 1, "name": "Company" } ], "allKeys": "1|-1|10" } ], "slicer": null, "userToGroup": "Username,GroupId\nJohn,G1\nSarah,G1\nPeter,G1\nKate,G1", "groupToKey": "GroupId,Key\nG1,10\nG1,101\nG1,102\nG1,103\nG1,104"}And I am only really interested in the last two objects, userToGroup and groupToKey, which both are in a CSV format. Is it possible to use something like xPath to navigate to these two objects and then parse them as CSVs? I have an RSD file that gives me userToGroup:<api:script xmlns:api="http://apiscript.com/ns?v1" xmlns:xs="http://www.w3.org/2001/XMLS

3
P
Contributor
6 months ago
wouter.goslinga
TimeXtender Xpert
wouter.goslingaTimeXtender Xpert
asked in ODX

Connect Progress database via ODBC

I am connecting to an Openedge Progress database via ODBC drivers. After finding out the password needs to be set in the registry, I am able to connect to the source (test connection from the Data Source properties is succesful).My sync task however fails because the datasource is not querying the correct metadata tables. In Progress, metadata for tables, columns and views is stored in the tables SYSTABLES, SYSVIEWS and SYSCOLUMNS. In the advanced settings of the datasource I am able to point out the correct column names, but not the correct tables (see screenshot below).Does anyone know how to point the datasource to the correct metadata tables?  

5
Thomas Lind
Community Manager
6 months ago
sierd.zuiderveld
Contributor
sierd.zuiderveldContributor
asked in ODX

ODX "Remove Unused Objects"

What does “Remove Unused Objects” do? I cannot find documentation about it. Thx!

3
Christian Hauggaard
Community Manager
6 months ago
boyclaesen
Contributor
boyclaesenContributor
asked in ODX

Date field is converted to an integer.

Hello, To my understanding TimeXtender determines the data type of a column based on first x amount of rows, depending on your setup in the portal.  The fields in my source  come in as (dd.mm.yyy) for example: "05.03.2021”. I use a Storage Account with a CSV connection.  I would expect that TimeXtender creates a "date” date type out of this. However, is seems that if a field character starts with a '0’, it skips it. In the ODX it shows an Integer value '5032023’.ODX: Depending if a character starts with a '0’ the fields (dates) show up like: It counts for all date fields and costs me a lot of time to create a work around each time. I tried to override the datatype in my data source but without succes. Help would be much appreciated.    

4
Christian Hauggaard
Community Manager
6 months ago
Bernarddb
Contributor
BernarddbContributor
asked in ODX

ODX Data source include vs Exclude tables

At one of my clients we are using the ODX and they set it up that for every different type of load they added the data source multiple times. So for the normal full loads there is 1 source . For the incremental loads of the same source there is a different source.In the data source selection the include only the tables they need for the full load. and they do the same for the incremental. But from time to time task wil not execute without showing up in the execution log without an error. I have the feeling that because the includes je indirectly exclude the other tables and if they are running at the same time this cancels each other out. In the windows logs you can see that the package then is skipped but it's no where to be found in TX.Does anyone have an explenation about this and/or an idea how we can fix this?My idea was that maybe putting everything in 1 source and then create 2 different transfer task instead of 2 different sources would fix this problem. Would love to hear from

7
Bernarddb
Contributor
6 months ago
B
Starter
BennyStarter
asked in ODX

Why does the app registration for the ODX need owner permissions?

Why does the app registration for the ODX need owner permissions on the resource? I would think that read/write permissions would be sufficient. Why does TimeXtender need the “extra” rights?

3
Christian Hauggaard
Community Manager
7 months ago

Badge winners

Show all badges
Terms and ConditionsCookie settings