Some links to get started with some of the various vendor technologies that integrate with Hadoop.
Azure HDInsight with Hadoop 2
http://www.windowsazure.com/en-us/solutions/big-data/
PowerQuery for Excel 2010/2013-- connect to Hadoop
http://www.microsoft.com/en-us/download/details.aspx?id=39379
Try out SAP HANA
http://www.saphana.com/community/try
Try out SAP Lumira or use free at home
http://www.saphana.com/community/learn/solutions/sap-lumira
Hadoop on a VM
http://edataanalyst.com/2013/08/hands-on-hadoop-tutorial-with-hortonworks-sandbox-vm-part-1-the-boss-edition/
Some articles around Oracle & Hadoop & tying it all together
http://blog.gbrueckl.at/2013/11/sap-hanas-big-data-scenario-with-power-bi/
http://www.oracle.com/technetwork/database/bi-datawarehousing/twp-integrating-hadoop-data-with-or-130063.pdf
Oracle vs. Couchbase - from Oracle
http://www.oracle.com/technetwork/products/nosqldb/documentation/nosql-vs-couchbase-1961718.pdf
Oracle vs. Couchbase -from the Comparison Wiki
http://vschart.com/compare/oracle-coherence/vs/couchbase
Next Hadoop (THUG) meetup in Toronto with Don Pinto from Couchbase.
http://www.meetup.com/TorontoHUG/events/169706762/
Thursday, March 6, 2014
Tuesday, February 4, 2014
HANA Deep Dive
So you want to learn more about HANA? A couple places to start are from last year's deep dive sessions. Unfortunately I missed the pre-conference sessions at TechEd 2013. However, a lot of good tidbits were garnered from many other HANA sessions.
The TechEd sessions are here.
Watch the deep dives from HANA Distinguished Engineers.
Follow the Engineers on SCN.
Many of the SAP roadmaps are out and all roads lead to HANA.
SAP IQ Roadmap here.
Comparison between SAP IQ & HANA.
The TechEd sessions are here.
Watch the deep dives from HANA Distinguished Engineers.
Follow the Engineers on SCN.
Many of the SAP roadmaps are out and all roads lead to HANA.
SAP IQ Roadmap here.
Comparison between SAP IQ & HANA.
Thursday, October 3, 2013
Easy Service Marketplace
The SAP Service Marketplace web site is a monster of information overload, which seems to attest to the comprehensive amount of products and services available from SAP. The Product menu option has options for SAP ERP, CRM, PLM, SCM, SRM and more. SAP is known for its enterprise resource planning & customer relationship management, so you can probably figure out the first and second acronyms. Googling PLM seems to suggest something about pathetic little monkeys. SAP is a market leader in the supply-chain management segment. But whose to say SCM doesn't stand for Synchronous Channel Mixer or Sweetened Condensed Milk? There are at least 379 possible meanings to the SCM acronym.
And don't get me started on Flash and popups.
more breadcrumbs than an Italian bakery... and all I wanted was to order a CD!
Here are some acronyms from SAP, related to SAP and technology in general. I used to work with a customer who maintained a database of thousands of internal acronyms just to help people navigate their own jobs. Needless to say it was a large monopoly with thousands of employees, multiple purchasing systems, a web site with 100,000 pages, 47 unique customer identifiers, and 52 billing systems to bill them. I'm not sure how many people found that acronym database but it was like finding the Rosetta Stone for me.
One of my first exposures to SAP was bringing data from R/2 and other systems into SQL Server to provide an ASP.NET consolidated reporting site for stationery and office supply purchases. We found out for the customer that they could save over 1 million dollars a year just by ensuring their stationery cabinets were locked in August. That year the school system in Canada was short 1 million dollars in stationery...
A site I discovered to help navigate the SAP landscape and their acronyms is Easy Service Marketplace. It is a retro 90's-style no-frills version of the site with some useful links to some of the core marketplace offerings. It seems mainly to focus on the legacy aspects of SAP (no HANA info here) but some of the shortcuts are true gems.
If you think popups are for spammers, and breadcrumbs are something found in a salad, this site might be a refreshing trip back to 1995 to get fast access to SAP resources.
Or there's always the Wayback Machine. Ahhhh... Systemanalyse und Programmentwicklung... 1996 was a good year for you... The 1996 site map back then and today's map.
And don't get me started on Flash and popups.
more breadcrumbs than an Italian bakery... and all I wanted was to order a CD!
One of my first exposures to SAP was bringing data from R/2 and other systems into SQL Server to provide an ASP.NET consolidated reporting site for stationery and office supply purchases. We found out for the customer that they could save over 1 million dollars a year just by ensuring their stationery cabinets were locked in August. That year the school system in Canada was short 1 million dollars in stationery...
A site I discovered to help navigate the SAP landscape and their acronyms is Easy Service Marketplace. It is a retro 90's-style no-frills version of the site with some useful links to some of the core marketplace offerings. It seems mainly to focus on the legacy aspects of SAP (no HANA info here) but some of the shortcuts are true gems.
If you think popups are for spammers, and breadcrumbs are something found in a salad, this site might be a refreshing trip back to 1995 to get fast access to SAP resources.
Or there's always the Wayback Machine. Ahhhh... Systemanalyse und Programmentwicklung... 1996 was a good year for you... The 1996 site map back then and today's map.
Thursday, September 26, 2013
Intro to SAP Video
Dr. Bjarne Berg, co-author of SAP Hana: An Introduction provides an intro to SAP video.
HANA Training Video Step-by-Step: Tables, Views DataServices & BOBJ Explorer
Monday, September 16, 2013, 2:51 PM
Categories: Financials , Financials Reporting , IT , Performance , SCM , Project Management , CRM , CRM Reporting , BI-BW , Data Modeling , SAP BusinessObjects , BI BW Performance , BI BW Reporting , SAP BusinessObjects , SAP BusinessObjects Performance , Explorer , Project Management ,Financials , SCM , CRM
Wednesday, September 18, 2013
SAP Hana Memory Utilization
SAP has an enormous amount of products, suites, acquisitions, and technologies. SAP Hana seems to integrate with many of them as an underlying platform. Its key selling feature is a drop-in replacement or complimentary side-by-side install with existing database solutions, with a migration. Just tossing in SAP Hana doesn't provide the benefits that actually optimizing the application for Hana would, and could actually be like throwing a Ferarri in the water like a boat anchor, instead of stripping out the engine and dropping it in the boat.
Since SAP Hana is an in-memory database, and it uses gobs of memory, you should probably have some knowledge of how memory is allocated. More info on memory configuration in the Cookbook. If you're using Windows, Sysinternals RAMMAP is an invaluable resource for seeing what's going on with your memory. A primer for memory in Linux is here. AWS has some Cloudwatch scripts to monitor memory and disk usage.
If you miscalculate the RAM utilization, it sounds like out of memory errors could cause the platform to crash. In the case of Amazon AWS for Hana, the suggestion to fix here is "did you turn it off and on?" or add on some expensive solid state hardware.
Another tip with memory usage is that row tables need to fit completely into memory, while column tables can cache only their indexes or indexes + part of the tables for performance. Row tables could cause problems if you decide to use Hana like a legacy database rather than a columnstore one. Hana is an OLTAP database (Online Transactional & Analytical Processing).
Row vs. Column data source information here.
Since SAP Hana is an in-memory database, and it uses gobs of memory, you should probably have some knowledge of how memory is allocated. More info on memory configuration in the Cookbook. If you're using Windows, Sysinternals RAMMAP is an invaluable resource for seeing what's going on with your memory. A primer for memory in Linux is here. AWS has some Cloudwatch scripts to monitor memory and disk usage.
If you miscalculate the RAM utilization, it sounds like out of memory errors could cause the platform to crash. In the case of Amazon AWS for Hana, the suggestion to fix here is "did you turn it off and on?" or add on some expensive solid state hardware.
Another tip with memory usage is that row tables need to fit completely into memory, while column tables can cache only their indexes or indexes + part of the tables for performance. Row tables could cause problems if you decide to use Hana like a legacy database rather than a columnstore one. Hana is an OLTAP database (Online Transactional & Analytical Processing).
Row vs. Column data source information here.
Thursday, September 12, 2013
Microstrategy Achieves First BI Certification on Hana
Microstrategy achieves BI Certification on Hana.
Microstrategy is ahead of the game and integrates fully with Hana now.
SAP Hana Certification Pathways
Like most database or application suites, there are multiple paths for certification revolving around:
1. Installing, configuring, securing and maintaining.
2. Developing, modeling, optimizing, testing.
Further info on the 2 paths to Hana Certification is here.
1. Installing, configuring, securing and maintaining.
2. Developing, modeling, optimizing, testing.
Further info on the 2 paths to Hana Certification is here.
Subscribe to:
Comments (Atom)