Solved

Oracle Issues.......

Posted on 2006-07-22
7
223 Views
Last Modified: 2010-04-23
I'm posting here instead of the Oracle DB area because I hope I can get an more honest unbiased opinion......... The company I work for uses Oracle CRM. Specifically, we are using the Telesales (I think thats what they call it) module (among others). We just had a meeting at corporate that I attended discussing the issues we are having using this clunky hard to use application. Has anyone in here had any experience with Oracle CRM? Comments please.... The IT group does not to want us to have direct access to the Oracle database (bypassing the CRM app). Knowing databases, I suspect we can solve some of our issues if we could get do some ad-hoc read only stuff with a direct connection to the database. Is the database schema so complicated that this would be impractical? Or am I correct, we could solve some issues? Based on what I have seen, surely people don't go to Oracle CRM because it works well and is fast. They are doing it to solve their IT resource issues and to have a very scalable application. Correct? I'll stop here for now. I hope this starts some discussion to help a frustrated IT professional.......
0
Comment
Question by:Misledman
  • 3
  • 3
7 Comments
 
LVL 8

Expert Comment

by:Shakti109
ID: 17160696

First, if there are problems with the data/getting it out, using it, interpreting it through -ANY- application, one of the first things you do is to go to the source, the database and ask -IT- what's going on.

It is very very easy to simply only allow connect/select access to the databases you need to get at.

OR, ask them to create a web service that contains the data access functions only allowing selects/etc and then use that via a very rudimentary application to pass in the SQL statements.

There is no schema that is SO complicated that you cant break it down into smaller chunks and get what you need from it. I've worked with terrabyte sized databases that had 200ish tables in them and while it took us a while to work backwards and figure out what the previous teams had done, within a couple of weeks we were mining the data just fine.

0
 
LVL 1

Author Comment

by:Misledman
ID: 17160839
I'm a fairly seasoned VB.NET/ASP.NET programmer.  I access SQL Server databases all the time. I've never connected to an Oracle DB, but I'm sure there is no difference. I guess what I'm after is twofold: (1) Are we the only people that are having issues with Oracle CRM functionality and speed and (2) Assuming the CRM part of Oracle CRM is just an application that accesses/updates/reports on the Oracle database, then why can't we do some custom stuff that will circumvent the issues presented by the "CRM" part of Oracle. "Custom Stuff" meaning writing some simple ad-hoc very specific apps that access the database directly and return data/information we can use. I have this suspicion that management has gotten rid of the key IT people that could do what I am suggesting we do. The people running the Oracle CRM application are Oracle people that live and breath Oracle CRM and have no idea (or respect) for Microsoft (or other ) technologys that could circumvent some of the issues presented by Oracle. If you haven't figured out yet, I'm not impressed at all with the Oracle CRM functionality. Most of the people at the meeting I went to feel the exact same way I do.
0
 
LVL 8

Expert Comment

by:Shakti109
ID: 17161706


Some of the comments I heard at a previous engagement where a client was using Oracle CRM (but was moving to Siebel) were things like : "Oracle is good at database stuff, but for applications they just dont cut it". Reports taking minutes to generate (with relatively simple parameters), odd interface flow, and other complaints related to user-interface experience as well as application performance, the convoluted flow of setting up just about everything (approver permissions, merchant(s) administrator(s), enrollment, LOV's, etc, etc.)

There is no reason you can't "get at the data" in those tables outside of the CRM interface, my team did. It may take quite a while to dig through the series of joins and relations, but once you pick apart the sections that you want, it becomes simple enough to start mining for what you want/need.

0
Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

 
LVL 1

Author Comment

by:Misledman
ID: 17188656
What about editing data...... You said your team "mined" data. I am assuming your were just reading data. I want to actually replace certain functionality that is too clunky and slow. That would mean entering new transactions that I would want both my application and the native CRM app to be able to read. That's possible isn't it? Is the database THAT complex?
0
 
LVL 8

Accepted Solution

by:
Shakti109 earned 500 total points
ID: 17191917

While it is certainly possible for you to extend the database by creating new transactions that your application can then use (to replace/enhance existing functionality), I am not aware of a way to have the CRM application itself use those transactions.

0
 
LVL 1

Author Comment

by:Misledman
ID: 17194775
I think you may not have understood what I said.... Or maybe I don't understand...... I'm assuming that the Oracle CRM application is merely entering/editing/displaying records from an Oracle database. The "transactions" I speak of those same transactions the CRM is entering. Wouldn't it be possible, for example, to enter records into the database just as the CRM app does? If so, one could enter those records with a custom application. Assuming I'm right, the CRM app would never know about it. However, if entered properly, the CRM app COULD display the records entered by the custom app if so desired. Surely other companys are having the same issues (as you implied previously) and have created custom applications to get around these issues. Am I wrong? Right? Do you have any knowledge of such attempts to do what I am talking about?
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question