DSN setup Simba ODBC Driver for Big Query using powershell

247 Views Asked by At

Im trying to setup dsn using powershell but I cannot get 'Encrypted Sensitive Data' parameter configured. It always keep 'For currently user only' and I need 'For all users'. this paramater is new in the latest odbc driver version, before didn't exist.

enter image description here

Im using the following code structure (I substitute my personal values for xx just to show the code):

Add-OdbcDsn -Name "xx" -DriverName "Simba ODBC Driver for Google BigQuery" -DsnType "System" -Platform "64-bit" -SetPropertyValue @("EncryptedSensitiveData=0","OAuthMechanism=0", "Email=xx", "KeyFilePath=xx", "Catalog=xx", "DefaultDataset=xx")

0

There are 0 best solutions below