Hello Dan,

I would look into using the "SQLExecutor" or "SQLCreator" transformers. You can initiate a "Creator" Transformer and pipe that into the "SQLExecutor" to run your SQL command against your DB and return the desired results, or you can use the "SQLCreator" at the beginning of your workflow.

Thank you John

I will try this, but is this not possible to solve by using join, filter or any other transformer ?

Can you show how you have the FeatureJoiner set up?

Danketil,

​

Based on your description, it seems like you would like to read features from one database and then insert them directly into ​a different database. A featurejoiner typically takes two streams of data and joins then based on an attribute key. The featurejoiner can perform left,inner,full,etc joins, however it doesn't sound like this is what you need. You could simplify your process to use a MSSQL reader to read the table from the first database, and then use a MSSQL writer to insert those features into the second database into a new or existing table. Check out the help articles on this page. If my understand of your question is incorrect, you may want to update your question and attach your current workspace so the community can better assist you.

​

​

​

​

John,

Please find attached a screenshoot of my flow