Notifications
Announcements
No record found.
Hi ,
i need create one page in MS crm where we get data from SQL Server 2008 .
how we get data from Sql Server 2008 to MS crm page .
Please help me . My mail id - puneet.pkt@gmail.com
*This post is locked for comments
Hi, i would create a web service method, passing the right parameters, and from there connecting to the SQL instance.
So, in a form, i would but a MVC page, or ASPX page or an HTML page to call that method and render the information like you need.
Do you want to have the page to be displayed inside CRM or outside CRM? And retrieve data from the SAP database?
To get from inside, I would suggest initially to create a HTML and JavaScript WebResource combo to retrieve the info from SQL server. You may need to create a Odata or Soap service to retrieve the data from SQL server to be consumed by the CRM JavaScript Resource:
msdn.microsoft.com/.../gg328025.aspx
the downside is a lot of code, but it will allow you to work on the contect of the CRM user that logs in.
Another option is creating a portal
msdn.microsoft.com/.../gg695814.aspx
the good side of portal is that you can use ASP.NET. the downside is that you will need to run in a separated IIS web site and it will connect to CRM impersonating 1 CRM user.
you can than expose the asp.net page though an IFRAME.
Hi , i am created page(entity) in crm , and need to connect this SAP B1 Database ( SQL Server 2008 )
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
SA-08121319-0 4
Calum MacFarlane 4
Alex Fun Wei Jie 2
