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...
I'd like a menu in the Web (System Administrator) for backup and recover databases using an easy interface.
Sometimes is very useful to snapshot a database and recover it from a known status.
Stop services, copy directories, in windows or linux ...
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.