Informatica being replaced by ODI in Oracle BI Apps 7.9.5.2

Oracle Data Integrator (ODI) Logo

In a long anticipated move among both Fusion Intelligence and Oracle BI Apps customers, Oracle has released the first versions of its packaged business intelligence solution that replaces the third party tools of previous versions (IBM DataStage or Informatica Power Center) with Oracle Data Integrator as the back end ETL tool. You can find detailed install and configuration instructions in the Oracle Business Intelligence Applications 7.9.5.2 Documentation Library.

 

It is important to note that this is a controlled availability release that mainly means the only data source supported is Oracle E-Business Suite 11.5.10, marts available in this release are:

 

  • Financial Analytics
  • HR Analytics
  • SCM and Order Managment Analytics
  • Procurement and Spend Analytics

Limitations notwithstanding, this is a key move that signals a long term strategy for BI Apps that will require customers and partners to develop additional skills and an important upgrade consideration for EBS customers. I personally hope that we will see Oracle implement Golden Gate at some point down the road in order to provide real time operational intelligence for a limited set of KPIs that lend themselves to be used in BAM applications.

Top WordPress Plugins – Social & Search

WordPress Logo

image_thumb2Plugins are small applications that enhance a specific set of functionality on the WordPress blog publishing platform. Today I will be presenting you with the top applications to help you improve the social media and search optimization features of your blog:

 

 

  • Google XML Sitemaps
    This plugin will generate a special XML sitemap which will help search engines to better index your blog. This is the optimal way for Google to index your site and the functionality is not available on the default WordPress distribution
    http://wordpress.org/plugins/google-sitemap-generator/

 

  • WordPress Social Sharing Optimization: Advanced SEO for Social Websites
    Display your content in the best possible way on Facebook, Google+, Twitter, Pinterest, etc. – no matter how your webpage is shared!
    https://wordpress.org/plugins/wpsso/

 

  • Shareaholic | share buttons & related posts
    Adds an attractive social bookmarking menu and related content widget to your posts, pages, index, or any combination of the three
    https://wordpress.org/plugins/shareaholic/

 

 

 

  • Share Buttons by AddToAny
    Share buttons for WordPress including AddToAny’s universal sharing button, Facebook, Twitter, Google+, Pinterest, StumbleUpon and many more
    https://wordpress.org/plugins/add-to-any/

 

 

  • SEO Friendly Images
    Allows you to configure how the plugin will add ALT and TITLE attributes to images to improve the SEO performance of each of the posts that the image is associeated with
    http://wordpress.org/plugins/seo-image/

 

 

You can search fo additional plugins online at: https://wordpress.org/plugins/browse/popular/

Ignacio de la Torre

Ignacio de la Torre

Ignacio de la Torre
I am a technophile based in San Francisco, in my current endeavors take me into the realms of big data, data science and information discovery. I am documenting my findings and experiences on this wild new frontier in the history of computing in this blog and always looking for  a conversation with those in the trenches that live and breathe the use case, send me an email to [email protected] and follow me on twitter at @binsights or LinkedIn at http://linkedin.com/in/idelatorre 

Top WordPress Plugins – Other

 

Plugins are small applications that enhance a specific set of functionality on the WordPress blog publishing platform. Today I will be presenting you with a few additional plug ins that I found interesting and that create provide very specfic functionality to your blog:

 

 

  • UpdraftPlus Backup and Restoration for WordPress
    Backup and restoration made easy. Complete backups; manual or scheduled (backup to S3, Dropbox, Google Drive, Rackspace, FTP, SFTP, email + others).
    https://wordpress.org/plugins/updraftplus/

 

 

 

 

 

  • Simple URLs
    Simple URLs is a complete URL management system that allows you create, manage, and track outbound links from your site by using custom post types and 301 redirects.
    http://wordpress.org/plugins/simple-urls/

 

 

You can search fo additional plugins online at: https://wordpress.org/plugins/browse/popular/

Sunopsis seven years after it’s acquisition

Oracle Data Integrator (ODI) Logo

Oracle Data IntegratorOn October of 2006 Oracle acquired Sunopsis a sofware company whose flagship product was one of the up-and-coming players in the datata warehousing arena. Sunopsis for easy integration in environments with multiple database systems and differentiated itself by adopting an Extract-Load-Transform architecture that decreased the learning curve for database developers that were immediately able to create transformation using familiar SQL syntax. By utilizing the computing power in the target database Sunopsis’ ELT architecture potentially decreased the need for additional computing power in a dedicated ETL server. Fast forward five years and Sunopsis is now Oracle Data Integrator, it is a key component of the Fusion Middleware Data Integration product line and it’s looking good, a few features that large enterprise customers will find interesting are:

  • SOA enabled an can deploy and consume web services for data transformation and integration
  • Integrates well into your data cleansing (names, addresses) and Master Data Management framework
  • Out of the box CDC functionality with a Publish-and-Subscribe model implemented either via triggers or log mining (Oracle and DB2)
  • As previously stated, by utilizing the source and target database’s computing power ODI decreases it Total Cost of Ownership (TCO)

It seems as if the merging of Oracle Warehouse Builder and Sunopsis’ functionalities has been beneficial to the end product and, in general, to the enterprise customer. Now it remains to be seen how aggressively Oracle”s sales force can take market share from ODI’s top competitors IBM Information Server and Informatica PowerCenter. Stay tunned for additional product reviews and, of course, OBIEE and Business Intelligence updates…

Oracle Partner Exchange Keynote

20120930-134923.jpg

It is very interesting to seat in a room filled with a large cloud, very representative of the Oracle Partner Ecosystem in its diversity and passion for the portfolio.

This unique partner ecosystem is definitively a key differentiator in Oracle’s go to market strategy.  

Key Topics:

* Fusion Applications

* Engineered Systems

* Big growth initiatives coming next year  

Fusion Applications

Fusion Apps is big this year, you can feel it in the air with many of the partners making the suite their key strategic offering this year.  

Engineered Systems

The message from Oracle is loud and clear: “do no replicate our cloud offerings and engineered systems, join us instead”.

Also, partners are called to join Oracle in evangelizing across the different channels and extend the reach of this engineered system offerings across their particular focus industries.  Growth initiatives With the engineered systems platform coming to its maturity stage and the big push this year for cloud offerings Oracle is asking partners to step up and go to market aggressively.

Mark’s key remarks regarding growth are additional investment from Oracle side’s on the sales force, the fact that the company’s owns a best of breed portfolio and… please do not compare Hanna with Exadata…  

New products

* Fusion Apps is a big push this year

* New Exadata configuration with 26 TB of storage (52 times the biggest Hanna configuration)

* Business applications, Analytics and many of the portfolio components now available on the cloud

Key Announcements by Larry Ellison @ the Open World Keynote

The key announcement from day one are out now and I am pretty sure there’s a bunch of unhappy people at SAP headquarters in Germany with the announcement of Exadata X3 which is 42 times larger the largest Hanna configuration.  

Key Announcements:

*) Oracle Cloud to offer Infrastructure as a Service   – Not conventional infrastructure (ROS, RVM, Compute Services, Storage Services) – All on engineered systems – All networked with Infiniband  

*) Oracle Private Cloud   – For organizations with strict compliance requirements such as banks and government institutions.  

*) Oracle Database 12c   – First multi-tenant database in the cloud – Being delivered in 2013 – A single instance of the database on shared hardware that allows for shared workloads – The support  

*) Exadata X3 26 TB of DRAM and Flash – Ability to have multiple databases stored in memory – Ultra-high performance   10X database compression – Store 220 TB in memory – Reduce storage costs by 10X   Infrastructure of the Oracle Cloud and Private Cloud – High Performance, Reliability, Security – Only pay for what you use  

Key nugget: One rack of Exadata is cheaper than a EMC Synnetrix VMAX 40K and it also comes with the database license.