Hi, I'm trying to connect our own data source using on-premises data gateway(enterprise mode). I wrote custom connector. chose that connector during gateway setup. Below are custom connector essential details.
1. it's an odbc datasource connector.
2. authentication type is UsernamePassword.
3. shared function accepts one required parameter. It's DSN.
4. TestConnection function is handled. (pass DSN parameter to the shared datasourcekind function).
For info DSN is configured in ODBC dataSource Administrator under sytemDSN tab where i gave service host,port,service datasource.
Now i'm trying to configure data source setting in gateway, it gives 3 text boxes 1 for DSN,2 for Username and 3rd for Password and clicked on add button. Getting below error.
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
| Microsoft.Data.Mashup.MashupSecurityException.DataSources: | [{"kind":"Lab","path":"{\"dsn\":\"{\\\"dsn\\\":\\\"lablocal\\\"}\"}"}] |
| Microsoft.Data.Mashup.MashupSecurityException.Reason: | CredentialMissing |
i'm reading credentials from Extension.CurrentCredential(). dsn is required parameter("lablocal") so,it'll be passed.
Tried by hard coding the credentials too. But getting same error. Same connector is working in powerBI desktop.
Could you please help/suggest what could be the reason? How can i move forward to solve this? Can we use DSN in gateway data source adding process?
