Developer forum

Forum » Feature requests » Data Integration (Possible to define SQL for filtering when export/importing data)

Data Integration (Possible to define SQL for filtering when export/importing data)

E-mail notifications
Morten Fink Eriksen
Reply
Posted on 04/02/2013 16:19:06

I would like to propose the option to define SQL when exporting/importing data in the data integration module. Right now when you export data you seem only to have the option of exporting all or nothing from a given tabel(s).

 

Shouldn't it at be possible to define some filtering on the data to be exported/imported?

 

Usually i will manually go into SQL Management Studio and do the export manually from there, but it would be nicer to have this option in data integration.


Replies

 
Morten Bengtson
Posted on 04/02/2013 23:42:31
Reply

Hi Morten,

You can define some simple filtering (conditional) along with the table mappings - click on the funnel icon. However you can only use simple conditionals, like greater than, less than and equal to. See attached image.

If you need more advanced filtering and you are exporting from SQL Server then you can create a view that only returns the rows of data you want to export.

For XML you can also use XSLT to filter out the elements you dont want.

Hope this helps :)

/Morten

dataintegration_conditionals.png
 
Morten Fink Eriksen
Posted on 05/02/2013 08:10:18
Reply

Hi Morten

 

Yeah.. i forgot about the funnel, but it only allows for one conditional as i see it. This is also why i manually export from the DB on the server most of the time, so i can further filter with all the neccesary values i want.

 

Would just be nice to be able to write some SQL instead of having fixed filter options and only one filter to apply on the solution.

 
Morten Bengtson
Posted on 05/02/2013 09:01:06
Reply

You can add multiple conditionals if you want, but it sounds like the right tool for you is SQL Server Management Studio.

 

/Morten