Skip to main content
Solved

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

B
Data Voyager
Forum|alt.badge.img+1
  • BhumiData Voyager
  • Data Voyager
  • 5 replies

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

View original
    Did this topic help you find an answer to your question?

    3 replies

    anna.spakova
    Ataccamer
    Forum|alt.badge.img+3

    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
    • 5 replies
    • 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
    • 144 replies
    • 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

    Reply


    Most Liked this week

    Community Terms of Use & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings