Page 1 of 1
TM1 data upload to Oracle DWH
Posted: Sun Feb 02, 2014 1:17 pm
by 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.
Re: TM1 data upload to Oracle DWH
Posted: Sun Feb 02, 2014 1:57 pm
by 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.
Re: TM1 data upload to Oracle DWH
Posted: Sun Feb 02, 2014 2:05 pm
by 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."
Re: TM1 data upload to Oracle DWH
Posted: Sun Feb 02, 2014 11:25 pm
by 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.