OBIEE Blog

SAP B1 is taking the momentum in getting ERP and MRP applications market share, especially for smaller firms as well as the subsidiaries of large corporation, where Oracle custom solutions or Oracle Financials eBusiness Suite are implemented, especially in Sales and CRM, Vendor management and EDI (Electronic Document Interchange), Oracle based B2B and B2C ecommerce and partner source web sites.  If you have some of these circumstances, you probably need SAP Business One to “talk” directly to Oracle application.  We understand that in large corporation you likely have strong IT department with Oracle programmers and PL/SQL developers, who are comfortable with importing and exporting data sets to and from Oracle EBS or custom database application, however we may expect some level of assistance from your side when you need to understand your options in one way or two way integration between Oracle and SAP BO.  This small publication is for you:

 

1.       SAP Business One integration options.  Here we assume that you would like to deploy native SAP B1 tools, prior to considering SB1 ISV third party add-ons.  SAP Business One Data Transfer Workbench is the first tool you should consider.  If you have SAP B1 functional consultants, serving your account, these people are typically trained in importing data, such as Sales Invoice, Customer (Business Partner), Item, Price Lists to SB1, especially if you could provide the sources in the form of Text CSV files.  Such method might seem to be too poorly automated, when you need ongoing daily or weekly integration from Oracle to SAP Business One.  For more sophisticated and automatic integrations we recommend ODBC based datasets (on the Data File selection step of data migration wizard).  We assume that you are on Microsoft SQL Server 2005 or 2000, in this case ODBC could be based on Microsoft SQL Server view, which in turn through Linked Server construction pulls data from Oracle database.  You can also create the package, which prepares the data export in Oracle prior to calling DTW in SB1

 

2.       SAP Business One SDK.  In SDK your SAP Business One VAR, if they have certified SB1 SDK developers could code integration for you, which is more flexible in comparison to SB1 Data Transfer Workbench.  SDK integration could be packages as Exe application, for example, and you could schedule its execution every night or call it from Oracle upon the event (when ecommerce transaction is complete in Oracle Applications, for example).  SB1 SDK can push and pull objects to and from SAP Business One and if you include both SAP BO SDK and Oracle integration libraries, you can create bidirectional integration between the two

 

3.       Pulling data from SAP Business One.  If you are OK with the option of deploying SAP Business One Data Transfer Workbench for moving transactions to SB1, then you can simply pull data from SAP Business One by connecting from Oracle application to Microsoft SQL Server SB1 company database, especially if you know how to parse and push data to Oracle.  To learn SB1 tables structure, you could just login SB1 company, select View System Information menu and open the object you would like to pull from SB1, Sales A/R Invoice, for example.  Place cursor on the field next to Customer and you will see on the left bottom part of the screen, that Customer ID is stored in OINV table and the field name is CardCode.  This should give you good idea on what to do next

 

4.       SAP Business One is often chosen as international subsidiary ERP application, as SB1 is localized in large spectrum of countries: Brazil, Canada, Europe, Russia, Mexico, Oceania, India, China.  If your company has Oracle implemented in US or Canadian headquarters, SB1 to Oracle integration might be valuable solution

Oracle and Microsoft Dynamics CRM integration is what you could expect in large corporation, acquiring smaller business, where IT infrastructure is built on Microsoft SQL Server and Windows platforms.  Microsoft CRM does Leads generation and Marketing campaigns, Sales Quotes and Orders, Products and Pricing, Service and Technician Scheduling job, Contract and Service Case time logging and management, Knowledge Base support and lifecycle and other important business processes.  You could expect several business scenarios, where Oracle needs to be integrated with Microsoft Dynamics CRM.  Let’s review some of them:

1.       Microsoft CRM as Sales Orders front end.  If you have your sales people in regional locations in USA or internationally, this is very good approach, as Microsoft Dynamics CRM is web application and could be launched from anywhere in the World, where you have internet connection.  Plus, if you deploy Microsoft CRM Outlook client, you can work with Local replica of your Microsoft CRM objects and transactions: leads, contacts, cases, contract lines, quote, orders, items, prices, etc.  Microsoft CRM Security architecture is very robust and flexible, no doubt it fits to large organization IT requirements and policies

2.       Oracle eBusiness Suite as Corporate Accounting, ERP and MRP, also known as Oracle Financials or Oracle Applications.  In large corporation Oracle EBS is popular as Corporate ERP.  Assuming that your organization acquires smaller firm with Microsoft CRM – it is natural next step to move your new subsidiary accounting to Oracle Applications.  Accounting business processes are typically straight forward and there is no challenge (or normal little efforts required) to redeploy it in Oracle Financials.  However, expecting revolution in overnight moving business processes from Microsoft CRM to Oracle is probably utopia.  We recommend you to do one step in the time and stick to evolution instead.  Evolution means slowly move your new branch to Oracle Ebusiness Suite, and keep Microsoft Dynamics CRM for several years by deploying custom gateway between Oracle and Microsoft CRM

3.       Microsoft CRM integration technologies.  In large corporation you typically see robust IT departments, and if you are UNIX or high end Linux environment, we expect you also to be strong in Oracle PL/SQL programming.  Your Oracle programmers are likely to be comfortable to provide ODBC connection for Microsoft CRM to integrate its object with Oracle Financials.  You may consider outsourcing Microsoft CRM SDK programming to Microsoft CRM Partner and Reseller

4.       Current Microsoft CRM version.  As we are writing these lines in February 2009, current version is 4.0.  Microsoft CRM upgrade typically happens more frequently in comparison to Oracle DB version upgrade, but in any case both Microsoft Dynamics CRM and Oracle are matured applications with certain commitment to programming and integration tools

Are you an oracle professionals and looking for job in this sector? Then the Internet can be the most viable as well as feasible solution for searching the desired job.

The oracle professionals recognize the achievement in the advanced skills of oracle as well as in intermediate. They demonstrate proficiency as well as receive recognition in management of implementing the oracle technology. The oracle programme is basically an online networking of business that is purely based upon the applications of oracle.

Oracle professionals increase efficiency, reach as well as the choice of the recruitment chain of supply. This is also considered as the online pool that caters to the needs as well as requirements of the IT industry in the most appropriate manner. There are ample jobs in oracle area and these professionals are in high demand all over the world.

Jobs in D2K

These professionals should have the expertise in key areas of PLSQL, PL-SQL and PL/SQL. These professionals generally play the role of programmer as well as the software engineer. They are considered as the solution provider of software as well as software vendors. They also undertake the offshore development of the technology software as well as the management techniques.

The oracle professionals are capable of doing jobs in oracle apps in the best possible way as they have advance knowledge in this field. They can easily develop different kinds of software that can be utilized through out the world.

There are scores of online jobs available for the oracle professionals that are lucrative packages of salary as well as incentives. Following are presented some of the valuable benefits attached with them:

The first and foremost benefit attached with the online jobs for the oracle professionals is that they can be done as per the convenience of the professionals. The fact of the matter is that they can be accessed 24/7 and this largely adds the factor of flexibility to a considerable extent.

The next benefit is that there are umpteen opportunities available on the Internet that are generally updated on a regular basis. This way, the oracle professionals can approach to the job profile that suits them in the most appropriate way.

Through internet, the oracle professionals can approach the clientele of different developed countries without any hassles.

So, what are you waiting for? Avail the services of internet and get your hand upon the best opportunity of oracle jobs so that you can get the lucrative salary packages as well as incentives.

There are hundreds, if not thousands, of high tech computer jobs open for those with Oracle expertise. The highly reputable and popular Oracle products are used by firms in every part of the globe. As a result, experts who can walk in the door ready to start work on Oracle and keep the applications running efficiently are in great demand.

Knowing what employers are looking for when they seek to hire for high tech Oracle computer jobs helps students or would-be students and job candidates prepare their skills. So, let’s take a look at a few of these Oracle jobs available now.

In Phoenix Arizona, for example, we found 58 Oracle related high tech computer job openings. Positions included Windows Administrator II and III, business analyst and Oracle developer, database management senior specialist for Oracle 10g, Oracle DBA and senior Oracle DBA, business applications analyst, clinical applications support, Cerner PathNet support analyst, Oracle / Java developer, and database manager, among many others.

The high tech Windows administrator computer jobs were both senior level position in a OneNeck Windows administration group. Requirements were ability to administrate a medium to large environment of Windows server without supervision. The primary focus of these positions was work on projects directed by the firm’s customer management team.

The employer seeking the business analyst and Oracle developer wants someone with high tech computer knowledge whose job skills include writing functional specifications, analysis of programming activities and excellent team and communication capabilities. The candidate for this Oracle job should have a strong technical background including business analysis. Development of Crystal reports experience is a plus as well. This employer specifies that the firm does not seek DBAs.

A senior level data base management position including 10g RAC specialization requires two years of Oracle 9g RAC experience and five years of Oracle DBA. This is not a full time permanent position, but rather a contract position for one month, with responsibility for decision making critical to the database architecture, as well as the control and deployment processes to implement and maintain 10G databases using RAC.

Oracle DBA jobs at the senior level are abundant, full time and contract. One, a six-month contract position that might be extended to as long as one year, is a three-day week job. The work will be at two locations fifty miles apart, working with data services of the firm’s clients.

A more entry-level Oracle DBA computer job is as part of a high tech team environment that supports engineering and MIS groups within the firm. This employee will focus her or his efforts on product and service support both internal and external. The specific functions of this high tech Oracle computer jobs include maintaining the database as well as its applications. Requirements include technical expertise and user interface capabilities. User support will be a part of the job tasks too. Knowledge to qualify for this Oracle job include Oracle database in a Sun environment. At least two years experience with Oracle DBA is a must.

Additionally, this employer is looking for someone with excellent communication skills, autonomy, top-notch phone skills and vendor troubleshooting capability.

To land the advertised Oracle applications business analyst position, the candidate would need experience with Oracle applications and Order management.

For the highly specialized clinical applications support job in the medical field, the candidate would need to be an registered nurse who also has clinical application support training as well as Cerner clinical applications help desk proficiency.

A global provider of business solutions and information technology is seeking a Cerner PathNet support analyst to support the clinical departments’ business needs for project execution and enhancement. Application support and maintenance is the primary job task. Problem resolution will include system functions, operations, reporting, input and output, and general operations. This analyst will install patches, install vendor fixes to problems, create ad hoc reports and extraction of data and on call troubleshooting and system support.

The person who lands this high tech Oracle computer job will have knowledge of service operations in an acute care environment, experience in clinical applications support, as well as Cerner Classic PathNet and hospital acute care experience.

Familiarity with Cerner Millennium Lab application, Oracle database tools and VMS or AIX operating systems are plusses. Strong problem solving and analytical skills as well as effective communication skills both written and verbal are required.

www.oraclejobs.com
Copyright 2007 KC Dynamics Inc

1. Borkur Steingrimsson posted a very well-written article “Running OBIEE on Linux” – http://www.rittmanmead.com/2009/12/13/running-the-obiee-administratiol-tool-on-unix-using-wine/

If you’re a Linux enthusiast – I think you will find it helpful and amusing (now you can say “yes” if someone asks whether they can run admin tool on Linux). It seems as there’re some potential licensing issues – but in general the community is excited.

2. Rnm1978 posted a link to Kevin McGinley’s CAF analysis and his own thoughts on CAF http://rnm1978.wordpress.com/2009/12/11/caf/

I must note that using CAF proved tougher than it seemed to be and not intuitive. Not only that – the lack of official Oracle support isn’t inspiring in using it in real environment. He has also posted a nice detailed write-up of the Presentation Services troubleshooting

3. I’ve finally started tweaking with Essbase. The stand-alone installation took me several attempts to make it perfect (all green) based on Tim Tow’s tutorial as well as Nico Gerard’s instructions.  So far working with sample apps and trying to import ragged hierarchies. I understand why people love the product – the UI is very clean – and many things make sense. I wonder if Integration Services would prevent some shops running Essbase exclusively not to migrate to OBIEE.

4. No update on OBIEE forum. But I’d like to invite anyone willing to collaborate to leave a comment. I suggest we start a google wave (let me know if you need an invite) to discuss which things should be in focus.  My google wave is andriy.yakushyn@googlewave.com  – please add me to your contacts and let’s get started.