web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Dynamics CRM Online Co...
Microsoft Dynamics CRM (Archived)

Dynamics CRM Online Connection to Oracle Database (System.Security.SecurityException )

(0) ShareShare
ReportReport
Posted on by Community Member

Hi Dev,

I've looked around everywhere on internet to see how can I connect Dynamics CRM Online to the Oracle Database. I used MSBuild ILMerge to merge Oracle.DataAccess class to dynamics CRM online. But it throws following exception System.Security.SecurityException. This is due to call to database has been made from Dynamics CRM Online, someone suggest on one of the blogs to create own WCF wrapper but didn't mention how.

Please share your views on this

I can share my code too.

Many Thanks

Jibran  

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    prt33k Profile Picture
    prt33k 6,907 on at

    You cannot use 3rd part dll on CRM online as they are partially trusted caller. CRM online require fully trusted dll.

    The only way possible is to create a web-service layer and then access Oracle data from there. This web-service can be hosted in Azure.

  • Community Member Profile Picture
    Community Member on at

    Hi Prateek,

    Sorry for being naive can you please share more on how can I do this. Like any technical how to do on above.

    Many Thanks

    Jibran

  • Suggested answer
    prt33k Profile Picture
    prt33k 6,907 on at

    Hi Jibi,

    So you need to first create a REST service which can access Oracle DB. This service will be able to utilize the above dll since it doesnt require fully trusted called.

    You can refer following blog to create service:

    www.compilemode.com/.../how-to-create-wcf-rest-service.html

    Once the service is created, you need to host it on Azure. These blog will help to do that:

    www.brianhprince.com/.../hosting-a-webapi-service-on-windows-azure-web-sites

    www.c-sharpcorner.com/.../create-and-publish-asp-net-web-api-in-azure

    You will need to connect to Oracle instead of SQL.

    Once that is done, you can call the above service from CRM. Following video explains that:

    www.youtube.com/watch

    Do let me know if you need help in any of the specific step.

    Thanks,

    Prateek

  • Community Member Profile Picture
    Community Member on at

    Hi Jibi,

    Take a look at Skyvia for no coding integration between Dynamics CRM Online and Oracle database. This app has a pretty intuitive interface and offers powerful mapping features (including flexible scheduling). See more here: skyvia.com/data-integration/integrate-dynamics-crm-oracle

    Regards, David

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans