To homepage To homepage

Home
Community overview
General Q&A

General Q&A

Ask general questions

108 Topics

Recently active

Most replies Most views Newest first

f_keferStarter

asked in General

Continue historization from SCD2 source table

Hi all,our customer has tables that are SCD2 historized with valid_from and valid_to columns and a “version” column, where 1 is the most recent entry, 2 the next older entry and so on.Is there a possibility to load these tables into TimeXtender, preserve the history (make it useable for TimeXtender) and continue historizing in TimeXtender, so that they can turn off the historization in their source table?

2 days ago

Roy VContributor

asked in Legacy & Upgrades

Custom Data not migrated when using the migration tool

Good morningWe used the migration tool to upgrade from 20.10 to the saas version.In the comparison of records in the MDW we miss out on the custom data which we use to insert -1 and -2 records.Old situation: After migration: This is very inconvenient as this requires adding all custom data once more.

11 days ago

avanrijnParticipant

asked in General

Query on local TX repository (V20.10.45)

Dear Sir,I am looking for a sql query on my local sql repository to create a list of all my datasources in my projects.I am using v20.10.45.Thanks in advance.Regards,Arthur

18 days ago

RobertUParticipant

asked in General

Working with multiple environments

I would like to know what the best way of working is if you have multiple environments (DEV, TST, PRD) with the new version. In the old version you had to open a different project repository that you could set a different color, so you were always aware on what you had open.In the new version all the environments are available in the desktop and a mistake is very easily made on what environment you open. Names are also shared between environments so you never know what DSA you have open.Love to hear some comments on how other customers are working.

18 days ago

Roy VContributor

asked in Interoperability with other Platforms & Tools

Tables based on incremental table not deployable to snowflake

Good morning,We upgraded to 6675 version and are now testing a deployment to snowflake.The tables based on full load mappings deploy well (with our without simple mode)When deploying tables who are based on an incremental ODX tabel we recieve an error on the syntax of the usp clean procedure TimeXtender wants to create in Snowflake.The script TimeXtender creates starts with:CREATE PROCEDURE "HIST_ETL"."usp_ReaturnTM_DimRentableUnitCommercial_Clean" :DWBATCHNR INTWITH RECOMPILESnowflake doesn’t expect the : and returns:Syntax error: unexpected ':'. (line 2)Is this a known issue and if not, I hope it can be added to the wishlist with TimeXtender features that need to be made available against Snowflake storage.

22 days ago

Roy VContributor

asked in Legacy & Upgrades

Access to path AuthenticationSettings.txt denied

I did the upgrade to 6675.I can login to the new version but my colleagues get the error below.We are all admins on the vm’s.

24 days ago

dash7Starter

asked in Interoperability with other Platforms & Tools

Timextender & Fabric Mirrored database

Hello!I am using Timextender to get MS Dynamics data to an Azure SQL DB.I would now like to use the Fabric Mirrored Database function (https://learn.microsoft.com/en-us/fabric/database/mirrored-database/overview) to integrate the tables from the Azure SQL DB in a Fabric Warehouse. However I get this error upon execution in Timextender:Cannot truncate table 'dbo.D_Date' because it is published for replication or enabled for Change Data Capture. Is there a way around this or will the Fabric DB mirroring function not work with the Timextender/Azure-DWH tables?Thanks for any advice!

1 month ago

avanrijnParticipant

asked in Legacy & Upgrades

TimeXtender DEV en PROD DWH instances within TX Standard license package

Dear Sir,I am working with a client to migrate TX to latest version (from legacy to latest).Now, they want to migrate to a TX Standard license, wich will give you 4 Datawarehouse Instances.Question: Is is possible in this scenario to run 4 Datawarehouse instances in Development and 4 Datawarehouse instances in Production in the latest TX version. All together 8 dwh instances. Is that allowed within the TX Standard license package ?Or do we have to configure 2 dwh instances in Development and 2 dwh in Production to meet the TX Standard license requirements (4 Datawarehouse Instances) ?Hope this makes any sense 😆Thank you in advance for looking into this. Regards,Arthur

1 month ago

avanrijnParticipant

asked in Legacy & Upgrades

Data Product Instances

Dear Sir,I am working with a client to migrate TX to latest version (from legacy to latest).Now, they have a lot of Data Exports (CSV files) in their projects, about 50 all together.Client wants to migrate to a TX Standard License, wich will give you 18 Data Product Instances.Question: Does a Data Export (CSV files) count as a Data Product Instance ?Does my client has to move to a TX Premium license ?Or is there an alternative for this.Many thanx for looking into this 😀. Regards,Arthur

1 month ago

rluytenStarter

asked in Legacy & Upgrades

TX upgrade from 18.6.8.64

Hello,We are still running on TX 18.6.8.64 version and SQL server 2014.Now they want us to upgrade to SQL server 2022 so it makes sense to also upgrade TX. Questions:can I upgrade from 18.6.8.64 to latest TX version in 1 go ? is SQL server 2022 working fine with latest TX version ?Thanks,Ronny

1 month ago

ErwinsExplorer

asked in Legacy & Upgrades

Multiple Environments Deploy error

When deploying the project in the PROD environment (through multiple environment transfer) we get the following error.: Source: System.Memory Type: System.IO.FileLoadException Could not load file or assembly 'System.Runtime.CompilerServices.Unsafe, Version=4.0.4.1, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) at System.MemoryExtensions.AsSpan(String text) at Microsoft.Data.LocalDBAPI.GetLocalDbInstanceNameFromServerName(String serverName) at Microsoft.Data.SqlClient.SqlConnectionString..ctor(String connectionString) at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) at Microsoft.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) at Micros

2 months ago

peter.jensenTimeXtender Xpert

asked in General

Repository cleanup

We're experiencing projects to open very slowly using TX 20.10.38 (we're above version 10000 of the project) Is there an easy way to remove old versions of a project ? We are using multi environment with global databases, and don't want to go through the export, create new repo DB and import hustle.We're also trying to delete the logs, but deleting them from within TX seems to take forever.

2 months ago

ekw9Contributor

asked in Legacy & Upgrades

Windows Version Compatibility

Looked for this in the documentation, but couldn’t find it - is TimeXtender 20.10.X compatible with Windows Server 2022?

2 months ago

kerry_bespokeContributor

asked in Legacy & Upgrades

Fail External Tasks if Step Fails

I have setup an Execution Package and am running a number of Perspectives in the order they need to build in the project. I then call 2 External Steps, which are Execution Packages in other TX Projects in the same environment. I am having an issue where when a step fails in the project, the build then continues onto the External steps whereas I would like the entire package to fail. I thought this would be accomplished by selecting the FailPackage action on Failure Handling but it is not working. Do I need to set this up a different way to get this to work?(I have hidden sensitive data in my screenshot)

2 months ago

avanrijnParticipant

asked in Legacy & Upgrades

TX Upgrade from 20.10.45 to version 6521.1

Dear Sir,I am assisting one of our clients with a TimeXtender upgrade from 20.10.45 to version 6521.1.I gave them a small demo today and showed them the Migration Tool to support the upgrade proces.Then the client asked me if the Migration Tool is capable to Migrate over a 100 TX-projects all at the same time…. Yes, you are reading this correctly, our client has over a 100 TimeXtender projects.So, I am looking for a way to Administrate all of these projects in the Environments Page (see picture) and please advice how to speed up the TX Upgrade proces for our client. If we can’t automate the migration-proces it’s going to be a lot of work. I hope you can shine a light on this one, because I am still in the dark.Thanx in advance.Regards from Amsterdam,Arthur

3 months ago

gediminas.juskenasContributor

asked in Infrastructure & Networking

Configuring multiple environments to change deployment path

Hello, i am kind of stuck and hoping someone could give me an idea what am i missing to configure multiple environment setup that i have right now. I have 2 machines (call them A and B machines). A machine runs DEV and TEST environments of TimeXtender, B machine runs PROD environment. Current setup is as follows:Deployment path: DEV → TEST, then TEST → PRODEnvironment settings:This setup works, but sometimes i need to be able to deploy changes from DEV to PROD, bypassing TEST environment. My desired deployment paths would be: DEV → TEST and DEV → PROD. Since DEV and TEST environments are on the same virtual machine A and already can connect to machine B, i recognize that i would not need to change any firewall settings.As i configure environments my idea for steps is:B machine (PROD environment) - do nothing; A machine (TEST environment) - remove PROD environment, do not change anything else; A machine (DEV environment) - add PROD environment with Local port 10026 and Remote port 10021

3 months ago

MarcContributor

asked in Security & Compliance

Access via SSO/MFA

Good Day All,We have received a question with regards to SSO/MFA. Is it possible to utilize SSO or MFA in order to access TX to increase the security levels? If not, are there any other means in order to increase the security levels? Appreciate your response in here. Regards, Marc

3 months ago

SBRajaVisitor

asked in General

Acrobat reader pro

Hi, Is Acrobat Reader a pre-requisite for ETL Agile scheduler to work? We have a client that has uninstalled Acrobat Reader Pro and now the Excel Macros no longer work.The Acrobat Reader was uninstalled on a client PC/laptop.Thanks & RegardsShahid

4 months ago

SBRajaVisitor

asked in Security & Compliance

Database transport encryption

Hi, One of our clients are looking to implement SQL Server connection encryption using the SQL Server Network Configuration\Protocols for MSSQL Server and setting this to 'Force Encryption' using an SSL certificate.This would be on the ETL DB server.Is this supported? The ETL DB is accessed by ETL Agile, Targit and SSRS. Best RegardsShahid Raja

4 months ago

VictorParticipant

asked in General

Column/field description repository

Hello,TimeXtender 20.10.40.64.In one of our projects we are adding descriptions to every column in a table and we want to be able to get this data querying the database.However, we can’t find a good place in the repository where the description is stored on a column level and how to effectively exctract this data. Looking at the [TxObjectDescriptions] table in the repository there is a column called Description that is a long string. This string includes the description we added to the field, however it also has alot of other data. On top of this, the string seems to have different structures from case to case and I can’t find a good way to always get the value we need.Does anyone have a good way to get this data or knows if there is data saved in another place in a better format?Thank you,Victor

5 months ago

KajEmergoContributor

asked in Infrastructure & Networking

Access to repository new TX release

In the v20 release of TimeXtender, developers are able to access their ‘own’ data in the project repository db. By querying this manually or using the TX Dictionary project, you are able to gain a lot of valuable insights on your DWH implementation. I see that there already is an idea for implementing the TX Dictionary functionality in the new release. Is it likely that this will be implemented? If not, this could very well be a showstopper for migrating to the new release in my opinion. Enabling this through the TX API will probably be a lot of work for TX developers but this also limits flexibility. What other options are available for accessing our cloud repository? Would love to hear your opinion on this.

5 months ago

EvidaXremParticipant

asked in Legacy & Upgrades

SQL Server 2022 Compatibility (Source databases and TX Databases incl. Semantic Layer DB) [legacy version]

Any news on SQL Server 2022 Compatibility?Expected release date?

5 months ago

ekw9Contributor

asked in Legacy & Upgrades

20.10.X Support for SQL 2022

Hi all,Just creating this as a follow up to the thread here. We are currently using TimeXtender 20.10.X, and our infrastructure team is preparing to upgrade to SQL Server 2022. We need to know as a matter of some urgency whether or not this version of TimeXtender is compatible with the most recent version of SQL Server!

5 months ago

aftabpContributor

asked in General

TimeXtender Server Service could not start

We are in a process of moving from on-prem to AZUREWhy do i get this error? How do i solve it?The user svc_timextender is local admin and its alreay running ODX. Why cant i start it for TiimeXtender Server Service?

6 months ago

robert.kangasVisitor

asked in General

TimeXtender UI is intermittently slow

Hello there, we’ve been experiencing intermittent slowness in the TimeXtender UI within the past few weeks. Even doing simple things like right clicking on a execution package to view the logs, trying to see the status of an ODX transfer job, etc. will sometimes cause the UI to feel like it’s just not responding (no lotus status UI) for 30 seconds to minutes.This isn’t something that happens all the time and we haven't been able to nail down a root cause. Our VM where the UI is running is rarely over 30% CPU usage and we usually have over 80% memory free. Same goes for the VM that the ODX is running on. How do you even begin to troubleshoot this when the UI is slow to respond? The TimeXtender UI is on version 20.10.38.64. The TimeXtender ODX server is on version 20.10.37Thanks!

6 months ago

Page 1 / 5

Badge winners

Roy Vhas earned the badge Certified Solutions Architect
ignaciohas earned the badge ODX Expert
danielhas earned the badge TimeXtender Xpert
wouter.goslingahas earned the badge Innovator
Bernarddbhas earned the badge ODX Expert

Show all badges

Terms and Conditions Cookie settings

Sign up

Already have an account? Login

Login with SSO

SSO login

Username *

E-mail address *

Full Name

(Private)

Only you and moderators can see this information

TX Partner / Customer *

Company

(Private)

Only you and moderators can see this information

Password *

I accept the terms & conditions

loginBox.register.email_repeat

Login to the community

No account yet? Create an account

Login with SSO

SSO login

Username or Email

Password

Remember me

Forgot password?

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.