Solved

Oracle ODI - Is this an appropriate usage

Posted on 2014-10-31
7
576 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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 

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

From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

809 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