Forum Discussion
Windows AD Authentication to Oracle Datasource from Fabric Fails
Solved.
We had to enable SQLNET settings in our sqlnet.ora file referenced by OCMT running on the gateway.e.g.
SQLNET.AUTHENTICATION_SERVICES= (<our approved auth sources>)
SQLNET.KERBEROS5_CC_NAME = OSMSFT://
SQLNET.KERBEROS5_CONF="<Path to our krb5.conf>"
Community SupportHi amoren ,
Thanks for reaching out to the Microsoft fabric community forum.
It looks like the issue is related to how Windows AD authentication is handled through the on-premises data gateway. While Oracle CMU works fine with Power BI Desktop, the Fabric service authenticates through the gateway, which requires some additional configuration.
Here are a few suggestions that may help:
Ensure that the gateway is running under a domain account that is recognized by your Oracle CMU setup. This is important for Kerberos-based authentication to work properly.
Some users have successfully configured DSNs with Kerberos or used Oracle Wallets mapped to the domain account for secure access.
Please go through the below link:
Solved: Issue when connecting fabric to oracle using pipel... - Microsoft Fabric Community
If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.
Best Regards,
Menaka Kota
Community Support Team
- v-menakakota
Hi amoren ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution so that other community members can find it easily.
Thank you.Solved.
We had to enable SQLNET settings in our sqlnet.ora file referenced by OCMT running on the gateway.e.g.
SQLNET.AUTHENTICATION_SERVICES= (<our approved auth sources>)
SQLNET.KERBEROS5_CC_NAME = OSMSFT://
SQLNET.KERBEROS5_CONF="<Path to our krb5.conf>"