This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Thank you for the post! There are so many ways to do this and one of them is the one below.
1) When you configure the Input Tool, include the database name and schema in the 'Table or Query' field.
2) In the Action Tool, you will want to update the database name with the selection you make. For example, if you select database 'ABC123', the Action Tool will update the query from "Select * From AdventureWorks2014.dbo.edtestapp" to "Select * From ABC123.dbo.edtestapp"
3) The available database selections can be configured using a Drop Down Tool.
Attached please find the sample workflow. Hope this helps!