PDI parameter in select statement

Question

I want to ask a question about the Pentaho. I use Pentaho data Integration(Kettle). I want to use a parameter in a select statement. I searched various forums and did not find any solution. My problem is that I want to get the result from different databases. How can I use a parameter to retrieve data from 2 or more databases? I have two transformations.

• select catalog_name from information_schema.schemata where catalog_name like "%db"
• select data_name from ${catalog_name}.dbo.database_name

Is there a mistake that says Syntax error or access violation?

Answer 1

, . , 1 ( ). # 2 , .

, , .

, , , - Replace variables in script 2.

, , .

Answer 2

, SQL SQL.

? . , Kettle . schema_name , . . , SQL . . , ? MySQL. SQL , MS SQL Server. , -.

:

, script, . .