General Q&A

It's really annoying that the window can't be maximized or enlarged.I've asked the support for a long time, unfortunately nothing happened. It shouldn't be a big deal to change that?!

I am working on a environment with TimExtender and Dynamics 365 for Operation.  First I must clear out ClientSecret and ClientAuthentication key before I can Authorize to d365.  After that i put in those keys and the session is started.  After a while the sessions is closed and I have to Authenticate myself all over again to be able to extract data form d365.   exept from logfiles> 2020-08-13T09.00.37.158+02:00 0 [Connection: 158] Executed connect: Error: AADSTS7000215: Invalid client secret is provided.Trace ID: e4747361-a17c-448d-a5b9-b2d2fadbf800Correlation ID: 3ab329da-2059-4716-8a08-7f20e7835759Timestamp: 2020-08-13 07:00:37Z. 2020-08-13T09.00.37.160+02:00 0 AADSTS7000215: Invalid client secret is provided.Trace ID: e4747361-a17c-448d-a5b9-b2d2fadbf800Correlation ID: 3ab329da-2059-4716-8a08-7f20e7835759Timestamp: 2020-08-13 07:00:37Z. ffo190j.xaat ffo190j.nna.C(ra , String )at ffo190j.nna.q(String , String , String , Boolean , Boolean , Boolean , BmB , BmB , BmB )at ffo190j.nnI

hi since this morning I get the message displayed in title. It is an Azure environment, TimeXtender was working on Friday, nothing changed on the license key... Any idea where to find/how to solve this issue??? thanks in advance Mrt

Hello, Which settings are needed in order to get Google Mail send success and failure emails in TimeXtender?  I tried it with  Servername: smtp.gmail.com Port: 25/465/587 Enable SSL/TLS: Checked Allow invalid certificates: Checked From Email: my.name@gmail.com User name: my.name@gmail.com Password: <my gmail password> To Email: another.email@gmail.com   I get different failure responses:  25: 5.7.0 Authentification required 465: Syntax error, command not recognized 587: 5.7.0 Authentification required   Without SSL/TLS I get: A secure connection is required for the smtp server or the client is not authentificated. Server response was: 5.7.0 Must issue a STARTTLS command first.   The responses are translated from german to english so please don't take them literally.   What are the corrected settings here? Is it something in my google account?  

We have multiple TimeXtender projects that use the same databases for their ODX/DSA/MDWs. What is the best way to use tables from one project in another one of the other projects? "Add External SQL Connection" seems to be an option, should this still be used if the table we want to connect to is in the same database?

I have a separate Test and Production environment. Currently each environment has its own ODX database. But some cloud API source systems charge euros for loading records through an API connection. I’m therefor checking how I can limit the data transaction on the source systems. Also we only use production data in Pest and Production. Since we use Azure I don't want to load all the production data twice. One way is to use 1 shared ODX for both Test and Production. Then I only have to load the source data ones. I can think of the following options: 1. Use the ODX server I've tested the ODX server but I can't use historic tables and incremental loads don't work on most API connections. I also encountered limitations on a firebird SQL data source. So the ODX server doesn't seem like a workable solution 2. Use an external ODX business unit A external business unit works. But how can I use a single external ODX for both Test and Production as these environments run on different project repo

How can I execute a stored procedure once a load of a table is done. I know it should be possible. I just don't know where I should configure it  

Is there way to adjust the window widh according to the screen size. It is not getting resize.

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

  Due to cost of servers, it would be beneficial to have both a developer and a production on the same server. Is this possible right now? The manual doesn't explicitly mention this. If it is possible to run both environments on the same server, do they need different SQL server instances or can they use the same instance?     

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.

Hi , We have a need to identify the objects modified in last few days to deploy as part of differential deployment to various environments. To do this, we were looking at DiscoveryHub metadata database, which contains various tables like DataTables, DataColumns, Transformations etc.  However, to identify the delta, we have two columns ValidFrom and ValidTo which are stored as integers. We need a way to identify the data, either by converting these to dates or based on a range of dates. Please help

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

I'm currently migrating an Azure MI solution to ADLS Gen2 and Synapse Analytics. The migration includes remapping all DSA table ... instead of using an old ODX, DSA will now use an ADLS Gen2 on ODX Server. Mapping tables bring all data source fields across ... it would be nice to have the usual option to only synchronize existing fields as it's a lot of fields to delete when getting the entire data source table.

This may sound a little silly, but I can't quite figure out how to create a script from the MDX Below: WithMember [Measures].[CustCount] AsCount(Filter(Existing {[Sell-to Customer].[Customer].Members},([Measures].[Sales Amount] >0)) * {[Measures].[Sales Amount]}, EXCLUDEEMPTY)SELECT{([Measures].[CustCount])} On Columns,{[Sell-to Customer].[by Country by City].[Country].Members} On RowsFrom[Sales]   It should be simple, but i'm missing something! Any assistance would be helpful regards Chris  

Hi ,  our DH setup consists of multi-layered datawarehouse whereas BI client (tableau ) only interfaces the upper tier: MDW DWH. Having semantic layer for each dashboards (we have quite a few), we would like to move out of the single core TX project with multiple semantic layers to a project for each dashboard (semantic layer).  By doing so, we can make sure that each developer works on his own project without "stepping on each other toes" (I'm aware of collabaration features of TX) and keeping our core project unharmed.  So, the challenge is how to reuse objects created in the core project (preferably VIEW to reduce space/redundencies) in entire new project (same server/database) My approach was creating a new project, add MDW datawarehouse and then utilize External SQL Connection to connect to the same DWH (transfer type connection). I've also created a seperate database schema with valid behaivor.  The problem we ran in was that designated table was the same as similar table in the

Hello, I found a bug in TimeXtender Discovery Hub: When using both the features "Use hard deletes" and "Keep field values up-to-date", certain lines are not deleted, although they disappear in the source table. The following code gets generated to handle the delete process: DELETE V FROM [dbo].[f_data] V WHERE NOT EXISTS ( SELECT TOP 1 1 FROM [dbo].[f_data_PK] P WHERE P.[id] = V.[id] ) AND NOT EXISTS ( SELECT TOP 1 1 FROM [dbo].[f_data_R] R WHERE R.[id] = V.[id] ) This works correctly without the "Keep field-values up-to-date" feature. All rows that are not in the _PK table and that are not in the _R table get deleted. But there are rows that get updated by the "Keep field-values up-to-date" and land in the _R table, although they are not in the source table. This is why they  don't get deleted.

When setting up the global database for the DWH, I get this error: "Databricks direct write requires SQL Server Authentication" However, my environment properties  are straightforward and I can't find anything "databricks" related in the settings. It's a recent (2019) version. Anyone knows what this error could allude to?

I have used the data export tool to export to .csv files. However I can not do it straight from the Business Unit. Is that a feature that can be added? Or maybe not included in client license. The client wants a few tables from source to be transfered to Azure Data Lake as a csv file and do some tranformation there.

what is the right scenario for using single quotes to wrap project variables?    Let's say i have a data constraint added to a field and i am using a dynamic project variable like, so in this scenario, i am comparing a data to another date, and i have the variable encased in single quotes. I always assumed the single quotes was how Discovery Hub "renders" the underlying variable, but i recently found that my assumption was untrue.  is the single quotes only to be used when evaluating a character string? or are there some rules to apply wrapping in single quotes.   Note: the variable above is a dynamic -> select max({datefield}) from {table} statement, under the covers. 

We are providing clients with a preconfigured data warehouse for an ERP system.  We will continue to make enhancements and improvements.The client will eventually add additional fields and user defined fields for their own needs.What's the easiest way to merge in our improvements to the changes they have already made to an older version?

I have been able to create a project variable containing the filepath from a text-file data source, and pass that forward to a SSIS-package. But I have not been able to locate the Backup-folder attribute. Any hints on where I should look for this?

Hi, to configure the multiple environment setup I used the PDF (https://support.timextender.com/hc/en-us/articles/360001136526-How-to-configure-Multiple-Environments) , and everything works well when all the firewalls are turned off. We have opened port 10001 and 5001, but when the firewall is turned on, my DEV environment can't connect with the Production environment. My setup now is a Development server and a Production server. When I want to connect from Development to Production, I see the servers negotiating on port 10001 and 5001. But after that, they continue to work with a port in the 64xxx range (examples: 64135,64177,64281 etc) e.g. a random port. My firewall won't except this, and I would like to know if it is possible to work with a standard range / port so we can configure our firewall accordingly. Kind regards, Rogier

Hi guys,   Can someone elaborate the different options of table trunctation? I can't really find it in the help or e-learning.    We have set up an incremental load on a large table in the ODX, initially in simple mode. We found that the data after deployment & execution exists in the valid table and in the raw table, occupying twice the available storage of the original table size.    We then disabled simple mode and checked the truncate raw table before transfer. I now still see some records (not all of them) in the raw table. I guess I'll have to check "Empty raw table after data cleansing" to completely emtpy the raw table after reloading, but I can't really grasp the difference between these options.  

Hi,  In my scenario, i rely on a stored-procedure in the source (external) database to create the table which will be used in TX. The stored-procedure might have various table/view/functions dependencies.  Is it possible to import stored procedure/scalar functions into ODX layer?  I know it's possible to recreate (internal) stored-procedure, however I have no access to the underline script in the stored-procedure Kind regards. Dror