Oracle has integrated with Microsoft Business Solutions CRM to capture more market for SMEs. Some large company has Oracle based solutions for the entire business and Microsoft Business Solutions CRM is gaining its market share on the CRM market especially for mid segment market.
Suppose, you ship your goods all across the world and you do it in Oracle custom system for five years. In this case if you are looking low cost CRM solution you might still need integration between Oracle and CRM, because these are coming from different technology or software application.
If you are software developer – you should be informed about two solutions i.e. ‘MS SQL Linked Server approach – using ODBC driver to Oracle – create linked server in MS SQL Server 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’ and ‘Oracle Transparent Gateways and Generic Connectivity – these two will give you control from Oracle side. If you feel that you are more comfortable with Java or Oracle – this is the good way to go. Generic Connectivity gives you common solution to access database via ODBC and OLE DB mechanisms to FoxPro, Microsoft Access and other databases. 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:
1. Oracle Transparent Gateway for Informix available on Solaris, HP/UX
2. Oracle Transparent Gateway for MS SQL Server available on NT.
3. Oracle Transparent Gateway for Ingres available on Solaris, HP/UX
4. Oracle Transparent Gateway for Teradata available on Solaris, NT, HP/UX
5. Oracle Transparent Gateway for RMS available on Alpha OpenVMS
6. Oracle Transparent Gateway for RDB available on Alpha OpenVMS
7. Oracle Transparent Gateway for Sybase available on Solaris, HP/UX, NT, AIX, Tru64
The main disadvantage is the fact that these products are not platforms independents and priced relatively high.
Read business management books and definition of erp on enterprise resource planning and business management
