Community

Recently active
Help others
Categories

How to Set Network Connection Timeout Value for ADO.NET Oracle Data Connection

HiOver the weekend one on our ODX jobs failed with the following error; Executing table [PRODDTA].[F0101]:failed with error:Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-50000: Connection request timed out at OracleInternal.ConnectionPool.PoolManager`3.Get(ConnectionString csWithDiffOrNewPassw, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch, Boolean bAsync) at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassw, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch, Boolean bAsync) at OracleInternal.ConnectionPool.OracleConnectionDispenser`3.Get(ConnectionString cs, PM conPM, ConnectionString pmCS, OracleOpaqueString securedPassw, OracleOpaqueString securedProxyPassw, OracleConnection connRefForCriteria, Boolean bAsync) at Oracle.ManagedDataAccess.Client.OracleConnectionInternal.OpenInternal(Boolean bAsync) at Oracl

14 hours ago

kerry_bespokeContributor

Ingest

Sensitive Data Security within TX

Good Day,We have a client that is on V20 that would like to incorporate some Sensitive Data within their TX environment that some of the TX Developers should not have access to. As far as I am aware, if you have access to the TX Repository then the developers can open all projects.How would I handle the solution of the Sensitive Data in TX?Kerry

242

1 day ago

Christian HauggaardCommunity Manager

Data Sources

Extract Data from SharePoint Lists

PrerequisitesCreate an Azure App RegistrationThe App Registration should use the Microsoft Graph API with the following permissions:Finding the List IDUse Postman to find the Site ID. Use the Site ID to find the List ID. You can find these by using Postman and by looking at the Graph API collection Graph Fork. You can use the app to connect to this and locate the SharePoint folder under Application. In there you have two requests, https://graph.microsoft.com/v1.0/sites and https://graph.microsoft.com/v1.0/sites/{{SiteID}}/lists. Use sites to find the site ID and use the SiteID to find the List ID. You can also find the ListID by navigating to the SharePoint list and then clicking List settings and then copying the ListID from the URL Use the TimeXtender REST data source connectionConnection SettingsUse the following Base URL (where {{SiteID}} is the Site ID found in Postman):https://graph.microsoft.com/v1.0/sites/{{SiteID}}/listsEndpointsCreate the endpoint using the following path (w

1484

1 day ago

Thomas LindCommunity Manager

Business Unit

Share a data source setup using the Import/Export feature

At times you may want to share a specific data source setup with someone else.Here is how this can be done.Create the project with the data source Export the project and note the version of the project Import the projectCreate the project with the data sourceLets say you have a REST data source made with the Enhanced TX REST data source provider and it needs to be shared with someone without access the the machine where TX is installed.First you note the specific data source, or sources if additional ones are necessary. Then you use the save as option.When you use this method you create a new project with the same setup the only difference is the name of it.After creating the new project there still are some things to do before you are ready to export this.First you delete the unnecessary parts such as Semantic layers and Data warehouses.Delete all execution packages, so only the default one remains.Finally you delete all the unneeded data sources and any custom tables added to your BU

130

5 days ago

Christian HauggaardCommunity Manager

Deliver

Filtering on endpoint name using deliver instance variables

Use deliver instance endpoint name variable, in combination with data selection rules, to perform different data selections for different endpoints in the same deliver instance. This way, each department can get their own endpoint with a subset of data relevant to their division. This can help improve load performance, report performance and help manage costs by keeping individual models smaller. This also helps avoid creating multiple deliver instances for different departments.How to filter use data selection rules for specific endpointsCreate a Deliver instance with multiple endpoints Close all instances in TimeXtender Data Integration and then open the Deliver instance in TimeXtender Data Integration and click Tools > Instance Variables. Then click Add, and add an instance variable of type Destination Scope, setting the Value Filter to Endpoint and setting the Value to Name. Then click OK and close. Right-click the table you would like to create filter on and select Add Data S

515

6 days ago

Thomas LindCommunity Manager

Data Sources

Connect to Fixer IO with the TimeXtender REST data sourceTutorial

There is a free currency API called Fixer IO https://fixer.io/You can connect to it by generating an API key and generating an account is free.The documentation can be found here https://fixer.io/documentationThis guide is for learning how to set up a REST data source, how to generate dynamic values from SQL queries, and how to use additional parameters for your calls to get different info out of it.ContentContent Set up Fixer IO account Setup Common settings Setup Request limits Setup endpoints Latest - Gives today's rates and shows how to apply parameters Yesterday - Gives historical rates based on a specific date. Uses SQL query to dynamically apply yesterday as the date Timeseries - Gives historical rates based on a start and end date. Uses SQL query to generate dynamic dates Custom range endpoint - Use a function in DW Instance to generate a range of dates to loop through Use XLS to do table flattening Use Unpivot on your XLST Change the content of the rates to show decimal

4821

7 days ago

sten.lommeParticipant

General

How to move my current TX community account to new mail address?

Hi. Is it possible to move my current community account to my new e-mail address? I could not find anywhere to update this on my profile.

385

8 days ago

Søren SørensenContributor

Prepare

Max value of multiple columns in Lakehouse

I’m looking for a TimeXtender Fabric Lakehouse (pyspark.sql) expert 😀I’ve got a SQL transformation that selects the maximum value of 10 columns:(select max(val) from (values ([Column_1]), ([Column_2]), ..., ([Column_10])) as [Values](val))How do I achieve this in a Prepare Lakehouse custom transformation?I could build the mother/father of all massive case statements, but I’d prefer something simpler and more elegant … if possible!?

211

8 days ago

juriaan.hensbroekContributor

REST APIs

TX Rest Dynamic value Endpoint query

I'm using dynamic values function in the TX REST connector 9.1.0.0. I use id's from another endpoint to loop through in my second endpoint path. This works well when I use “From Endpoint Table” but now I want to add a filter to only get the id's with a flag “hasresponse=true”.I've read the page but I still get an error with my Endpoint query. “No such table” the error message says. I've tried several things like adding a schema. But all with the same response. Is there something wrong with my syntax?Error:

18912

12 days ago

Thomas HjermitslevCommunity Manager

TimeXtender Data Integration 7047.1

Today, we released a minor version of TimeXtender Data Integration (v. 7047.1) with the changes listed below. We recommend that you upgrade if you’re affected by any of the issues fixed.FixedFixed an issue for Prepare instances using Snowflake storage where Snowflake would throw an error on deployment when using differential deployment. Deployment would fail on Prepare instances using Snowflake or Data Fabric storage if custom data was present. Custom data is only supported on SQL storage, so this issue would appear when changing storage from a SQL Server storage with custom data. It’s now possible to delete custom data when it is not supported by the storage type. For Prepare instances, fixed an issue where the ‘DW_SourceCode’ field was missing in the primary key check. For Deliver instances, updated the logic for the PowerBI endpoint connection string, so you can now use the Gateway in the PowerBI portal.

880

12 days ago

Paul BridgeContributor

Ingest

How to Set Network Connection Timeout Value for ADO.NET Oracle Data Connection

14 hours ago

Søren SørensenContributor

Prepare

Max value of multiple columns in Lakehouse

211

8 days ago

juriaan.hensbroekContributor

REST APIs

TX Rest Dynamic value Endpoint query

18912

12 days ago

Paul McLeod Bespoke AnalyticsTimeXtender Xpert

Prepare

Create Sandbox Ingest in V21

I have a client that wants to explore a significant rework of their Prepare instance. They want to duplicate their existing Prepare instance in Dev to create a sandbox instance. Is there a recommended approach to achieve this? They are using version 6898.1

212

12 days ago

peter.jensenTimeXtender Xpert

SAP

SAP datasphere connection

Hi,what is the best (performing) way to extract data from SAP datasphere?I read about an API connection (OData), but is this the ‘optimal’ way to do this ?https://community.sap.com/t5/technology-q-a/how-to-export-data-from-sap-datasphere-or-its-database-sap-hana-cloud-to/qaq-p/13708728https://help.sap.com/docs/SAP_DATASPHERE/43509d67b8b84e66a30851e832f66911/7a453609c8694b029493e7d87e0de60a.htmlBest Regards,Peter

290

3 months ago

aftabpProblem Solver

Ingest

Nested RSD file for XML

This is a follow-up of Using XML to ingest data, that i have managed to solve.I need some help with creating a nested statement. The first rsd which lists out all the IDs is this:<api:script xmlns:api="http://apiscript.com/ns?v1" xmlns:xs="http://www.w3.org/2001/XMLSchema">  <api:info title="contract" desc="Generated schema file." xmlns:other="http://apiscript.com/ns?v1"> <attr name="contractid" xs:type="string" readonly="false" other:xPath="/Envelope/Body/contracts/contract@contractid" /> <attr name="description" xs:type="string" readonly="false" other:xPath="/Envelope/Body/contracts/contract@description" /> </api:info> <api:set attr="DataModel" value="RELATIONAL" /> <api:set attr="URI" value="https://my.soap.endpoint/service.asmx?WSDL" /> <api:set attr="PushAttributes" value="true" /> <api:s

1228

6 months ago

annfossParticipant

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

1347

7 months ago

TimeXtender Desktop Q&A

Ask questions and find answers about TimeXtender Data Integration and TimeXtender Classic desktop applications

Ingest

298 topics

Prepare

232 topics

Deliver

71 topics

Jobs & Executions

132 topics

TimeXtender Portal Q&A

Ask questions and find answers about the TimeXtender Portal

General

45 topics

Data Sources Q&A

Ask questions of about setting up data sources

General

59 topics

REST APIs

48 topics

RSD File Customization

25 topics

SAP

11 topics

Oracle

9 topics

ODBC

8 topics

General Q&A

Ask general questions

General

47 topics

Interoperability with other Platforms & Tools

13 topics

Legacy & Upgrades

70 topics

Security & Compliance

6 topics

Infrastructure & Networking

10 topics

XPilot

0 topics

Learn & Share

Share tips and best practices, show what you've created and inspire others

Success Stories

6 topics

Tips, Tricks and Best Practices

18 topics

TimeXtender Tuesdays

30 topics

Community Announcements

Everything you need to know about this community

Getting started in the community

8 topics

Company Announcements

18 topics

TimeXtender Orchestration and Data Quality Q&A

TimeXtender Orchestration and Data Quality

General

16 topics

Orchestration

2 topics

Data Quality

0 topics

TimeXtender Data Enrichment Q&A

TimeXtender Data Enrichment

General

0 topics

Leaderboard

Show full leaderboard

Awarded Badges widget

devin.tiemenshas earned the badge TimeXtender Trainer
bas.hopstakenhas earned the badge TimeXtender Trainer
Sigrun Inga Olafsdottirhas earned the badge TimeXtender Trainer
danielhas earned the badge TimeXtender Trainer
philippus.asefawhas earned the badge TimeXtender Trainer

Show all badges

Community Categories

Leaderboard

Awarded Badges widget

Need more help?

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded