Solved

Our client has a question about a historical table in TimeXtender. They would like to know if they can make a onetime update from SSMS to populate historical records. More details on the scenario below. Scenario: Table in question is in MDW An ID merge has been done to collapse users that have created multiple accounts into on true account. Logic is done in DSA and flows to MDW. The new merged id was inserted as a new field in the MDW table, the old id was renamed. New merged id field is null for historical records where old id is populated. This makes historical queries fail. Question: Can they run a one time stored procedure in SSMS to fill in the historical records to the new merged id field? What are the potential drawbacks of this solution?

Hello everyone, I hope someone can help me with this. I am working on getting Azure AD Groups via the Graph API and then retrieving the members through a nested API call. I saw a post concerning a nested REST API call together with pagination in which one of the commenters (Gijs) had the exact same API which I am also using (commented by Gijs): https://support.timextender.com/rsd-file-customization-96/using-a-nested-rest-api-in-combination-with-paging-858 However, the suggestion didn't work for my use-case as it only ‘expanded’ the nested values, but didn't paginate. I only got the members of the first 100 groups. I used the RSD-file from the commenter Gijs with the addition of two points: two additional rows to enable pagination; [memberout.userPrincipalName| allownull()] instead of [memberout.userPrincipalName] as I was getting a [500] error with this specific attribute. I've made them bold in the code down below. Would someone be able to give me some pointers to what I'm missing in

Hi, I am trying to parse a response using the REST connector from an API which returns a JSONROWS-format where the first row contains the name of the columns, while the following rows contain the values. The response is on the form: { "response":[ [ {"name":"test1"}, {"name":"test2"} ], [ 1, 2 ], [ 3, 4 ], [ 5, 6 ] ]} I have tried several different xPath-configurations. The following gives the correct columns, but returns zero rows:xPath: column:/response;columnname:/response.name;row:/response I was hoping that at least this would have parsed all the values as strings with the first row containing the {“name”:”testN”} in the corresponding columns. How do I work with this response?

Hi community, I am trying to work with the LinkedIn API to retrieve details about UGC posts (i.e. engagements, clicks, etc.). This information is not part of the LinkedIn Marketing Solutions CDATA connector, so I am using the CDATA provider for REST 2022. I first made a call to the posts API to ‘Find Posts by Account’: Posts API - LinkedIn | Microsoft Learn. After that I need to pass each Post ID into the Organizational Entity Share Statistics API to ‘Retrieve Statistics for Specific UGC Posts’: Organization Share Statistics - LinkedIn | Microsoft Learn. The problem I am facing is that the Posts API returns two types of posts (which cannot be filtered in the API): shares and UcgPosts. Each of those types of posts needs a different URL format in the ‘Organizational Share Statistics’ API. So, I need a way to only pass one type of post into the second API. UCG posts are posts where the ID starts with 'urn:li:ugcPost:' The file RSD 1.txt works, until the first ID from the Posts API is a Uc

I’m testing out the new version of TimeXtender. I’ve downloaded the newest version of SQL Server that was suggested in the training material. I’ve created ODX and MDW instance, when I try to deploy a table in the MDW instance I get the following error: Not supported in current SQL version Version: Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64) Oct 8 2022 05:58:25 Copyright (C) 2022 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Enterprise 10.0 <X64> (Build 22621: ) (Hypervisor)

I’m struggling with the TimeXtender SAP Table Data Source version 18 in ODX Server v6429.1. In our current setup we use Table Name filtering like this: Please see the wildcards used. How does this translate to ODX Server v21? I have these three rules: The latter does not seem to work. I tried many variations (and did a sync data source consecutively), but when I click Select Tables under a transfer task, it only comes up with the tables matchin an equal-rule. Tables that should match a like-rule never show up: Using equal and wildcards doesn’t work either Any advice on how I should filter tables properly?

In the release notes for 6429.1 it says that conditional lookup fields are available “in preview” for deployments in Snowflake. What does this mean?

Hello At 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

Hi community, I have multiple Excel files on a sFTP location, all having the same structure. I would like to load these files using 1 data connection and create a RSD file for each file/sheet that needs to be loaded. When generating the RSD via TX, it does not contain the api:set attr=”URI” property. An example: On line 2 (api:info) there is a parameter other:uri=”[...]”, but modifying this does not change anything. Manually adding the api:set attr=”URI” does not change anything either The data will always be loaded from the Excel file that you enter in the UI: Emptying the URI field results in an error that either URI or Excel File parameter should be set: Is there a way to load multiple Excel files/sheets with a single data connection using RSD files, same as we do with eg. REST API endpoints and CSV files? It will save us from creating ca. 15 separate connections :) Best, Erik TX: 20.10.43 CData Provider for Microsoft Excel 2023, v23.0.8565.0

Hi community, I have a MariaDB data source which I connect to using ODX Server (v 6346) and the CData/ADO.net connector for MariaDB v 23.0.8565.0. The source database is set to collation utf8mb4_general_ci. I noticed by copying from ODX Server to a Data Area that some special characters are slightly different than the source/ODX. I can fix this by manually changing the data type to nvarchar instead of varchar, but that is a lot of field editing. The Override Data Type function can help as well, but as we have a wide range of field lengths, this also means a lot of override rules. Is there a way to tell ODX Server that all varchar fields should be unicode/nvarchar by default (eg. based on the source database collation)? Example from ODX Server. These fields should all be nvarchar(xx) instead of varchar(xx): Implementing this idea would work for me as well :) In TX v20 Business Units, we had this option:

Hi, I want to use mapping set to map several ODX tables with the same table structure to a single DW table. The problem is that I also want to create additional “custom fields” in the DW table, and since these fields do not exist in any of the ODX tables, the mapping set excludes all the ODX tables and I am left with an empty DW table. Is there a work around to this? or am I perhaps doing something wrong? This is my DW table: The bolded fields with descriptions do not have mappings to them, they instead have custom transformations. I have used “convert to mapping set” to get the mapping set, and then adjusted it so both tables match the mapping set rules. As seen below, both tables are then excluded since neither have the custom fields. Is it necessary that all fields have at least one mapping to them?

Hi, We are unable to set up Notification on Critical Errors for the ODX Server. Both service and database for the ODX is on prem. The Exchange Server is deployed as a hybrid. TimeXtender version 6221.1 This is the error message: Setting up notification for the executions in the MDW’s and SSL’s is no problem. No authentication is required by the Exchange server. BR Anders

Hi everyone, I’ve been searching but haven’t been able to find in previous threads. For an API i'm trying to extract to TX, i'm running into some issues. The API extracts some geographical building data, based on an ID. I have these ID's from a seperate source already in the warehouse. What I want to do is get the ID from the ODX-table and for each ID run a call to the API. I'm new to this scripting language and maybe im overlooking it in existing documentation but for me it seems impossible. Any idea's and suggestions would be welcome, thanks!

Hello, I’ve got a customer who asking me this question related to the activation of TX (v. 20.10) . The TX developers use the TX desktop through a Virtual Desktop interface (VmWare horizon). For any reason the IT department has decided to rebuilt (full reinstall) all VDI servers at least one a week. Despite I provide the activation file (.lic) they didn’t succeed to automate the TX Desktop license activation and ask me if there is another way to activate the software. My answer was that the only way to get this TX desktop unlocking is to migrate to new version with the cloud repo that will unlock the Desktop when opening the project. Could you confirm there is no alternative for the legacy version regarding the activation? Maybe possible to set at least the license key is a config file then pref-filled in Desktop and the TX developers jsut need to press activate (assuming requried ports is open to reach the TX license server.? Thx for your help Michael

Hi all, For one of my current client's we are rectrieving a warning while syncing the odx. The task is completed and we can transfer the data. but the warning is a bit odd. We already tried to remove the folder from the data lake and try a full load. but this didn't fix the warning. Anyone any ideas?

I’ve detected an error (sended to support) with the packages that use full load and if the incremental rule it’s defined with a datatime field. The error it’s in the ODX transfer and I’m using a SQL data source. Hope this help you.

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?

I am working on a project with 3 environments Dev, UAT, and Prod. I scheduled ODX transfer task to run every 15 minutes. But any scheduled tasks are not working, I have to run the transfer tasks manually Regards

I’ve two tables, A and B, and I want a full outter join to obtain a table C like in the image: In T-SQL it would be: SELECT COALESCE(A.Id, B.Id) AS Id ,A.ValueA AS ValueA ,B.ValueB AS ValueB FROM TableA AS A FULL OUTTER JOIN TableB AS B ON A.Id=B.Id Is it the only way to use a custom view?

Hey, Usually when an execution package fails to start it is due to another already running, then in the event viewer we get a message like this: Here, we see that the issue is due to another package. Now I have noticed that we occasionally also get messages like this one: Difference being that it does not show which ‘other’ package is causing this issue. Is this a common occurrence?

Hello,We just upgraded our sandbox to release 6429.We created environments, and Copied from Dev to Test without problems in the portal. Both MDW and SSL. SSL was mapped to the correct MDW.But after we copied from Test to Prod this error came when we tried to deploye Data Area DSA in MDW Prod. Error details in attached text file. BRAnders

Hi, I'm currently connecting to a new api. https://ads-api.autotelex.com/swagger/index.html?urls.primaryName=Autotelex%20%7C%20Advertisement%20API%20V2%20(Beta) In my RSD file I call /api/v2/stock to get the ids for a stock, then I call /api/v2/stock/{adsStockId}/summary using the ids from the first call.The problem I run in to is that i can only make 300 calls per minute for the second call. Whenever I run into this limit my execute fails with the message: "Too many requests".Is there any way to limit or reduce the amount of calls I make per minute? Kind regards,Niek

Hi guys, I cannot get the companies and deals table to execute in the ODX phase. The error I get: Executing table [HubSpot].[Companies]:failed with error:System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out Has anyone else seen this before?

Hi, I believe this is a bug but perhaps intentional. When a field in the DSA is set to ‘Raw’ , you can still map it to the MDW. When you do this the field is not mapped (as it is impossible), however the table does become dirty (red). Then, when you refresh the instance, the field is actually added in the MDW, but not mapped. I attached a GIF that shows this.

Dear Cummunity, Is there a way to hook up the TimeXtender portal (app.timextender.com) to the Azure keyvault? We want to keep our login credentials safe and in one place so would be great to have them feed them from the keyvault to the portal. Thanks! = Daniel