Default inSided | Community

Recent activity
Help others
Categories

chauggaardCommunity Manager

Analytics

testing connection

sgdadfbtns

1 year ago

chauggaardCommunity Manager

Administration

1. Portal Sign-In

1 year ago

chauggaardCommunity Manager

Administration

3. Configure User Accounts & Permissions

Configure User Accounts & Permissions

1 year ago

chauggaardCommunity Manager

Administration

2. Create ODX App Server

Create App Server in Azure, or Sandbox

1 year ago

chauggaardCommunity Manager

Administration

6. Schedule Jobs

Configure Execution Server Configure Jobs

1 year ago

chauggaardCommunity Manager

Administration

5. Semantic Model Setup

Create SSL Endpoint Server (PowerBI | AAS | Qlik | Tableau | CSV) Add semantic model & endpoint Adding Tables to Semantic Model

1 year ago

chauggaardCommunity Manager

Administration

4. MDW Setup

Create MDW Storage Server (SQLDB | Snowflake | Synapse | AWS RDS) Add Data Warehouse Instance Create Data Warehouse Storage Map Tables From ODX to MDW

1 year ago

chauggaardCommunity Manager

Administration

3. Add Data

Add data source connection in the Portal Start with Sample Data Add your own data sources Add data source in Desktop Table and Column Selection Add Execution Task to ingest data

1 year ago

chauggaardCommunity Manager

Administration

2. ODX Setup

Create ODX Storage Server Add ODX Instance Install and configure the ODX Service Open inbound firewall so Desktop can reach ODX Service Install TimeXtender Desktop (ideally on a separate, client machine) Create ODX storage in TimeXtender Desktop

1 year ago

chauggaardCommunity Manager

Administration

1. Initial Setup

Sign-In Create ODX App Server (App Server in Azure, or Sandbox) Configure User Accounts & Permissions

1 year ago

JTreadwellCommunity Manager

Data Warehouse

Testing123

2 years ago

inSided SuperAdminNew Participant

SyedKnown Participant

General Q&A

Can I talk to a Support Engineer for troubleshooting?

2 years ago

ignacioNew Participant

Data Warehouse

Create Identity column

Hi all, I need to create an Identity column, How could I create it in TX? Thanks Ignacio

2 years ago

JennyNew Participant

General Q&A

How can I earn community badges?

I’ve noticed some fancy badges below some community profiles. What do I need to do to get these as well and where can I view them all?

2 years ago

tobias.schmockerNew Participant

Data Warehouse

Change Data Type in Cleansing

Hi, Let's assume I am importing from CSV file. The Data is very dirty and somehow I have stings in my int filed "ID" so the filed is interpreted as NVARCHAR(MAX). If I change data type of the field (right click > Edit Field) from string back to integer I receive a runtime error during the execution. What I was expecting was to see was corresponding entries in the _M and _L tables. Is this not part of data cleansing after all? We have this problem all over and could not find a better solution than to build custom views with TRY_CAST etc. where we lose lineage etc. What is the best way to clean up such data (keep valid rows, write errors/warnings on invalid rows)? We are talking 100+ tables so I'm looking for a highly scalable solution here not a one time work around. Thanks and BR, Tobias

2 years ago

sanderudenNew Participant

Jobs & Executions

ODX to Data Warehouse - SqlException - Error code 4815

After trying to import data from a REST source in the ODX I got an SQL Exception with error code 4815. After a bit of Google I ended up on this page, telling me that it had something to do with SQLBulk copy not able to match the columns in source and destination or the value of a column was larger than in the destination allowed (e.g. string with length of 200 -> nvarchar(100)). Because TimeXtender defines the columns it probably didn't have something to do with that. Because the RSD I created didn't have a column size specified, all my string type field allowed 2000 chars. Thinking that none of the string fields were going to be larger, I started changing int to double and after that all the fields to string and later even to text. None of this worked which send me back to start. After properly examining the parquet file I found 1 record that had a text field that exceeded the 2000 char limit. The next time I get this error I will do the following steps: 1. Examine data type of API

2 years ago

dsvartzmanParticipating Frequently

Jobs & Executions

Slow performance ODX transfer

Hi, I'd love to get your thoughts on issue we're dealing in the past few days. We've noticed that transfer time from ODX to DSA is growing rapidly. This as significant impact on total running time of DWH and SLA towards our client Execution log of DSA As you can see. as insert and cleansing tasks remains pretty much the same, transfer time is growing. In terms of volume, data hasn't grown significantly Batch Id 13428 (first) - 46347863 rows Batch Id 13481 (last) 46536187 rows (+0.4%) difference in transfer time is more apparent as you zoom in into the package execution (Gantt chart) Batch Id 13428 vs last batch (13481) There is no inconsistencies in ODX que or ODX service logs found. I've also checked it there is long running transactions (sp_who2) in both TX and DWH server but could find anything out of the ordinary Our setup consists of ODX repository and DWH storage on same Azure Managed Instance. TX application server is (still) on-prem My burning question is: what c

2 years ago

huub.thuijlsNew Participant

General

Datatype Project Variable

Hello,I defined a Project Variable where I casted the output as date,When using the variable in a view TX returns an int.What am I doing wrong?

2 years ago

jon.cattParticipating Frequently

Jobs & Executions

Trigger Data Source transfer tasks from Execution Packages

Would be great if within TX (or via external script) you could trigger Data Source transfer tasks as an initial Step within an Execution Package (or batch), so that once the transfer of new data is complete, the execution package runs the next dependant step? This way, if the transfer task from the data source to the DL takes longer (more data than expected) then the execution package won't run until it completes. There seems to be no method currently to trigger a transfer load within the execution packages - and therefore no way to make the two different scheduling tools (it's really that) align with each other intelligently.

2 years ago

TimeXtender Desktop Q&A

Data Warehouse

40 topics

Semantic Models

18 topics

Jobs & Executions

41 topics

TimeXtender Portal Q&A

General

0 topics

Data Sources Q&A

General

0 topics

REST APIs

0 topics

RSD File Customization

0 topics

SAP

0 topics

Oracle

0 topics

ODBC

0 topics

General Q&A

General

32 topics

Interoperability with other Platforms & Tools

0 topics

Legacy & Upgrades

14 topics

Security & Compliance

0 topics

Infrastructure & Networking

8 topics

Learn & Share

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

Tips, Tricks and Best Practices

5 topics

TimeXtender Tuesdays

29 topics

Partner forum

1 topic

Ask the community

Do you have a question? look no further

General Q&A

2 topics

Product Q&A

2 topics

Welcome

Everything you need to know about this community

Getting started in the community

3 topics

Company announcements

1 topic

Welcome to our success Hub!

Featured topics

The latest & greatest from the community

Events Calendar

The Technology Stack For Customer Success Teams

Need more help?

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded