Welcome to WebmasterWorld Guest from 220.127.116.11
I want to replace a spreadsheet with an Oracle database and a spreadsheet like read/write GUI, with graphical capability.
I thought an Oracle Forum may be the place to look but I do not know what I'm looking for (connectivity?).
I've found a file format called GraphML [graphml.graphdrawing.org] (which is only part of the problem) but I'm just as happy to do it non-web based.
PS. A science forum may useful too?
Basically they are set up as pivot tables querying the MS SQL database using OLAP. We can then massage the data any way we want, without having to change queries or involve IT.
I am no an expert on Oracle by any stretch of the imagination but I thought Oracle was OLAP compliant?
Is that going to acheive what you want?
Does this provide dynamic updates back to the MS-SQL database (and therefore relatively easily back to Oracle)?
Do you do updates back to the source?
You can use the standard pivot table refresh function (the bight red exclamation mark) which updates the data.
At my present company, we simply use the standard pivot table commands. At a previous company, that had thier developers put some VBA script in the front end to make it much prettier and easier. Depends on how many people are going to be using it I guess.
By allowing the data to be put into Excel, I can manipulate the data any way I want and do my own analysis without waiting for any IT involvement. This provides greater flexiability.
There is a heap of resource in TechNet, on the Excell Help and the Office Developer site.
Forgive my ignorance (and laziness) but can you lock the spreadsheet from column and row insertions and deletions and also sorting it into complete garbage, or do you have to rely on well educated users?
If you don't want people to change the look of the data, why not present it as an online (Internet or Intranet) style of report? Especially if the queries are static against the database.
....and then commits the tweaks (only) back to the Oracle database.
You've pointed me in right direction though so thanks very much for that.
PS. I've also considered xml'ing (or something else) to some product or other but have not found the product - there will be no new data - just changes to existing data - and no changes to formula. The original structure (from Oracle) can be locked during the time between creation and the updates coming back - so the mapping is one to one.