Load multiple Excel files from a directory with one connection and extract (like CSV Files).
Load multiple Excel files from a directory with one connection and extract (like CSV Files). Basically the same structure like creating a file extract using a folder-connection. But also working with Excel files :)
Integration patterns between Microsoft Dynamics 365 and external systems (Jedox) typically rely on the use of CSV files to pass data between the 2 applications with Azure BLOB storage the place to put or get the file from
Bring back addFileNameColumn in directory/ file extract
As of Version 23.4 the distinct directory extract has been deprecated in favour of the option to select to extract either a single file or a directory within the file extracts. While doing this the addFileNameColumn option of the directory extract...
Our Partner had the following request: We need some of the jobs to be able to run when a long job is already running but they shouldn't run when other jobs are running.This means we cannot set them as standard and cannot set them as parallel.The i...
Filesize in Metadata Extract for Directory Connection
After access on the cloud to Java.IO and other classes in the integrator has been blocked, it is no longer possible to query the size of files. This is very important for various use cases. My suggestion would be to output the size in Metadata Ext...
When creating ETL project, a lot of debugging is needed. At this moment to check if data is correct, I'm exporting data to CSV right from DataPreview vindow. The problem - it exports only data visible on screen.
Sure - with BIG data, it is ok.
My...
Create Load/Transform from Extract and Load from transform
in the flow of creating new models we commonly create Extract, Transform and Load for each dimension. It would be nice to create a transform right from the editing window of an extract and jump right into it's settings, to edit it directly.
For very large tables in SAP it tooks a long time to select all fields to export. It would be nice if there is a select option to export all existing fields of a SAP-Table by one click.
Set ETL variable value based on other variables (via formula)
Sometimes a variable in ETL is just a simple math calculation based on another variable.
Example: year_end = year_start + 10
Another case would be a simple "if then else" condition based on another variable.
==>
It would be great to just defi...