I'll be at the UKOUG Business Analytics SIG on the 12th March Oracle City Office, if you have any questions about accelerating analytics. Get in touch.
I have added some more useful scripts under the database section.
I'm all booked up for the Gartner BI Summit 2015. Looking forward to seeing the winners and losers. Let's see what they say about Oracle :), come back here on the 9th, where I will share the information.
The other day, someone wanted to place some oracle tables into TimesTen DB for some testing, this is a great quick way: 1) Make sure you have a connection to your Oracle database in the TimesTen tnsfile, so I have the following in my tnsnames.ora in the following directory (/u01/app/oracle/product/TimesTen/tt1122/network/admin/samples) : MYDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = XXX) (PORT=1521)) (CONNECT_DATA = (SERVICE_NAME = live) ) ) 2) Set your environment TNS_ADMIN=/u01/app/oracle/product/TimesTen/tt1122/network/admin/samples Export TNS_ADMIN cd /u01/app/oracle/product/TimesTen/tt1122/ttoracle_home/instantclient_11_2 ./sqlplus read/only@mydb 3) Create a directory to place the files that will be generated for the import, and cd to the directory. 4) Run the following command: ttImportFromOracle –oraConn user/oracle@myoracle –tables my_small_tab –typeMap 2,1 –prefix tm1 myoracle = ip:port/service prefix = prefix for files generated. 5) Now we shall add the MYDB to the TimesTen settings: cd /u01/app/oracle/product/TimesTen/tt1122/info vi sys.odbc.ini Add the following to your Times Ten Store ours is called TT_AGGR_STORE [TT_AGGR_STORE] Driver=/u01/app/oracle/product/fmw/../TimesTen/tt1122/lib/libtten.so DataStore=/u01/app/oracle/product/fmw/../aggregate_store/tt_aggr_store LogDir=/u01/app/oracle/product/fmw/../aggregate_store/logs DatabaseCharacterSet=AL32UTF8 ConnectionCharacterSet=AL32UTF8 LogFileSize=1024 LogBufMB=1024 LogBufParallelism=16 Preallocate=0 PermSize=400000 TempSize=200000 MemoryLock=4 CkptFrequency=30 CkptLogVolume=0 CkptRate=20 PrivateCommands=1 RecoveryThreads=40 oraclenetservicename=MYDB 6) Restart TimesTen cd /sbin ./sysctl -p ttdaemonadmin -stop ttdaemonadmin -start 7) In the example below, we are doing the table siebel.wc-KPI_F_041174 [oracle@CIMAlyticsSrv1 TT_INSTALLERS]$ ./ttImportFromOracle -oraConn firstname.lastname@example.org:1521/live -tables siebel.wc_KPI_F_041174 -typeMap 2,1 -prefix ncmp1 Beginning processing Resolving any tablename wildcards Eliminating any duplicate tables Getting metadata from source Generating database user list Assigning TimesTen datatypes Analyzing source tables Analyzing table 'SIEBEL.WC_KPI_F_041174' ... Estimating table sizes Evaluating parallel data load Generating output files Finished processing 8) The following files will be generated: ncmp1CreateUsers.sql ncmp1CreateTables.sql ncmp1LoadData.sql ncmp1CreateIndexes.sql ncmp1UpdateStats.sql 9) Connect to your TimesTen DB and the run the above sql files in the order above: [oracle@CIMAlyticsSrv1 bin]$ ttisql -connstr "dsn=TT_AGGR_STORE;uid=user;pwd=password;oraclepwd=opassword" **the opassword is the password to your oracle instance Command> @/home/oracle/TT_INSTALLERS/ncmp1CreateUsers.sql … ..
Recently I had to move the OBIEE RCU Database, click here
At the Oracle Business Analytics summit in London, come to track 1 and hear us talk about how we drive the business using analytics. Great presentation by Andrew Strauss on how the England cricket team used analytics to analyse the strengths of the team and work on these strengths.
Make sure you have registered to this year's event, where I'm sure there will be some in memory analytics discussions: Oracle BI Summit 2015