Solved

Oracle ODI - Is this an appropriate usage

Posted on 2014-10-31
7
579 Views
Last Modified: 2014-11-08
Hi,

I am recently working in a large organisation.
I am closely involved as the customer of a new Oracle database.  The project is a bit fraught and lacking definition.

There are about 12 lookup tables in the database that will need occasional user maintenance (i.e. add/modify/delete).

The supplier of the software is suggesting that the maintenance of these tables is done via ODI.
I think I dis-agree!
Sure the maintenance of these tables should be done via a purpose built user screen/form.

Example: The user may need to change the spelling of a city.

QUESTION: Is is valid/normal to maintain such basic reference data via ODI?  Or is it just a lazy approach?
0
Comment
Question by:Patrick O'Dea
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
7 Comments
 
LVL 35

Expert Comment

by:johnsone
ID: 40415779
For software that you are paying for, not acceptable.

Especially if they are selling you the Oracle licenses, there are (or at least there used to be) specific licenses available only through partners and you would be violating the license if you used it this way.  The license stated that you could only use the application to access the database, no direct back end access.

If this is software you are paying for, then if a user needs to do something, the software needs to supply an interface to be able to do it.

For a lot of internally developed software, these types of updates we handled through batch update scripts.  Some things we just don't want users to have access to change.
0
 

Author Comment

by:Patrick O'Dea
ID: 40416269
Thanks Johnsone,

Can I clarify something please.
The license stated that you could only use the application to access the database, no direct back end access.

I don't understand this statement.
Surely the nature of an ODI is that it will directly WRITE to the back end database??


In my application the ODI is being used for 2 things;
(1)  inserting thousands of over night transactions (sounds okay)
(2) making simple changes to single records (e.g. name or address) (This bit is the lazy bit)
0
 
LVL 35

Accepted Solution

by:
johnsone earned 500 total points
ID: 40416321
By no direct access we are talking things where you can write SQL statements directly against the data.  Without going through some sort of application.  Depends on your license.  If you have standard licenses, not a problem.  I forget what the specialized ones were called, and they were only available from partners, not directly from Oracle.
0
Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

 

Author Comment

by:Patrick O'Dea
ID: 40427997
Thanks Johnsone,

You independent view was very helpful.
0
 
LVL 35

Expert Comment

by:johnsone
ID: 40428110
I really don't think that accepting your own comment is the appropriate way to close this.
0
 

Author Comment

by:Patrick O'Dea
ID: 40430145
Thanks for assistance.
I made an error when closing the query.

My apologies.
0

Featured Post

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

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

Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

688 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