Forum Discussion

nerra's avatar
nerra
Icon for Helper II rankHelper II
5 years ago
Solved

Apply parameters to existing dataset

HI All,   I have an inherited dataset with an ODBC connection to Redshift defined for the data source.  I get an error when I change the actual server name and database name to the parameters "ser...
Need Help
Show and Tell
  • lbendlin's avatar
    lbendlin
    5 years ago

    ODBC{"connectionstring":"dsn=" & DSNName }

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

It has to be exactly the same DSN definition as you do on your desktop. 

 

Hint:  You can export your definitions from your registry, give it to the gateway admin, and they can import it into the registry on all cluster members.

 

Yes, you can store the username and password.  Remember that only report developers have access to the gateway connections, and that they have to authenticate again anyway in order to use the connections.  The only issue would be if your gateway user credentials have a wider schema than the developer user credentials. In that case you need to create multiple DSNs, one per schema.

nerra's avatar
nerra
Icon for Helper II rankHelper II
5 years ago

HI lbendlin 

 

OK. I've done that. 

But, when I try to set up ODBC{"connectionstring":"dsn=amazon redshift tb qa"} to ODBC{"connectionstring":"dsn=DSNName"} where DSNName is the parameter, it doesn't work?

 

Any suggestions?

Regards,

Nera