Skip to main content
Solved

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

  • August 23, 2023
  • 3 replies
  • 88 views
B
Data Voyager
Forum|alt.badge.img+1

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

Best answer by anna.spakova

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

    S

    3 replies

    anna.spakova
    Ataccamer
    Forum|alt.badge.img+3
    • anna.spakovaAtaccamer
    • Ataccamer
    • August 24, 2023

    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

    B
    Data Voyager
    Forum|alt.badge.img+1
    • BhumiData Voyager
    • Author
    • Data Voyager
    • August 30, 2023

    Thanks for the response! 

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

    anna.spakova
    Ataccamer
    Forum|alt.badge.img+3
    • anna.spakovaAtaccamer
    • Ataccamer
    • Answer
    • August 30, 2023

    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

    Community Terms of Use & ConditionsCookie settingsAccessibility statement