TimeXtender Portal Q&A

Hi,Is it currently possible to use an external key storage provider, such as HashiCorp Vault, to manage and import credentials for data source connections configured in the portal?If not, is support for this planned on the product roadmap?Thanks!

Hi all!Since last week I have this problem where if I login on the TimeXtender portal, I get the following error message: What's strange is that when I go back to the login screen and reset my password, it does work and I get access to the portal:  I've tried some obvious things, like trying a different browser, deleting cache and cookies, etc… Also removing and adding myself as a user (via a colleague) didn't seem to fix it. Does anyone know what the issue could be? Thanks!Willem

I have the following problem when I perform the migration between environmentsIn Ingest instancesAfter migrating, I have to remap the metadata, select all the tables again.En Prepare instancesThe mapping table bring the source of developer environment and not  prod And Can I create two data source with the same short name?  

Does anyone know if there’s a way to export all open and closed tickets for an organization? If not, is it possible to easily set up an automated Python process (e.g., by doing web scraping) to save them to an Excel spreadsheet?

How can I sort all my dimension in cube section and below ?

Good day,I am afraid I have lost the MFA on my phone and I can no longer login in the TimeXtender App.Is it possible to have this reset?  Kind regards,René

Hello, Our data source owner team needs to close their Synapses behind the firewall to close the Prisma Clouds alerts.Therefore they are collecting all the IP ranges needed for different access scenarios, like Zscaler IP ranges for getting access from VPN/Zscaler.TimeXtender is the only solution outside Azure resources in their eyes that needs to access the data.So we need to listed those ranges.Do you know where to get these ranges for TXD cloud portal,? Or I was understanding it wrong, it is just the IP that hosts Ingestion server connection?Thank you in advance.

Hello, We have our data warehouse setup on TXD Portal.Our data source is with provider Azure Data Factory - SQL Server and the data loaded in our Ingest instances is in Azure data lake storage. Then the data is processed in our prepare instances also in Azure SQL database.The question is now from the data source we have some columns being encrypted via AES_ENCRYPT pySpark function with 16bit key. Is there a possibility to decrypt the data anywhere from our end in ingest instances or prepare instances. For example to add a customized script somewhere (preferably in pySpark as well using AES_DECRYPT function) ? Otherwise, is there encryption method that can be applied from the data source and by that we can decrypt more easily in TXD in SQL Server?Looking forward to your suggestion/answer. Thank you.

Hello,Strange behavior and tricky to explain but I will do my best.I have a dimension (company) where I have set security on. So I created different roles (by company) and for example the role = Company1 will only see data related to Company1.So I have several roles and some users are allocated to different roles, meaning they are allowed to see data form Company1 and Company2 and they can use that Company dimension to filter.The strange behavior is that those user only see part of the data of Company2.Example is production orders, when they look into the report with company filter they see ± 20 production orders. When I look at the report (and I have no limited security) I see 500 production orders.So I am a bit confused and not sure how to solve it. When I add a user to the Role with no security they can also see everything. I would better understand if they would see nothing of Company2 but they do see limited data.Any idea how to better investigate ?Also it is hard to remove a user

Hi,This week TimeXtender released the Metadata & Logs functionality for TDI. This provides valuable insights, such as reload times, failures, field and table usage, and much more! Just wanted to share how to setup the Metadata & Logs functionality: Step 1: Add metadata collections and data sourceStep 2: Map the “TX-Meta_collection” source to your ODXStep 3: load the data into your ingest layer in TDI. Please note that Meta collections are refreshed once per day. So the first time you enable this feature, the data will become available within 24 hours.  Hope this helps :)Kind regards,Devin

Hello, I have an Acceptance and Production environment and using multiple environments transfer.Now both servers are new and also TX is upgraded (latest version) and the connection between them seems to be gone after this. How do I setup the multiple environment again ? Just by adding an environment or can I get it back from the ‘old’ TimeXtender ? Thanks, Ronny

Dear sir,I need to simulate a TimeXtender configuration version 6766.1.Where can I download the installation software for version 6766.1 ?Cannot find a link.Thanks in advance for looking into this.Regards,Arthur 

Hello,When deploying a table I get error that something is wrong in the script. How do I get into that script to adapt it ? See below screenshot:Thanks in advance,Ronny

hello,I am upgrading to the latest TX and SQL 2022. When I want to deploy my project I get following error: Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.Location: Business Unit 'BU_CRH'.Details:Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.Module: TimeXtender.Sql.Engine.2014System.IO.FileNotFoundException   at TimeXtender.Sql.Engine.SqlEngineBase.InitializeFromSqlServer(SqlServer sqlServer)   at TimeXtender.DataManager.DataSource_Sql.GetSqlEngine(Boolean startTransaction, Boolean singleConnection)   at TimeXtender.DataManager.StepTableStructureRawDeploy.DoAbstractStep(StepSetup stepSetup) Details of the SQL:Microsoft SQL Server 2022 (RTM-CU13-GDR) (KB5040939) - 16.0.41

Hi,I am trying to connect to excel files stored in a Microsoft SharePoint. I have followed the guide Connect to Excel files with Excel Online. I have created a Custom OAuth App for Azure Service Principal Authentication and assigned the role Owner to the created OAuth app. I added the Sharepoint URL under MISC and added Azure tenant, OatuhClientID and OAuthClientSecret.  However, when I press the “Authorize OAuth” I get:  Authentication failed. Empty OAuth file.Details:Authentication failed. Empty OAuth file.Module: timeXtenderSystem.Exception   at TimeXtender.DataManager.ODXCDataSourceHelper.Authorization(ConnectingThread thread, OperationalDataExchange operationalDataExchange, CDataSourceModel cDataSourceModel)   at TimeXtender.DataManager.EditDataSourceCommand.<>c__DisplayClass10_0.<Dialog_OnOAuthRequested>b__0() I'm not sure what I might be overlooking. I've set "Initiate OAuth" to GETANDREFRESH and have tried both CLIENT and CODE for the OAuth grant type. Any tips or a

Hi,Do you have any release notes or something regarding the version update on the TimeXtender REST Connector? It’s quite a jump in version number. We have put quite some work into configuring this and getting it working the way we want, so I’m a little bit reluctant to just press Upgrade on chance. :)  

when we load a table from the data lake it keeps failing after 4 till 5 hours. we have tried different timeout settings but the execution from the datalake to the sql storage keeps failing.See the screenshots and the error message below. In fact I have now 2 tickets open for a timeout issue. for 2 different problems.

Hi,Where can I find a description/explanation of the several types regarding the project variables? 

Dear all,Upon trying to migrate the mdw instance from DEVelopment to PRODuction environment, the following error message appears:Error: Target repository version 5.0.0.0 does not match source repository version 5.0.2.0DEV and PROD environments are both in the same TX desktop app, version 6766.1In the portal, under Data estate > Instances > mdw development instance and mdw production instance, i can’t find any version info.Any suggestions welcome.  

Hello,While migrating from TX 20.10.35.64 to new version 6675.2 with the Portal, we’re running into issues with connecting to a certain data source. I’m getting the same error message in the Portal as i’m getting in SSMS.In our current environment on Azure VM A I’m able to successfully connect to the datasource running on Microsoft SQL Server 2008 R2 (SP2) - 10.50.4042.0 (X64)   Copyright (c) Microsoft Corporation  Express Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)  using the TimeXtender SQL Data Source 16.1.0.1 version. I’m also able to connect through SSMS to this Server.However, using the same settings and credentials on our new environment on Azure VM B using the portal I’m not able to connect, resulting in the error message below. The portal has SQL Data Source version 17+, so not sure if that has something do with it. Using the SqlClient Data Provider Source results in the same error.Meanwhile, I’m also not able to connect to this server with SSMS

Hello team!I need to extract a Excel file from an SFTP server. I successfully created my SFTP datasource :SFTP Connection But I only see the ‘root’ folder on data selection section. When I click preview I can see all my files but I don’t know what to do to get them ! Root  Could you help me on the next step ? Thanks a lot!Christine 

We have moved from on-premise to AZURE a few months ago. Our TX server is on a node in AZURE and so is our DWH.I have observed that jobs that took a few minutes to complete when we were on-premise now takes much longer.I am wondering if there is a way to person a “health-check” on TX? 

Hi Folks, I'm trying to use the Azure AD data source to get information from our Azure AD into TimeXtender. I'm extracting User, Group and GroupMembership information using this data source. So far it's working but i notice that a lot of columns that were found are not filled (NULL). If i do a test with PostMan to the Graph API, i see that the fields are filled in (Department and CompanyName).I’ve also enabled logging, i see the Graph API request being made: I don't see the fields that i want come back in the results: I'm guessing that the schema used to get the data from the API does not contain my field so i want to add them. Normally i would generate the schema files using the ‘Generate Schema Files’ option on the portal and edit those to expand the call to the API. There is an option to specify the location of the schema files, but i'm lacking the ‘Generate Schema Files’ option like we have on other similar data sources:  Is there maybe an option to enable this outside the portal?

Hi team, I am Ignacio, I have worked as a TX developer for 3 years, and now I don't have any projects and want to continue working with TX.Could you help me?Thanks 

Hi I wanted to verify what I am seeing as recent changes to the TimeXtender Portal data source definitions.I distinctly remember being able to switch how a data source was being used to upload data to the ODX whether it was going to use AD).NET or ADF. If I selected ADF then I had to enter the ADF credentials.This seems to have disappeared in recent changes. I was using CDATA REST API connectors, I can no no -longer switch between transfer methods without it seems defining new connections. Can someone confirm this and let me know how I can switch between these transfers without creating new data sources?