Skip to main content

Can ‘SQL Select’ stage only be used to connect with SQL Server DB ?

Hello @Bhumi,

 

can you please elaborate, what you mean by SQL Select stage? Do you mean the SQL catalog items in Ataccama ONE Catalog or SQL Select step in ONE Desktop? In both cases, however, this is not limited to only SQL Server but any JDBC and Metastore connections.

Kind regards,

Anna


Thanks for the response! 

Is there a way to use parameterization capability in JDBC Reader stage in Desktop version please?


Hi @Bhumi , yes, you can parametrize most of the properties if you are using components. https://support.ataccama.com/home/docs/aip/latest/development-guides/one-desktop-development-guide/working-with-plans/working-with-component-steps#WorkingwithComponentSteps-HowtoMapaPropertyasaParameter If you would like to use some variables in the select query, then it’s probably better to use SQL Select step which isn’t an Input step.

Kind regards,

Anna


Reply