Skip to main content
To homepage To homepage

Ingest

Ask questions about Ingest Instances in TimeXtender Data Integration

  • 250 Topics
  • 1,357 Replies
250 Topics
oscarcleve
Contributor
oscarcleveContributor
asked in Ingest
Special Character Encoding Issues with Swedish Characters in ODBC Oracle Integration

Hello,I'm facing an issue with how TimeXtender handles special Swedish characters (å, ä, ö) when querying data from an Oracle database through the ODBC data source. I have a view that contains a column with the data type (VARCHAR2) in the Oracle DB. When loading the data to TimeXtender the special characters appear as question marks (å), a (ä), and o (ö).  However, when I create a Query Table and use CAST(CF$_PLAN AS VARCHAR2(1000)) on the same column the special characters are retrieved correctly to TimXtender.   I have queried DUMP from the database to check that the column’s special characters are stored with proper UTF-8 encoded values, and they are.I have also checked the NLS settings for the Oracle database, the TX application server and the ODBC connection.Is there a way for these special characters to be retrieved correctly to TimeXtender without having to use CAST in Query Tables?I use TimeXtender Data Integration 6822.1 and TimeXtender Ingest Service 6823.1. The ODBC Driver u

102
oscarcleve
Contributor
6 hours ago
A
Contributor
aftabpContributor
asked in Ingest
XML ingestion

Anyone have a suggestion about how do i use this XML to ingest data into ODX?<?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <soap:Body> <ExportDocsProjectWithTendersResponse xmlns="http://publicprocurement.com"> <ExportDocsProjectWithTendersResult>{ "ProjectBodies": [ { "ExternalId": "666666", "DefaultEvaluationModel": "LowestPrice", "DocumentNumberingSchema": "Numeric", "SectionNumberingSchema": 0, "RequirementNumberingSchema": "Alphabetic", "Metadata": [ { "Name": "ProjectName", "Value": "Ingesting Data into TX" }, { "Name": "Reference", "Value": "123456" }, { "Name": "ContractType", "Value": "XML" } ], "DataFields": [ { "ExternalId": "1",

184
A
Contributor
10 hours ago
D
Contributor
DylanW.Contributor
asked in Ingest
Issues with TimeXtender_Ingest_Service_6823.1

I wanted to ask if others have experienced issues with the TimeXtender_Ingest_Service_6823.1.For the second time, I’ve encountered problems with opening the ODX, where it gets stuck during the process. When attempting to restart the Ingest service, it remains in a "stopping" state and fails to restart properly.To resolve this, I’ve had to manually force the TimeXtender_Ingest_Service_6823.1 to stop using the Command Prompt. Once the service has been forced to stop, I can restart it successfully, and afterward, the ODX opens without issue.Has anyone else encountered similar problems? If so, are there any recommendations or fixes to prevent this from occurring again?Looking forward to your insights.

373
Christian Hauggaard
Community Manager
18 hours ago
A
Contributor
aftabpContributor
asked in Ingest
Using XML to ingest data

Its my first SOAP ingestion.The XML looks like this <?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <soap:Body> <ListPublishedFilesResponse xmlns="http://something-something.com"> <ListPublishedFilesResult> <idbdata xmlns=""> <originator> <company name="ABC Corp" url="http://www.abc.corp" /> <contact name="ABC Corp" email="post@abc.corp" /> </originator> <generation date="2024-12-09 10:43:09" dateutc="2024-12-09 09:43:09" /> <contract origin="tendsign.com" tendsigncontractid="2649113" name="Protocol" referencename="1 (ABC-01)" startdate="2018-07-01 00:00:00" startdateutc="2018-06-30 22:00:00" enddate="2025-0

14323
Thomas Lind
Community Manager
3 days ago
avanrijn
Contributor
avanrijnContributor
asked in Ingest
E-mail notifications on Ingest ODX Data Source Data Transfer Task

Dear Sir,We are looking for following.E-mail notifications when an Ingest ODX Data Source Data Transfer Task is failing to load the data from the source application/database.Is this possible in TX version 6766.1 ?Or do we need an upgrade. Regards from Venray.Arthur

211
Christian Hauggaard
Community Manager
3 days ago
G
Contributor
gediminas.juskenasContributor
asked in Ingest
TimeXtender classic ODX connect to Azure SQL / Synapse storage

Hello,We are using TimeXtender classic ODX server (20.10.51) to ingest data. Some of our data sources are located in Azure in form of Azure Synapse / Azure SQL.Are there any guides on how to setup data ingestion from Azure to on-premises ODX server?I.e. what are prerequisites from Azure side (service principal / managed identity?) to connect and what connectors should be used from the ones available in ODX server?I know this is possible from cloud version of TX, but is it possible to do so from classic version? Thank you

323
Christian Hauggaard
Community Manager
6 days ago
M
Starter
mikeschipperStarter
asked in Ingest
Add Fabric LakeHouse as new source

Hi All, I try to add my Fabric LakeHouse as a new source in TimeXtender version 20.10.50.64 but I keep getting an error when I try to read objects from datasource eventhough it says connection is succesfull.Data source settingsI copy the SQL connection string from my lakehouse and put it as server name. When I do "Read object from data source” I get the following error. The weird thing is that when I try these exact same stept in SSMS I can see the table from the source with the data in it. Am I missing some steps? 

497
M
Starter
6 days ago
M
Contributor
MarcodenijsContributor
asked in Ingest
Timextender Excel data source error.

I’m trying the new timextender excel data source but I keep getting errors. I have upgraded to TimeXtender Ingest Service 6823.1 and TimeXtender Data Integration 6822.1.I am trying to load a really basic excel file. First I tried the ‘Infer data types’ option. It succesfully detected the datatypes but I still end up with an error in the last step of the metadata manager.Service request failed: The given value of type String from the data source cannot be converted to type nvarchar of the specified target column. (System.InvalidOperationException)It does not say which column is the issue.After this I tried to disable the ‘infer data types’. It shows all my source columns as text but I still end up with the same error. Lastly I tried to override the data types to varchar(max). Still the same error. Any ideas on what I am doing wrong here?  

361
Thomas Lind
Community Manager
6 days ago
A
Starter
anders.bengtssonStarter
asked in Ingest
Soap 1.2 Request from ODX - is it possible?

Hi,Have anyone succeeded with a Soap 1.2 call from ODX?We have a source that only have a Soap interface. I've done a lot of testing but so far very little success.For the moment it complains about my content-type header. Don't know why. I'm using the rest connector. Perhaps I should use a xml connector instead. If anyone could share a working example I would be more than happy. Perhaps it's not possible at all. I'm not sure. RegardsAnders Bengtsson

1223
A
Contributor
7 days ago
L
Explorer
linda.monincxExplorer
asked in Ingest
Accessing Unity Catlog (Azure Databricks) with TimeXtender (20.10.44)

Hi, I have a unity catalog in azure databricks where I want to connect to from Timextender (20.10.44), I installed the Cdata connector for Databricks (2024) and am able to connect via test connection (succesfully connected) but when i try to save TX has issues with the length of the (Protocol ?) version which is empty but also using 1 till 8 which are available in the drop down list all result in the same errorWhat do I need to do in order to get his working? Kind regards,  

4010
L
Explorer
7 days ago
P
Participant
pkaustubhaParticipant
asked in Ingest
TDI and Ingest Service Download

Hi I want to download the latest version of TDI and Ingest Service which is 6823.1. But when I use the link to download, it still gives 6822.1. Can you please share the link for the same to download.Also can someone share the link to download 6766.1 with Ingest Services.

161
Christian Hauggaard
Community Manager
7 days ago
A
Explorer
annfossExplorer
asked in Ingest
TimeXtender CSV Data Source - PathNotFound (aggregation pattern)

Hi,We are trying to connect to several CSV files stored in a local folder. While we can successfully synchronize the data source and perform a full load in the ODX, we encounter an error when attempting to add the table to our data area (DSA).The issue lies in the path to the Parquet file stored in Azure. The correct path should be:CSV_DNB/csv_*/DATA_2024_11_28__11_09_50_2219585/DATA/DATA_0000.parquet However, the path Timextender is looking for is:CSV_DNB/csv_^*/DATA_2024_11_28__11_09_50_2219585/DATA/DATA_0000.parquet It seems that Timextender is misinterpreting the automatically generated name and adds a ^ character.I also attempted to use a specific file aggregation pattern, such as;H100.*.csv(all files in folder have the prefix H100 followed by a random number). However, I encountered the same error. Is there a way to specify the name of the table generated in the ODX? It seems like the “File aggregation pattern” is the issue. Do you have any idea how to fix this?  -Execute Executi

747
Christian Hauggaard
Community Manager
11 days ago
B
Contributor
BobContributor
asked in Ingest
New column not showing in datasource

Hi,we have an Afas datasource via provider cddata rest 2023. The Afas getconnector has been updated with new columns. When i run the sync task for this Afas datasource i expect timex to detect the new columns but this is not the case. What do i need to do to let timex see this new columns? thank u in advance,Bob

428
B
Contributor
12 days ago
B
Contributor
BobContributor
asked in Ingest
Transfer task new datasource completed with errors

Hi,we have created a new datasource for Azure Active Directory(Entra ID) via “cdata ado.netprovider for azure active directory 2022”de sync task runs ok but the transfer task keeps giving a completed with error signal. I have discussed this error with a consultant and a system/ authorization specialist but we cannot get it right. The error we are getting is(first part of the error): Executing table azuread_users:failed with error:System.Data.CData.AzureAD.AzureADException (0x80004005): [500] Could not execute the specified command: [Authentication_RequestFromUnsupportedUserRole] User is not in the allowed roles.  ---> cjo220x.BG: [Authentication_RequestFromUnsupportedUserRole] User is not in the allowed roles.  ---> cjo220x.Qt: [Authentication_RequestFromUnsupportedUserRole] User is not in the allowed roles.please advise us how to handle this. thank you in advance,Bob van Ierssel

403
B
Contributor
13 days ago
Bernarddb
TimeXtender Xpert
BernarddbTimeXtender Xpert
asked in Ingest
Different output query tool vs transfer in the odx TX SQL connector (Classic)

We are experiencing a small issue with one of the connectors while using managed queries. When I use the query tool, we are utilizing the SQL endpoint from a Fabric Lakehouse to retrieve the data into the ODX. When I query the DBO table, I receive 12 records. For example, when running this query:SELECT [SinkCreatedOn],       [SinkModifiedOn],       [omoperatingunitnumber],       [modifieddatetime],       [modifiedby],       [createddatetime],       [createdby],       [dataareaid],       [recid],       [tableid],       [createdon],       [modifiedon],       [IsDelete]  FROM dbo.[omoperatingunit] I also get 12 records. However, when we transfer this managed query, we only receive 11 records. This issue has occurred with multiple tables. We are not applying any filters to this dataset.Do you have any idea why this might be happening? Manually excluding or including all the columns is not manageable on the scale we are working with, so we rely on writing managed queries.

515
Christian Hauggaard
Community Manager
14 days ago
M
Contributor
MarcodenijsContributor
asked in Ingest
Override data type

I believe I followed the instructions I found here: But for some reason it wont work on my end, or maybe i’m doing something wrong? I’m using TX version 6745.1 which is one of the latest. I have set the column that gives me the error to convert to text.After that I double checked to see if TX would indeed override the datatype and turn it into text. I synchonize again and try to transfer. But for some reason it keeps throwing me the error:Message: Error obtaining value '25-mei-1991' for column 'Geboorte Datum'. Failed to convert  to datatype: 'datetime'. The original datatype of the column is: 'datetime'.Am I missing how this is supposed to work, or am I doing something wrong?

719
M
Contributor
17 days ago
B
Contributor
BennyContributor
asked in Ingest
Incremental load rules in Ingest Instance incorrectly set/displayed in UI

Hello,Sometimes a picture says is all, but to be complete:I set my incremental load rule on my datasource to mach any field containing ‘UPMJ’ (INT) with updates and deletes and most importantly: set the “substract from value”-value to 2. Looking at the picture above this is either not set correctly or not displayed correctly. 

323
Christian Hauggaard
Community Manager
24 days ago
avanrijn
Contributor
avanrijnContributor
asked in Ingest
Microsoft Excel Online

Dear Sir,We connect to our Excel files through a Sharepoint site with some Document Libraries. Works fine, but the performance is bad 😑 -5 minutes wait to Select Tables -5 minutes wait to execute Synchronize 5 minutes wait for execute Full Load Is there a way to squeeze some performance out of this ? Thanks in advance for looking into this performance issue. Regards,Arthur 

6810
Christian Hauggaard
Community Manager
25 days ago
avanrijn
Contributor
avanrijnContributor
asked in Ingest
Connecting to PostgreSQL database with ODBC

Dear Sir,I want to connect to a PostgreSQL database via ODBC.So I found these posts how to fix this. But I am using TX version 6766.1.Can someone please point me the way how to fix this with the latest and the greatest version of TimeXtender.See Word document in the attachment with my setup.https://legacysupport.timextender.com/hc/en-us/articles/4410466782621-Create-a-ODBC-data-source-in-a-ODX-or-with-a-Any-Source-ADO-Net-provider-in-a-Business-UnitThanxs in advance.Regards,Arthur

212
avanrijn
Contributor
26 days ago
avanrijn
Contributor
avanrijnContributor
asked in Ingest
Load semicolon csv file

I am trying to load a semicolon csv file with ODX (version 6766.1)The output is just 1 column.What box do I have to tick in the app portal to seperate the collumns on ; (semicolon) ?Regards,Arthur

292
Thomas Lind
Community Manager
1 month ago
R
Starter
RobvdBrinkStarter
asked in Ingest
Ingesting JSON files from nested date and hour subfolders

Hi all,I am currently working with a client who is using TimeXtender version 6766.1 in an Azure environment. We are trying to ingest data from a source that generates JSON files stored in a hierarchical folder structure organized by date and hour. The folder structure is as follows:subject/version/date=YYYY-MM-DD/hr=HH/*.jsonExample Path: dev/Call/1.2/date=2024-10-30/hr=14/*.jsonWithin each hr=HH (hour) folder, there may be one or more JSON files. Similarly, each date=YYYY-MM-DD (date) folder may contain multiple hour subfolders, though it's rare for all 24 hour subfolders to be present.I have successfully configured the data source connector in TimeXtender to read all JSON files from a specific hour folder, as shown in the example above. However, our goal is to configure TimeXtender to ingest all JSON files across all date and hour subfolders under the main path:dev/Call/1.2/ When I attempt to use wildcards to achieve this—such as:dev/Call/1.2/*/*/*.json I encounter an error stating:E

642
Thomas Lind
Community Manager
1 month ago
S
Contributor
sigsolContributor
asked in Ingest
JSON with an empty property name in TimeXtender REST API 6.1

Hello,I am encountering a challenge with the REST connector when it deals with JSON data that includes empty property names. This issue arises specifically during the conversion of JSON to XML.The REST connector fails when trying to convert JSON data that contains properties with empty names. Here is the error message I receive:Failed to execute endpoint 'authenticate':XmlNodeConverter cannot convert JSON with an empty property name to XML. Path 'TX_Autogenerated_Element.menu.categories.', line 1, position 94530. This error stops the ingestion process because XML does not support tags with empty names, which are present in the JSON structure. This is the problematic part of the JSON structure:{    "categories": {        "": {            "collapsed": false,            "description": "<No Category>",            "id": ""        },        "BUD": {            "collapsed": false,            "description": "Budget",            "id": "BUD"        }        // Additional categories    }} I

17510
S
Contributor
1 month ago
P
Contributor
Paul BridgeContributor
asked in Ingest
Overnight Jobs Not Run - Failing ODX Service

HiWe experienced for the second time a failure with our overnight TX jobs not running (first time was on 16 Sep) and on investigation we were not able to open up the ODX in TimeXtender (same issue as already logged here https://support.timextender.com/ingest-89/tx-freezes-when-opening-the-odx-2248)Could not manually stop and restart the  [TimeXtender_Ingest_Service_6744.1] service, so had to manually kill the task from the CMD and rerun the [TimeXtender Ingest Service Configuration 6744.1] tool.In the other post the conclusion seemed to be that this issue had now been resolved, but for us the issue has now occurred twice in the last 6 or so weeks.Is this still a known issue?TimeXtender Ingest 6744.1TimeXtender Data Integration 6745.1

441
Christian Hauggaard
Community Manager
1 month ago
M
Starter
MaarsenStarter
asked in Ingest
GA4 -- Multiple Properties

Hi, I'm currenty developing the GA4 connector in TimeXtender. With some other tips and tricks of other posts it was quite simple to create the connection. At this moment I have 7 different properties from where all data should be loaded. I've read multiple posts but haven't found a solution to extract data dynamically over a list of properties.  Current setup:CData Connector -- Google Analytics In this connector I can filter on property ID. TimeXtender -- v6xxxx + ODX Creating managed Queries to filter the relevant data from [GlobalAccessObject]. But haven't found a property id in this list.  I think that currently the only option is to create for each property one connection. Or has someone found another solution?

494
andrew.gebhard
TimeXtender Xpert
1 month ago
M
Visitor
MarcoVisitor
asked in Ingest
Ingest Data from Infor Data Fabric

Hi, we are in a project to update our on premise ERP system Infor to the current version Infor LN CE which is running on the cloud. Since we cannot access the database then directly we are currently checking how to ingest the data to TimeXtender in future. There is a tool within the ERP suite to provide the data to "Infor Data Fabric" which is an Amazon S3 data lake where the ERP data is stored in JSON files. This data fabric provides a SQL Endpoint to query the data. So similar architecture as in MS fabric with lakehouses. The data can be queried in two ways:- JDBC: using a JDBC driver with API Gateway authentification, see    Link- API: handle API request in a certain order to start a query job, aks its status and get the results, see link:        https://www.youtube.com/watch?v=m4d0awIQ6AgFor TimeXtender, which would be the way to prefer? I could not find the possibility to add a JDBC datasource with API authentification and I am wondering if TimeXtender can handle the process order

532
Thomas Lind
Community Manager
1 month ago

Badge winners

Show all badges
Terms and ConditionsCookie settings