DreamPirates DreamPirates

Oracle Integration with Microsoft CRM - Overview for Developer

Author : Elizabeth Huston789
Publish Date : 2021-04-24 08:02:49
Oracle Integration with Microsoft CRM - Overview for Developer

Oracle has huge number of installation worldwide and Microsoft Business Solutions CRM is gaining its market share on the CRM market - mostly for mid-size and small companies. Sometimes we see the situation when large company has Oracle-based business system - imaging you ship your goods worldwide and you do it in Oracle custom system for ten years. In this case - even if you are looking for budget CRM solution - you might still need integration between Oracle and Microsoft CRM, regardless of the fact that these are coming from different software application worlds: Microsoft and Java realms.

If you are developer - you should probably be informed about two solutions:

Microsoft SQL Linked Server approach - using ODBC driver to Oracle - create linked server in MS SQL Server 2000/7.0 and then use OPENQUERY, OPENROWSET technique to access Oracle data. You can create cross-platform Transact SQL Stored procedures or views to facilitate your development
Oracle Transparent Gateways and Generic Connectivity - these two give you control from Oracle side. If you feel that you are more comfortable with Java/Oracle - this is the way to go. Generic Connectivity gives you common solution to access database via ODBC and OLE DB mechanisms to FoxPro, Microsoft Access, et

 

 

https://redzone.labette.edu/ICS/Campus_Life/Campus_Groups/Radiography_Club/Discussion.jnz?portlet=Forums&screen=PostView&screenType=change&id=910b9ed2-311e-46b6-aa8f-dbb7d878af52
https://redzone.labette.edu/ICS/Campus_Life/Campus_Groups/Radiography_Club/Discussion.jnz?portlet=Forums&screen=PostView&screenType=change&id=847b6e73-1c13-4b8c-80d2-b423f81cdf38
https://redzone.labette.edu/ICS/Campus_Life/Campus_Groups/Radiography_Club/Discussion.jnz?portlet=Forums&screen=PostView&screenType=change&id=3227fa15-07cd-43a4-8cac-6836ea60c551
https://redzone.labette.edu/ICS/Campus_Life/Campus_Groups/Radiography_Club/Discussion.jnz?portlet=Forums&screen=PostView&screenType=change&id=7ed7c602-0f65-456f-bb72-75aa2d6dbcb4
https://redzone.labette.edu/ICS/Campus_Life/Campus_Groups/Radiography_Club/Discussion.jnz?portlet=Forums&screen=PostView&screenType=change&id=8d8714e7-a8ca-4c1a-a2e2-bc889cf42785

 

c. More interesting is second product - Oracle Transparent Gateways. Its components are created individually for each platform, resulting in more efficient and fast access and better performance.
Currently Oracle Transparent Gateways are available for the following platforms:

Oracle Transparent Gateway for Informix available on Solaris, HP/UX
Oracle Transparent Gateway for MS SQL Server available on NT.
Oracle Transparent Gateway for Sybase available on Solaris, HP/UX, NT, AIX, Tru64
Oracle Transparent Gateway for Ingres available on Solaris, HP/UX
Oracle Transparent Gateway for Teradata available on Solaris, NT, HP/UX
Oracle Transparent Gateway for RDB available on Alpha OpenVMS
Oracle Transparent Gateway for RMS available on Alpha OpenVMS
The disadvantage is the fact that these products are not available for all platforms and priced relatively high.

Happy developing and designing! If you would like us to do the job, give as a call 1-630.961.5918 or 1-866.528.0577 [email protected]


Boris Makushkin is Lead Software Developer in Alba Spectrum Technologies – USA nationwide Microsoft CRM, Microsoft Great Plains customization company, serving Chicago, California, Arizona, Colorado, New York, Texas, Georgia, Florida, Canada, Australia, UK, Russia, Europe and internationallyOracle has huge number of installation worldwide and Microsoft Business Solutions CRM is gaining its market share on the CRM market - mostly for mid-size and small companies. Sometimes we see the situation when large company has Oracle-based business system - imaging you ship your goods worldwide and you do it in Oracle custom system for ten years. In this case - even if you are looking for budget CRM solution - you might still need integration between Oracle and Microsoft CRM, regardless of the fact that these are coming from different software application worlds: Microsoft and Java realms.

If you are developer - you should probably be informed about two solutions:

Microsoft SQL Linked Server approach - using ODBC driver to Oracle - create linked server in MS SQL Server 2000/7.0 and then use OPENQUERY, OPENROWSET technique to access Oracle data. You can create cross-platform Transact SQL Stored procedures or views to facilitate your development
Oracle Transparent Gateways and Generic Connectivity - these two give you control from Oracle side. If you feel that you are more comfortable with Java/Oracle - this is the way to go. Generic Connectivity gives you common solution to access database via ODBC and OLE DB mechanisms to FoxPro, Microsoft Access, etc. More interesting is second product - Oracle Transparent Gateways. Its components are created individually for each platform, resulting in more efficient and fast access and better performance.
Currently Oracle Transparent Gateways are available for the following platforms:

Oracle Transparent Gateway for Informix available on Solaris, HP/UX
Oracle Transparent Gateway for MS SQL Server available on NT.
Oracle Transparent Gateway for Sybase available on Solaris, HP/UX, NT, AIX, Tru64
Oracle Transparent Gateway for Ingres available on Solaris, HP/UX
Oracle Transparent Gateway for Teradata available on Solaris, NT, HP/UX
Oracle Transparent Gateway for RDB available on Alpha OpenVMS
Oracle Transparent Gateway for RMS available on Alpha OpenVMS
The disadvantage is the fact that these products are not available for all platforms and priced relatively high.

Happy developing and designing! If you would like us to do the job, give as a call 1-630.961.5918 or 1-866.528.0577 [email protected]


Boris Makushkin is Lead Software Developer in Alba Spectrum Technologies – USA nationwide Microsoft CRM, Microsoft Great Plains customization company, serving Chicago, California, Arizona, Colorado, New York, Texas, Georgia, Florida, Canada, Australia, UK, Russia, Europe and internationallyOracle has huge number of installation worldwide and Microsoft Business Solutions CRM is gaining its market share on the CRM market - mostly for mid-size and small companies. Sometimes we see the situation when large company has Oracle-based business system - imaging you ship your goods worldwide and you do it in Oracle custom system for ten years. In this case - even if you are looking for budget CRM solution - you might still need integration between Oracle and Microsoft CRM, regardless of the fact that these are coming from different software application worlds: Microsoft and Java realms.

If you are developer - you should probably be informed about two solutions:

Microsoft SQL Linked Server approach - using ODBC driver to Oracle - create linked server in MS SQL Server 2000/7.0 and then use OPENQUERY, OPENROWSET technique to access Oracle data. You can create cross-platform Transact SQL Stored procedures or views to facilitate your development
Oracle Transparent Gateways and Generic Connectivity - these two give you control from Oracle side. If you feel that you are more comfortable with Java/Oracle - this is the way to go. Generic Connectivity gives you common solution to access database via ODBC and OLE DB mechanisms to FoxPro, Microsoft Access, etc. More interesting is second product - Oracle Transparent Gateways. Its components are created individually for each platform, resulting in more efficient and fast access and better performance.
Currently Oracle Transparent Gateways are available for the following platforms:

Oracle Transparent Gateway for Informix available on Solaris, HP/UX
Oracle Transparent Gateway for MS SQL Server available on NT.
Oracle Transparent Gateway for Sybase available on Solaris, HP/UX, NT, AIX, Tru64
Oracle Transparent Gateway for Ingres available on Solaris, HP/UX
Oracle Transparent Gateway for Teradata available on Solaris, NT, HP/UX
Oracle Transparent Gateway for RDB available on Alpha OpenVMS
Oracle Transparent Gateway for RMS available on Alpha OpenVMS
The disadvantage is the fact that these products are not available for all platforms and priced relatively high.

Happy developing and designing! If you would like us to do the job, give as a call 1-630.961.5918 or 1-866.528.0577 [email protected]


Boris Makushkin is Lead Software Developer in Alba Spectrum Technologies – USA nationwide Microsoft CRM, Microsoft Great Plains customization company, serving Chicago, California, Arizona, Colorado, New York, Texas, Georgia, Florida, Canada, Australia, UK, Russia, Europe and internationally



Category : general

Objectives of CompTIA Network Plus Certification 2009 Edition

Objectives of CompTIA Network Plus Certification 2009 Edition

- Exam N10-004 is one of the CompTIAs certification examinations and the exam name is CompTIA network plus 2009 edition certification. This certification is inte


Genuine Avaya 72200X Exam Preparation Dumps

Genuine Avaya 72200X Exam Preparation Dumps

- Use adjectives. Adjectives explain nouns. Under no circumstances just produce the noun - explain it using adjectives. "The picturesque point


Microsoft Dynamics GP 9.0 / Great Plains Support in Argentina: Dexterity Development, Reporting

Microsoft Dynamics GP 9.0 / Great Plains Support in Argentina: Dexterity Development, Reporting

- Microsoft Dynamics ERP product family consists of Microsoft Dynamics GP (former Microsoft Great Plains, Great Plains Software eEnterprise/Dynamics/Dynamics C/S+


Home Business Tips That Will Make You A Success

Home Business Tips That Will Make You A Success

- In todays economy, many people are out of work, desperately trying to find jobs or other sources of income to make ends meet. As an alternative, some peopl