Forum Discussion

CTouu's avatar
CTouu
Frequent Visitor
3 years ago
Solved

ODBC Url connection How to put a parameter

Hi !    I've got a simple (I think) issue.  I have a simple connection to a Postgre DB Connection by ODBC (i don't use the postgre connector, don't need to propose).  I have several DBs and I wan...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago
    = Odbc.DataSource("Driver={PostgreSQL Unicode(x64)};Server=localhost;Port=5432;Database=" & databasename & ";", [HierarchicalNavigation=true])
lbendlin's avatar
lbendlin
Super User
3 years ago
I decide which of the parameter value to use in the query editor

How?

CTouu's avatar
CTouu
Frequent Visitor
3 years ago

In the Source Query : 

= Odbc.DataSource("Driver={PostgreSQL Unicode(x64)};Server=localhost;Port=5432;Database=databasename;", [HierarchicalNavigation=true]) 

 

I want to add a parameter name instead of "databasename" because for now it's hardcoded and I want the database name to be dynamic.

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    Why does it have to be a multi choice parameter? Could it be a scalar parameter instead?

     

    Are you trying to implement your own version of deployment pipelines?

    • CTouu's avatar
      CTouu
      Frequent Visitor
      3 years ago

      I think you didn't understood my issue. 

      I just want to know how to variabilize an ODBC Source in the Query Editor 

      For example : 

      I need to import 23 tables

      if I have a DEVELOPMENT database with a dbname A

      and a PROD database with a dbname B

      I want to know how to switch the dbname without having to change the dbname manually in each of the 23 tables 

      • lbendlin's avatar
        lbendlin
        Super User
        3 years ago
        = Odbc.DataSource("Driver={PostgreSQL Unicode(x64)};Server=localhost;Port=5432;Database=" & databasename & ";", [HierarchicalNavigation=true])