Biztalk integration architecture

Question

Hello guys,

I want to integrate Oracle 11g database with Dynamics CRM 2011(on-premise) using Biztalk. The Oracle database has got over 5000 records. All the records in the database should be moved into CRM. After migrating the data from Oracle to CRM, if there are any changes to records in Oracle the CRM must be updated as well. The Oracle database is being updated by another application. My problem is how do i do it. I need some steps. Using BizTalk is a client requirement.

---

Good is not good enough when best is expected !!!

Answer 1

This is a typical scenario you can solve with BizTalk.

There are adapters available to connect to both Dynamics CRM as well as Oracle 11g.

You can start building up knowledge by taking a look at these blog posts:

http://synthesisconsulting.net/blog/2012/5/10/oracle-and-biztalk-server-part-1.html

http://blog.eldert.net/integrating-crm-2011-with-biztalk-2010-continued/

---

Jean-Paul Smit | Didago IT Consultancy
Blog | Twitter | LinkedIn
MCTS BizTalk 2006/2010 + Certified SOA Architect

Please indicate "Mark as Answer" if this post has answered the question.

Answer 2

Hi,

Below blogs also will help.

CRM-2011 Biztalk 2010 Integration

Receiving Database Change Notifications

Thanks,

Deepthi

Answer 3

we can integrate Biztalk with Dynamic CRM using file as well as WCF Adapter .

you can create service in CRM for insert , update records .

follow this link(http://technet.microsoft.com/en-us/library/gg731906.aspx), for creating service .

then use this service in biztalk along with integration of oracle .

Answer 4

My main problem is not about integrating to CRM. I want to move records from the Oracle database into CRM. After moving these records I will update CRM if there any changes(insert or update) to Oracle database. How do i? I tried polling but I realised its not suitable for my scenario.

---

Good is not good enough when best is expected !!!

Answer 5

My main problem is not about integrating to CRM. I want to move records from the Oracle database into CRM. After moving these records I will update CRM if there any changes(insert or update) to Oracle database. How do i? I tried polling but I realised its not suitable for my scenario.

---

Good is not good enough when best is expected !!!

Answer 6

My main problem is not about integrating to CRM. I want to move records from the Oracle database into CRM. After moving these records I will update CRM if there any changes(insert or update) to Oracle database. How do i? I tried polling but I realised its not suitable for my scenario.

---

Good is not good enough when best is expected !!!

Answer 7

Use Typed Polling with update action for Dynamic Ax

Answer 8

Hi,

So the requirement has two steps :

Step 1. Move existing data in Oracle database  to CRM.  This is a onetime activity.

Step2. As soon as a new record is created or updated in database, move those records to CRM.

Step1: Please take a look at http://soa-thoughts.blogspot.co.uk/2010/08/wcf-sql-adapter-table-operations.html .

Here you can find how a select operation can be performed with a request –response port.

You  need to send an xml with select request and get the response back to calling orchestration.

Step2: For  fetching new/updated records, please refer http://seroter.wordpress.com/2009/01/12/query-notification-capability-in-wcf-sql-adapter/

Use the shapes required for step 1  and step 2 as branches of a Listen shape.

After the Listen shape , do the necessary mapping to transform select response xml message to CRM create message.

Add the send port for CRM.

For creating records in CRM, please refer http://seroter.wordpress.com/2011/02/10/the-good-bad-and-ugly-of-integrating-dynamics-crm-2011-and-biztalk-server-2010/.

HTH

Thanks,

Deepthi