Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 589
  • Last Modified:

Oracle ODI - Is this an appropriate usage

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
Patrick O'Dea
Asked:
Patrick O'Dea
  • 3
  • 3
1 Solution
 
johnsoneSenior Oracle DBACommented:
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
 
Patrick O'DeaAuthor Commented:
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
 
johnsoneSenior Oracle DBACommented:
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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
Patrick O'DeaAuthor Commented:
Thanks Johnsone,

You independent view was very helpful.
0
 
johnsoneSenior Oracle DBACommented:
I really don't think that accepting your own comment is the appropriate way to close this.
0
 
Patrick O'DeaAuthor Commented:
Thanks for assistance.
I made an error when closing the query.

My apologies.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now