Data Load from SQL

1

It’s takes hour to load my SQL table and after transformation, when Easy morph project closed, all the data load gone. Is there a way, data load will remain there when we re-open same Easy morph project.

2

Hi Manish and welcome to the Community!

  1. Save the result of the query by right-clicking the "Import from database" action with the query, and choosing "Save to file" -> "EasyMorph dataset".

image

The .dset format is the native data format of EasyMorph. EasyMorph reads and writes .dset files very quickly - up to a million rows per second.

  1. Then, insert the "Import dataset" action (that reads a .dset file) before or after the "Import from database" action and configure it to read the .dset file created above.

  2. Disable the "Import from database" action (right-click the action and choose "Disable").
    image

Now your workflow reads from the .dset file instead of the database.

If you need to re-read from the database, you can disable "Import dataset" and re-enable "Import from database".

image

1 Like
3

Hi there, thanks for your quick response.

4

Sorted it now, Thank you :slight_smile:

1 Like