Skip to main content
To homepage To homepage

Ingest

Ask questions about Ingest Instances in TimeXtender Data Integration

  • 293 Topics
  • 1,572 Replies
293 Topics
K
Contributor
KarankadamContributor
asked in Ingest
Invalid data type long raw

The column LVALUE from the table "PROD"."MICROSOFTDTPROPERTIES" failed synchronization with the error:System.Exception: Invalid data type long raw. how to solve this error.

913
Christian Hauggaard
Community Manager
A
Problem Solver
aftabpProblem Solver
asked in Ingest
Paginated RSD file

I have a API endpoint with pagination: https://www.mytestserver,com/DWH/api/v1/all-buildings?buildingType=BAR&page=5 I have created a RSD file with the following code after </api:info> <api:set attr="in.Header:Name#" value="Accept"/> <api:set attr="in.Header:Value#" value="application/json"/> <api:set attr="in.DataModel" value="FLATTENEDDOCUMENT"/> <api:set attr="in.JSONPath" value="$.data"/> <api:set attr="in.EnablePaging" value="TRUE"/> <api:set attr="in.Page" value="1"/> <api:set attr="in.PageCount" value="100"/> <api:set attr="in.BaseURI" value="https://www.mytestserver.com/DWH/api/v1/all-buildings?buildingType=BAR&page={page}" /> <api:set attr="in.ElementMapPath#" value="/json/meta/pagination/pages"/> <api:set attr="in.ElementMapName#" value="pages"/> <!-- The GET method corresponds to SELECT. Here you can override the default processing of the SELECT statement. The results of processing are pushed to the schema's output. See SELECT Execution for more information. --> <api:script

29219
Thomas Lind
Community Manager
K
Contributor
KarankadamContributor
asked in Ingest
Tables are not Visible in Select Table Option while adding data from ODX to MDW

If you see Task are sucessfuly completed in ODX, and tables are vissile in query tool, but while loading data from ODX to MDW in select Table options tables are not visible, as shown in Figure

801
daniel
TimeXtender Xpert
D
Contributor
dsvartzmanContributor
asked in Ingest
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.CompilerServices.TaskAwaiter.HandleNonSucce

845
Christian Hauggaard
Community Manager
P
Contributor
pontus.berglundContributor
asked in Ingest
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?

73523
Thomas Lind
Community Manager
rvgfox
Problem Solver
rvgfoxProblem Solver
asked in Ingest
Azure Active Directory data source conector

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

2653
Thomas Lind
Community Manager
K
Contributor
KajEmergoContributor
asked in Ingest
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.

1053
Christian Hauggaard
Community Manager
K
Contributor
KajEmergoContributor
asked in Ingest
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 Postma

2018
K
Contributor
sierd.zuiderveld
Contributor
sierd.zuiderveldContributor
asked in Ingest
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.

1183
M
Starter
S
Contributor
Søren SørensenContributor
asked in Ingest
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?

1355
Christian Hauggaard
Community Manager
L
Starter
lukas.gStarter
asked in Ingest
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:

2329
Christian Hauggaard
Community Manager
andrew.gebhard
TimeXtender Xpert
andrew.gebhardTimeXtender Xpert
asked in Ingest
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 Uc

1724
Christian Hauggaard
Community Manager
erik.van.mastrigt
TimeXtender Xpert
erik.van.mastrigtTimeXtender Xpert
asked in Ingest
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?

513
bas.hopstaken
TimeXtender Xpert
erik.van.mastrigt
TimeXtender Xpert
erik.van.mastrigtTimeXtender Xpert
asked in Ingest
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:

1186
erik.van.mastrigt
TimeXtender Xpert
anders.e.jonsson
Contributor
anders.e.jonssonContributor
asked in Ingest
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.1 This 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. BR Anders

14216
anders.e.jonsson
Contributor
Bernarddb
TimeXtender Xpert
BernarddbTimeXtender Xpert
asked in Ingest
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?

1259
Christian Hauggaard
Community Manager
rvgfox
Problem Solver
rvgfoxProblem Solver
asked in Ingest
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.

1358
Thomas Lind
Community Manager
ignacio
Contributor
ignacioContributor
asked in Ingest
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

11515
ignacio
Contributor
P
Explorer
Pieter-JanExplorer
asked in Ingest
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...

1364
Thomas Lind
Community Manager
I
Starter
Ikemike
asked in Ingest
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?

1111
Christian Hauggaard
Community Manager
P
Contributor
pontus.berglundContributor
asked in Ingest
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/XMLSchema"> <!-- See Column Definitions to specify column behavior and use XPaths to extract column values from JSON. --> <api:info title="hierarchies" desc="Generated schema file." xmlns:other="http://apiscript.com/ns?v1"> <!--

933
P
Contributor
wouter.goslinga
TimeXtender Xpert
wouter.goslingaTimeXtender Xpert
asked in Ingest
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?

3345
Thomas Lind
Community Manager
sierd.zuiderveld
Contributor
sierd.zuiderveldContributor
asked in Ingest
ODX "Remove Unused Objects"

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

1133
Christian Hauggaard
Community Manager
boyclaesen
Contributor
boyclaesenContributor
asked in Ingest
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.

1554
Christian Hauggaard
Community Manager
Bernarddb
TimeXtender Xpert
BernarddbTimeXtender Xpert
asked in Ingest
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 f

907
Bernarddb
TimeXtender Xpert

Most helpful members this week

Badge winners

  • Certified Solutions Architect
    hay71has earned the badge Certified Solutions Architect
  • Certified Solutions Architect
    Himanshu Chhas earned the badge Certified Solutions Architect
  • Innovator
    oscarclevehas earned the badge Innovator
  • Certified Solutions Architect
    leo.noharethas earned the badge Certified Solutions Architect
  • Innovator
    Bernarddbhas earned the badge Innovator
Show all badges

Popular tags

Terms and ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings