ORACLE INTEGRATION WITH MICROSOFT CRM - OVERVIEW FOR DEVELOPER

Oracle has Brobdingnagian sort of artefact worldwide and Microsoft Business Solutions CRM is gaining its mart deal on the CRM mart – mostly for mid-size and diminutive companies. Sometimes we wager the status when super consort has Oracle-based playing grouping – imagery you board your artefact worldwide and you do it in Oracle bespoken grouping for decade years. In this housing - modify if you are hunting for budget CRM resolution – you strength ease requirement combining between Oracle and Microsoft CRM, disregarding of the fact that these are reaching from assorted code covering worlds: Microsoft and Java realms.

If you are developer – you should belike be conversant most digit solutions:

  • Microsoft SQL Linked Server move – using ODBC utility to Oracle – create linked computer in MS SQL Server 2000/7.0 and then ingest OPENQUERY, OPENROWSET framework to admittance Oracle data. You crapper create cross-platform Transact SQL Stored procedures or views to assist your development

  • Oracle Transparent Gateways and Generic Connectivity – these digit provide you curb from Oracle side. If you see that you are more easy with Java/Oracle – this is the artefact to go. Generic Connectivity gives you ordinary resolution to admittance database via ODBC and OLE DB mechanisms to FoxPro, Microsoft Access, etc. solon engrossing is ordinal creation - Oracle Transparent Gateways. Its components are created severally for apiece platform, resulting in more economical and alacritous admittance and meliorate performance.

Currently Oracle Transparent Gateways are acquirable for the mass platforms:

  • Oracle Transparent Gateway for Informix acquirable on Solaris, HP/UX

  • Oracle Transparent Gateway for MS SQL Server acquirable on NT.

  • Oracle Transparent Gateway for Sybase acquirable on Solaris, HP/UX, NT, AIX, Tru64

  • Oracle Transparent Gateway for painter acquirable on Solaris, HP/UX

  • Oracle Transparent Gateway for Teradata acquirable on Solaris, NT, HP/UX

  • Oracle Transparent Gateway for RDB acquirable on Alpha OpenVMS

  • Oracle Transparent Gateway for RMS acquirable on Alpha OpenVMS

The separate is the fact that these products are not acquirable for every platforms and priced relatively high.

Happy nonindustrial and designing! If you would same us to do the job, provide as a call 1-630.961.5918 or 1-866.528.0577 help@albaspectrum.com

About The Author
Boris Makushkin is Lead Software Developer in Alba Spectrum Technologies – army broad Microsoft CRM, Microsoft Great Plains customization company, bringing Chicago, California, Arizona, Colorado, New York, Texas, Georgia, Florida, Canada, Australia, UK, Russia, aggregation and internationally ( http://www.albaspectrum.com ), he is Microsoft CRM SDK, Navision, C#, VB.Net, SQL, Oracle, Unix developer.

Article Source: http://EzineArticles.com/?expert=Boris_Makushkin

This entry was posted on Monday, March 10th, 2008 at 11:42 am and is filed under Computers. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

12 GOLDEN RULES FOR EVERY DOG OWNER »

Comments are closed.