Oracle Integration with Microsoft Dynamics CRM - Alba Spectrum

Released on = April 17, 2006, 4:40 pm

Press Release Author = Alba Spectrum Group

Industry = Computers

Press Release Summary = 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.

Press Release Body = Alba Spectrum Group, USA/Canada: 866-528-0577, 1-630-961-5918,
Brazil: 55-11-3444-4949, Europe: +44 20 8123 2580, +45 36 96 55 20, Mexico:
52-55-535-04027, help@albaspectrum.com skype: albaspectrum

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, 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.

About Alba Spectrum Group. Alba Spectrum Technologies is joint venture of several IT
and business consulting companies, now operating as single business entity. We have
local presence in the USA, LATAM & Brazil, Germany, South East Asia and Oceania. We
believe in the coexistence of Java (J2EE, EJB, Linux, Unix), Oracle and Microsoft
(.Net, C#, VB) platforms and systems and specialize in several product lines and
cross platform integration, customization, heterogeneous report design, plus we
provide ERP/CRM systems comparison and reviews, not being committed to just on MRP
platform. We also stake on XML cross-platform data interchange to be advanced in the
coming decade.

Alba Spectrum Technologies websites:
http://www.albaspectrum.com
http://www.ronix-systems.de
http://www.greatplains.com.mx
http://www.enterlogix.com.br


Web Site = http://www.albaspectrum.com

Contact Details = Alba Spectrum Group, USA/Canada: 866-528-0577, 1-630-961-5918,
Brazil: 55-11-3444-4949, Europe: +44 20 8123 2580, +45 36 96 55 20, Mexico:
52-55-535-04027, help@albaspectrum.com skype: albaspectrum

  • Printer Friendly Format
  • Back to previous page...
  • Back to home page...
  • Submit your press releases...
  •