Oracle Integration with Microsoft CRM - Overview for Developer by Boris Makushkin
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... 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.

Crystal Reports - Geterogeneus databases: SQL Server, Oracle, Unidata, Btrieve – Tips For Developer by Andrew Karasev
Crystal Reports is the most flexible tool on the market and it has market recognition. Multiple software vendors offer Crystal Reports as the main reporting tool: Microsoft, Best Software, Oracle to name a few. Sometimes developers try to use Crystal directly to pull data from multiple database... Use Distributed Queries – in the case of SQL Server - research the possibilities with OPENQUERY, OPENROWSET clauses to connect to non-SQL Server linked servers. ... Use professional tool, such as Microsoft SQL Server, where you can create linked servers to Oracle, Ctree, Btrieve, MS Access,...

Oracle E-Business Suite Customization & Integration: New Directions by Andrew Karasev
You probably have heard about the new directions of Oracle concern on Java and J2EE Technology. Oracle has announced the commitment with Java and also kept the “traditional development tools” community happy, promising they will continue to invest on them. ... But at the same time, Oracle recommends to their E-Business customers the following strategies (have a look at the Oracle Statement of Direction at http://www.oracle.com/technology/products/forms/pdf/10g/ToolsSOD.pdf): • Move from client-server to the Web • Upgrade to the latest versions • Interoperate with Java/J2EE • Develop...

Crystal Reports - Microsoft SQL Server by Andrew Karasev
Microsoft SQL Server is the leader for inexpensive and middle size SQL solutions. Plus it is now capable to serve large enterprise on Microsoft Windows platform. Crystal Reports is the most flexible tool on the market and it has market recognition. Multiple software vendors offer Crystal Reports... Use Distributed Queries – in the case of SQL Server - research the possibilities with OPENQUERY, OPENROWSET clauses to connect to non-SQL Server linked servers. ... Use professional tool, such as Microsoft SQL Server, where you can create linked servers to Oracle, Ctree, Btrieve, MS Access,...

Oracle E-Business Suite Outsourcing Notes by Andrew Karasev
Oracle Applications, in the eve of Oracle Fusion, is very efficient platform for being supported remotely, sometimes referred as offshore, nearshore or outsourced. The majority of Oracle E-Business clients have basic set of modules, also referred as Oracle Financials. ... Majority of Oracle reporting tools: Oracle Reports, Oracle Discoverer, Oracle XML Publisher, RXi Report, FSG Reports, Business Intelligence System are good candidates • Extension Development. ... As its name reads – it deals with international business practice and has to tune Oracle Applications to local or regional...

Oracle E-Business Customization a New Paradigm for Development by Andrew Karasev
If your company has Oracle E-Business Suite (Oracle Financials, Oracle Applications), it probably uses Oracle Forms and Reports to customize an E-Business module. These tools are based on event programming and a huge set of facilities to make the developer’s job easier. ... Pay attention at the last bullet we took from the Oracle Statement of Direction at http://www.oracle.com/technology/products/forms/pdf/10g/ToolsSOD.pdf: • Move from client-server to the Web • Upgrade to the latest versions • Interoperate with Java/J2EE • Develop new modules using JDeveloper If you are supposed to...

Oracle E-Business Suite: XML Publisher – Overview for Consultant by Andrew Karasev
Oracle Reports, Oracle E-Business Suite, Oracle Applications, Oracle XML Publisher In 2004, Oracle has delivered a new tool for developing reports on Oracle Applications. It was named Oracle XML Publisher and it is available within the technology stack of the E-Business suite (sometimes also... This is a powerful tool for building reports; the only thing that I am wondering is how it fits in with Oracle´s existing tool for reporting. ... Is it going to substitute Oracle Reports? ... Using this service, it is possible to send the output directly to an email address, to a printer, to a fax...

Oracle Development: JDeveloper 10G – Java, J2EE, EJB, MVC, XML - Overview For Programmer by Boris Makushkin
In 2004 Oracle, Inc. made its new step toward J2EE application development simplification, releasing new RAD Oracle JDeveloper 10G. First of all JDeveloper 10G is targeted to rapid web application building, utilizing all the achievements of J2EE World: web service, EJB, MVC frameworks, XML, etc. ... PL/SQL stored procedures development and testing, plus integration with major database platforms – Oracle, Sybase, MS SQL Server etc. ... Business Components Layer may be realized with various technologies - Java POJO, Oracle ADF Components, WebServices, EJB or Oracle TopLink Objects 7.

Brazil: Microsoft CRM Integration Scenarios by Andrew Karasev
Microsoft Dynamics CRM 3.0 should be considered as very flexible, programmable and customizable CRM application, really it is a heaven for Microsoft .Net and SQL developers. In this small article we will give you highlights on the integration techniques. ... You create linked server to Oracle database from your MS SQL Server, hosting Microsoft Dynamics CRM. ... Special credits should be given Microsoft SQL Server cross-platform integration options, such as Linked Server. ... When your sales people are traveling, they can not have permanent connection to your MS CRM web server.

Oracle E-Business Suite Development: New Technologies by Andrew Karasev
We have already talked about the importance of Java Technologies at “Oracle E-Business Suite Customization: New Directions”. Not only for Oracle Company itself, but also for the Oracle E-Business customers, whose investments must be preserved. Now we present tools and frameworks, you will use if... This standard should be followed by application server vendors, so a J2EE application would run on any J2EE application server complaint, like Oracle OC4J (OAS), IBM WebSphere, BEA WebLogic, JBoss, etc.