Solved

Oracle ODI - Is this an appropriate usage

Posted on 2014-10-31
7
569 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
  • 3
  • 3
7 Comments
 
LVL 34

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 34

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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

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

You independent view was very helpful.
0
 
LVL 34

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to recover a database from a user managed backup
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

932 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now