TM1 data upload to Oracle DWH

[rbriegoos]

Can anyone tell me which rights in a DWH Oracle Schema are needed to upload data from TM1 with a TI process?
I am not a database expert, but assume/ hope that you do not need DBA rights to upload data.

[qml]

Depending on what exact SQL queries you want to run you will need one or more of the following privileges granted on the table(s) in question: INSERT, UPDATE, DELETE.

[declanr]

In my experience DBAs (understandably) don't like anyone who is not "a database expert" loading directly into the tables since there is too much room to mess things up.
You may be better off looking at providing an output from TM1 and then letting the DBAs initiate a "pull."

[macsir]

Dump your cube into CSV file and ask your DB Developer to use Oracle SQL loader to import it into Oracle. It should be pretty quick.