Skip to main content
To homepage To homepage

Interoperability with other Platforms & Tools

Ask questions about external Platforms & Tools and how they fit into a TimeXtender context

  • 15 Topics
  • 51 Replies
15 Topics
richard.ray_ts
Explorer
richard.ray_tsExplorer
asked in Interoperability with other Platforms & Tools
Power BI Gateway

Hi all,As per the article below, it mentions that when hosting the prepare instance on-prem, you need to install the Power BI Gateway.Power BI Premium Endpoint | CommunityDoes anyone have experience of this, and if so, have you installed it on a dedicated server or on the same server as the Ingest or SQL servers?For this scenario, the data will be loaded once daily.Thanks,Richard

514
rory.smith
TimeXtender Xpert
M
Participant
MMMParticipant
asked in Interoperability with other Platforms & Tools
Hybrid Environment (MSSQL on-prem and Snowflake)

Hello,We have currently set up a hybrid environment for our TX deployments.  A DEV environment in on premise MSSQL database and test and prod in Snowflake.  I have already come across situations like hashing where the built in functionality is not usable in Snowflake and if you create a custom field with a hashing algorithm it is not possible to deploy from MSSQL to Snowflake becuase of the different language required to create the hash.  I have also com across this when writing custom scripts.  In those cases so far i have been able to create code that works in both environments. Is there any way to handle this more effeciently when running a hybrid set up like this?  We are trying to reduce unneccessary costs in Snowflake during development hence the hybrid set up.  I have read some things about Instance variables but it would be great if there is some kind of best practice in a set up like this.

212
Christian Hauggaard
Community Manager
B
Visitor
Brede FjaeraVisitor
asked in Interoperability with other Platforms & Tools
Unable to create Microsoft Fabric Storage

Hi, I am trying to set up a new Ingest Instance with Microsoft Fabric Storage. I am following Christian Hauggaard’s guide for Integrating TimeXtender Data Integration with Microsoft Fabric, but i am stuck on step 2. Create Storage for Ingest Instance. (Link: Fabric Lakehouse Ingest Instance storage (Public Preview) | Community)The guide describes using a non-MFA user when authenticating, but i am stuck using my Azure AD user with MFA enabled. When i try to create storage in TimeXtender Data Integration i get the attached error message, and when i check the sign-in logs for my app registration in Azure there is an ‘interrupted’ sign-in attempt with error code 50076 (User needs to perform multi-factor authentication).  Error message detailsIs there any way to resolve this issue with the current MFA-requirement on my user? 

181
rory.smith
TimeXtender Xpert
Dean
Starter
DeanStarter
asked in Interoperability with other Platforms & Tools
SSAS tabular TimeXtender/PowerBI

Hi,I am working with TimeXtender and have an SSAS tabular on-premise on a virtual machine as the endpoint. I want to publish my Power BI dashboard to the Power BI service. However, when I attempt to publish, I receive a message indicating that the connection to the data source is broken. How can I resolve this issue? We do not have Power BI Premium licenses, hence the use of SSAS.Looking forward to your response.Best regards,Dean

414
rory.smith
TimeXtender Xpert
Dean
Starter
DeanStarter
asked in Interoperability with other Platforms & Tools
How can I use tables from TimeXtender Data Integration in TimeXtender Data Quality?

I am currently working with TimeXtender Data Integration and would like to leverage the tables created there within TimeXtender Data Quality. Could someone provide a detailed explanation or step-by-step guide on how to achieve this integration?

351
P
Starter
Christian Hauggaard
Community Manager
Christian HauggaardCommunity Manager
published in Interoperability with other Platforms & Tools
Public Preview - TimeXtender on MS Fabric - Feedback

Many TimeXtender users have started experimenting with TimeXtender Data Integration on Fabric. As this is still in Public Preview, we really appreciate your feedback regarding:bugs/errors missing documentation improvement suggestions new ideasThank you for your engagement. 

391
rory.smith
TimeXtender Xpert
Roy V
Problem Solver
Roy VProblem Solver
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.  

513
Roy V
Problem Solver
D
Starter
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! 

552
D
Starter
Roy V
Problem Solver
Roy VProblem Solver
asked in Interoperability with other Platforms & Tools
Full deployment functionality to Snowflake

HelloAt the moment we are processing our MDW datawarehouse to an Azure SQL Database and then we copy data to Snowflake.We want to change this to Snowflake directly however only when it is possible to fully deploy to Snowflake (transformations included).I know it is hard to give an exact timeline when this becomes available but do I need to think in a couple of months or in a couple of quarters or is this even low priority at the moment?Looking forward to your response,Greetings, Roy 

1392
Roy V
Problem Solver
K
Contributor
KajEmergoContributor
asked in Interoperability with other Platforms & Tools
XMLA endpoint stuck on deploy

Hi, in TX v20 we are trying to configure XMLA endpoints. We were having issues with using the Service Principle so now using Windows authentication. When we test the connection, this works OK. But when trying to deploy the endpoint, it runs for an infinite amount of time without any error message. We have put the settings on XMLA Endpoint to ‘Read Write’ but still no change.Also, the workspace is Premium Capacity so I guess the relevant XMLA Endpoint setting in Power BI is like this, correct?So the ‘Read Write’ setting for Premium Per User is irrelevant?

3839
rogier.helmus
Problem Solver
Roy V
Problem Solver
Roy VProblem Solver
posted in Interoperability with other Platforms & Tools
TimeXtender in combination with Microsoft Fabric

Good afternoon, Great to see the OneLake part of Microsoft Fabric with parquet files. I wonder from who they got the idea :-) Shows TimeXtender made good strategical choices. I do wonder how you guys see MS Fabric compared to TimeXtender.As I see it, it would make sense that in the future you also have the option to deploy and execute your datawarehouse to OneLake (and maybe the ODX as well). What;s TimeXtender vision on MS Fabric ? 

7489
rory.smith
TimeXtender Xpert
C
Starter
cwatkinsStarter
asked in Interoperability with other Platforms & Tools
Using TimeXtender to export to AWS

Good morning, We have a need to export a subset of data from our current Azure data warehouse to an AWS target. Does TimeXtender currently support AWS as a target? If so, could someone point me in the direction of some documentation on how to configure it? Thanks, Chuck

1226
JTreadwell
Employee
G
Starter
glaymonStarter
asked in Interoperability with other Platforms & Tools
Using TX as a source to Dynamics 365

We are currently using TX to stage and merge multiple source systems to create a master list of items, customers, vendors, Open AR. Open AP, etc.  Currently, we are using the Data Export on the Semantic Layer to dump out entity data so that it can then be read in by D365 as delimited text files.  I am wondering if anybody knows if there is a way to direct connect to D365 so that TX serves as a source to a D365 system? Thanks, Greg  Laymon

651
J
Contributor
P
Starter
purnima.ozaStarter
asked in Interoperability with other Platforms & Tools
Can you use temp tables (sql - #tablename) in custom table insert SQL queries? This is for a custom insert table.

I am trying to replicate some code from SQL, and need to create a custom table insert... my SQL query uses a temp table #ELL.  When I try to deploy & execute, it does not understand the temp table.  Can temp tables be used here?  IE. #ELL.. I just need to have it hold some info that later in the query will populate the new custom table in TimeXtender.

1624
Thomas Lind
Community Manager
G
Starter
glaymonStarter
asked in Interoperability with other Platforms & Tools
Seeking Best Approach to Add a Counter to a Table That Resets Based on Another Field

I have a table and I need to have a counter that restarts based on another field on the table. In my case I have a JournalBatchNumber field.  For each new batch, I need to generate a LineNumber restarting with 1 for each record of the same batch. Is this available in TX natively, or do I need to write a post processing script using rownumber ().  Thanks,Greg

852
M
Explorer

Badge winners

Show all badges
Terms and ConditionsCookie settings