Solved

Oracle ODI - Is this an appropriate usage

Posted on 2014-10-31
7
577 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
Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

 

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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

A company’s centralized system that manages user data, security, and distributed resources is often a focus of criminal attention. Active Directory (AD) is no exception. In truth, it’s even more likely to be targeted due to the number of companies …
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

762 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