Extract(Read) > Transform(Test&Apply) > Load(Learn) Blog

April 24, 2009

Oracle Database Concepts Introduction Seminar

Filed under: Oracle Events — H.Tonguç Yılmaz @ 6:10 am

Attendance to this seminar will be free, it will be at İstanbul Yıldız Teknik Üniversitesi-Oditoryum room this Sunday and the targeted attenders are university students. Hüsnü Şensoy will also be our guest for a session on Oracle Data Mining and Data Warehousing Concepts. At the end of the seminar Hüsnü and I will be answering questions related to our summer internship program at Turkcell.

You can find more details of the seminar here.

April 14, 2009

Embedded Software License For Oracle Products

Filed under: Oracle How To — H.Tonguç Yılmaz @ 6:29 pm

Let’s say you are a product development company and you want to develop your products on Oracle technologies, but of course for a competitive product pricing strategy Oracle’s list prices may frighten you :)

Here is a solution you may get interested if you are a member of the Oracle PartnerNetwork; Embedded Software License(ESL). This is a very restrictive license type available for Independent Software Vendors(ISVs) who embed Oracle technology into their product which is available after 10g. With this option the end user you sell your product may not even be aware of Oracle technology behind and should not be able to access it directly as a developer nor an administrator.

You choose the Oracle edition and options you need for your product and then you receive %80 discount over their list price if your application gets accepted by Oracle. Also you only pay %19 for support over this discounted %20 amount. But is only pricing the main benefit here? No, I don’t think so; embedding an Oracle Database and/or Oracle Application Server directly into an application can make you very time-to-market if you already have team with Oracle development experience and lower your operational costs at long run.

Here is some more details of this Oracle’s very attractive licensing option but for much more information I advise you to contact to your local Oracle sales representative.

ps: this may be a helpful additional reading Oracle Product Family and Pricing Highlights

April 3, 2009

Getting Started and Extending your Knowledge with Oracle Warehouse Builder 11g

Filed under: Oracle Business Intelligence — H.Tonguç Yılmaz @ 1:08 pm

I already mentioned here and here that I love Apex and OWB since they are Oracle database integrated development environments, this is simply because I am an old school SQL and PL/SQL minded person and these two development environments make you feel more powerful, which is IMHO a really cool feeling during chatting with the Java/SOA guys :)

I have been using OWB 11g for some time now and I want to prepare a getting starting material to assist my colleagues. Apex has a two-days developer guide for this purpose, and OWB has its fantastic OTN OBEs.

If you are already aware of the BI fundamentals and Oracle database fundamentals you can go through these 16 11g OWB OBEs within a day or two and than I am pretty sure you will get the feeling I mentioned. As you may know with 11gR1 now OWB and Apex are a part of the standard database installation, so if you have a 11g installation you already have an OWB practice environment, following the first OBE will be enough to initialize your OWB inside your 11g installation.

These OBEs do not only include typical practices but also information on Warehouse Builder 11g architecture, components, BI concepts like Star Schema and Snowflake Schema or Slowly Changing Dimensions. Also here is an additional viewlet which may give you an idea about OWB. Remember what actions you do inside your mappings they will all deploy a standart PL/SQL package, these old friends are your ETL executables for your each BI need. And OWB is a cost-free(database-licence included) option and it is a highly optimized ETL tool which uses Oracle’s SQL capabilities.

And as some readers may be thinking since Oracle bought ODI OWB will be dead soon, no this not true and you may read the future strategy from OWB’s corporate blog here, to my understanding OWB and ODI will be a part of a combined BI solution strategy together, like a coffee and milk together, so this is not a coffee or a tea choise :)

The Rubric Theme. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 76 other followers