'Tabular Model processing is using the Microsoft System.Data.OracleClient provider and not the ODAC provider
I have installed the Oracle Data Access Components 12.2c (both 32bit and 64bit) on my SQL Server machine.
With this components I was able to directly import tables from an Oracle database into the tabular model at design time, providing a configuration name (CODASREP) form the tnsnames.ora file as the connection string and the database credentials. Full process of the model at design time was no problem. I'm using the integrated workspace.
After I deployed the model to the SSAS server, I wonted to process it and got this error:
Failed to save modifications to the server. Error returned:
'OLE DB or ODBC error: [DataSource.Error] The provider being used is deprecated: 'System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.'.
Please visit https://go.microsoft.com/fwlink/p/?LinkID=272376 to install the official provider.
It seems, that the SSAS server is using the Microsoft provider, and not the installed Oracle provider, when processing the deployed Model directly on the server.
The connection XMLA is:
{
"createOrReplace": {
"object": {
"database": "CODAS_DIRECT",
"dataSource": "Oracle/CODASREP"
},
"dataSource": {
"type": "structured",
"name": "Oracle/CODASREP",
"connectionDetails": {
"protocol": "oracle",
"address": {
"server": "CODASREP"
},
"authentication": null,
"query": null
},
"options": {
"hierarchicalNavigation": true
},
"credential": {
"AuthenticationKind": "UsernamePassword",
"kind": "Oracle",
"path": "codasrep",
"Username": "user_name"
}
}
}
}
How do i force SSAS to use the Oracle provider when processing the deployed model?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
