Unanswered questions

I believe I have read the documentation, in case I missed something. My bad. Im trying to load csv files from the root of a S3 bucket. The 'test connection’ in the portal turns green but when trying to synchronize in timextender it tells me I have to enter a value for ‘path’.I have tried these so far: /.mybucketname/inbound/s3://mybucketname/inbound/But timextender keeps throwing errors saying the directory does not exist. I can succesfully connect to it and download the csv's via Python so Im quite sure the setup is correct.  Does anyone know what to fill in for ‘path’?

A JSON response looks like this [{"ref": 123456,"dim_1": "A","dim_2": "B","peroid": 202601},{"ref": 5E+20242959,"dim_1": "A","dim_2": "B","period": 202602}]The second ref (5E+20242959) is a problem - its neither STRING nor an INT.Ref is defined as NVARCHAR in BU, but as you can see the value is not between “”.I have tried the following approaches under, still i get the same errorInput string '5E+20242959' is not a valid number. Path '[56935]['ref.53e92a42-b13c-4062-87b4-6bd5a89547b1.1992753']', line 1, position 36741783.How do i solve this?Here are the approaches i have tried:Omitting Ref in Table FlattningIn table flattning, i have left it out. I have the other three values, but still landing returns an error:Defining the value as NULL in table flattningField transformationCondition on column ref in BUI have defined the following condition on the column, still i get the same errorCASE WHEN [ref] LIKE '5E+%' THEN NULL ELSE [ref]ENDScript ActionsI have created a script th

I run into this error while loadning csv-files from our s3 bucket.The issue is that the number of fields differs from time to time. We would like to ignore that and read these fields if they exists and otherwise not.Is there a way to do this or is this just an exception in CsvHelper-lib that isnt accessible for me to configure? The error:Executing table [csv].[VOF_UTF_Planeradebesok__aggregated]:failed with error:CsvHelper.MissingFieldException: Field with name 'Planerat besök - konfidentiellt' does not exist. You can ignore missing fields by setting MissingFieldFound to null.IReader state:   ColumnCount: 21   CurrentIndex: -1   HeaderRecord:["Användare - ID2","Användare - personnummer","Användare - profession","Avbruten/inställd","Brukare - ID2","Brukare - personnummer","Planerad resurs - namn","Planerat besök - dubbelbemanning","Planerat besök - ej utfört (anledning)","Planerat besök - sluttid","Planerat besök - starttid","Planerat besök - typ av brukare","Planerat besök - utfört","P

I have a large table with about 50 columns. There is column called projectNumber. This column, i am unable to override.This column is varchar. However in TX with Enhanced Drivers it shows Int32.I have overridden it to Text It even says so in Data type overrides on the DataSource I have even tried adding and removing it in Table builder  

Hi,I have two Execution Package chains ("Run Packages...") configured as follows:Chain 1:1a) Revenue 1b) Revenue Trigger 1c) Morning 1d) Morning TriggerChain 2:2a) Store 2b) Store TriggerThe requirement is that 2a) Store and 2b) Store Trigger must not run concurrently with 1c) Morning or 1d) Morning Trigger.I have configured this restriction in the Concurrent Packages section under Edit Execution Package. However, the restriction does not currently seem to be enforced as expected.Could this be because 1a) Revenue and 1b) Revenue Trigger are allowed to run concurrently with 2a) Store and 2b) Store Trigger?In other words, when Execution Packages are part of a chain, do the concurrency restrictions need to be configured for every package in the chain? Or should the restriction between 1c/1d and 2a/2b be sufficient to prevent those specific packages from running at the same time?

So i think i must be missing something or maybe even forgetten.My dataflow: I have a Data source connection (dsc) ingesting csv-files from a S3 bucket with an aggregation pattern since the files have the date in the filename to make sure we dont overwrite any files. Each row in each file has a column with the date. So all rows in the file has the same date. The ingestion has a data type override to override all columns to nvarchar(max) since we cant trust the data source. The data is then transfered to a to a table in a data area as is.  Next step is with a view for validation and a simple table insert move data to a table with data types we want to work with.This last table is a History table. Not that we use any scd we simply want to update the data and use the scd-columns to be able to know first seen/last seen stuff. Problem/question:Since this last table is a history table, its vital that rows are inserted in the correct order (date order i wrote about in step 1) to not update row

I'm using (legacy) TimeXtender version 20.10.82 with ODX.I messed up something in the .RSD file for a CData REST data source and subsequently fixed my mistake. But still, somehow, this has broken all tables in that data source. Executing the DSA tells me "Table not found in the data source" while the tables are clearly still there.I tried executing the synchonize task in the ODX and even deleted the .parquet files and fully loaded everything again. No luck. After "Synchonize objects" in my TimeXtender project all DSA tables lose their mappings to the ODX tables.TimeXtender probably tries to find the ODX tables but their id's have changed or whatever. Is there a way to fix this without remapping all my DSA tables?I'm 100% certain I've seen this behaviour before but on a smaller scale with less impact.

We want to compare production data after the promote of changes to a saved snapshot of data using TX OD&Q.I can see in your documentation the description of “Saved Comparatives” as below:Saved ComparativeSaved Comparative are used to compare data to a previously saved snapshot of that data. This can be convenient when the source data doesn’t have an audit trail of changes. Examples of Saved Comparative queries are:Monitor changes in access privileges. Monitor customer discount changes. However I can see no way to setup Saved Comparatives or How to build them into a comparative test. Can you please let me know if what I want o achieve is possibel and how I can implement it if it does work please. 

Hello. This document has the ports which need to be opened. Configure your Firewall | Community It doesn't reference Fabric Lakehouse.. are you able to advise what we need to open for the ingest service to communicate to Fabric Lakehouse?Thanks Tim