Export CSV to MySQL using Pentaho Data Integration (PDI)
Video Rating: 5 / 5
Export CSV to MySQL using Pentaho Data Integration (PDI)
Video Rating: 5 / 5
Kurtis Cruzada, Pentaho Product Manager, demonstrates some of the new features and changes in Pentaho Report Designer version 3.6 and BI Server 3.5.2. Part 2 of 5.

É necessário executar os ficheiros start_hypersonic.bat e start-pentaho.bat, antes de configurar a base de dados no Pentaho Data Integration (conhecido anteriormente como Kettle). Para quem instalou a versão completa do Pentaho Enterprise Edition não é preciso fazer download do Pentaho Data Integration (aka Kettle), porque o mesmo foi instalado e está disponível na pasta ‘Pentaho Enterprise Edition/Design Tools’ do menu iniciar. Dados para efectuar a conexão à BD no Pentaho data integration: Connection Name: pentahoteste (pode ser qualquer coisa) Connection Type: Hypersonic Host Name: localhost Database Name: sampledata Port Number: 9001 User Name: pentaho_user Password: password ATENÇÃO: 1º tens que executar o start_hypersonic.bat e depois o start-pentaho.bat. Se fizeres ao contrário, não vais conseguir aceder à base de dados através do Pentaho Data Integration (aka Kettle).
Video Rating: 0 / 5
Quick demo of the new Pentaho Analyzer coming soon in Enterprise Edition.

Demo de las soluciones de Control de Mando (Dashboard) que ofrece Matrix CPM Solutions realizadas con las herramientas de Inteligencia de Negocios (BI) de código abierto (Open Source) de Pentaho. El demo muestra varias de las funcionalidades de Pentaho y su integración con otras herramientas como Liferay, Google Maps y FusionCharts entre otras.
Video Rating: 0 / 5

SANTA CLARA, Calif. — June 9, 2008
With Java CAPS 6, users are able to leverage existing and new IT investments to create an infrastructure that is more agile and better aligned with the needs of their organizations today. A lightweight and extensible platform, Java CAPS 6 lets users rapidly add and integrate components in a modular fashion. New enhancements to Java CAPS include: a modular Enterprise Service Bus (ESB) for rapidly coupling applications; advanced event processing and business process management capabilities and alignment with latest versions of the Sun GlassFish(TM) Enterprise Server and NetBeans(TM) Integrated Development Environment (IDE) software.
Organizations that are struggling to acquire and retain customers will benefit from Sun’s MDM suite because they will have a single view of their customer data across disparate systems. This can allow them to leverage information across their organizations, identify their most valuable customers, implement opportunities to cross-sell and up-sell products and help reduce operational costs. Sun’s MDM suite works across multiple industries, expanding the visibility of information and providing single “customer” views, whether the customer is a consumer, patient, citizen, subscriber or even another business.
“We are changing the way products are developed by collaborating with open source communities,” said Mark Herring, vice president of marketing, Software Infrastructure, Sun Microsystems. “Java CAPS 6 is a result of this effort and incorporates feedback received from community members, such as a modular and open platform and no vendor lock-in. We also addressed the needs of existing customers by offering easy ways to upgrade and backwards compatibility to previous versions.”
“Lock-in with any vendor is a top concern for us,” said Vince Blanchard, director of architecture and new technology, Medavie Blue Cross. “Sun’s implementation of the pluggable Java Business Integration (JBI) standard combined with its open source strategy within Open ESB and Java CAPS have addressed this concern for us.”
“By leveraging the large adoption of the open source community, Java CAPS and the underlying GlassFish runtime environment give us high performance, stability, high availability, and strong operational management facilities,” said Frank Lacroix, senior manager, Carrefour Group.
Additional information on key components of Java CAPS 6 includes:
Sun Java(TM) ESB Suite: Based on Open ESB and JBI, the Sun Java ESB Suite is a completely open and modular platform that enables the rapid creation of composite applications and connects with various components and protocols for a flexible SOA. Intelligent Event Processor (IEP): Offers the ability to identify trends and patterns in real-time, enabling organizations to address critical business issues and take corrective actions proactively. Business Process Management: Supports BPEL 2, includes new high availability and failover features, and provides monitoring processes through integration with IEP. GlassFish(TM) and NetBeans (IDE) Software Support: Incorporates the GlassFish Enterprise Server, using industry-leading interoperability with .NET and WSIT/Project Metro as well as the unified and pluggable NetBeans IDE software to provide greater control. Customers and Partners Ecosystem
Introduced in 2006, Java CAPS has been deployed by hundreds of global customers and more than 350 partners. Customers like Carrefour Group, Medavie Blue Cross, Travelers Indemnity Company, and State of South Dakota and organizations like Accenture, Wipro, TCS and Cognizant participated in Sun’s early access program, which tested the product in real-world environments. In addition, Sun works with third parties that offer solutions that augment the benefits of Java CAPS including: Layer 7 Technologies (service-level security and governance); Savvion (process modeling and human workflow); ILOG and Fair Isaac Corporation (business rules management); eviware (SOA testing); and Pentaho and JasperSoft (business intelligence).
Open ESB and Mural Communities
Sun is an active contributor to the Open ESB community, where it is enabling development and collaboration of next generation business integration technology. Recently launched, the Mural community attracts architects and developers interested in creating the next generation of data management technology, which leverages the NetBeans IDE software and the Open ESB communities.
Pricing Information
The Java CAPS 6 platform, ESB and MDM suites can be purchased on a subscription or perpetual licensing basis. Pricing depends on the type of license and the nature of support desired. For more information, visit: www.sun.com/soa.
About Sun Microsystems, Inc.
Sun Microsystems develops the technologies that power the global marketplace. Guided by a singular vision — “The Network is the Computer”(TM) — Sun drives network participation through shared innovation, community development and open source leadership. Sun can be found in more than 100 countries and on the Web at http://sun.com
Sun, Sun Microsystems, the Sun logo, Java, Sun Java Composite Application Suite, NetBeans, GlassFish, Sun GlassFish Enterprise Server and “The Network is the Computer” are trademarks or registered trademarks of Sun Microsystems, Inc. or its subsidiaries in the United States and other countries.
Shows how to access Google Analytics Data Export API using the Pentaho Data Integration (Kettle) Transformation available from www.cloud2land.com
Pentaho is the commercial open source alternative for business intelligence (BI). In this video, Will and Mike demo many of the applications Pentaho has developed using Google’s Web Toolkit (GWT), as well as showing how business users can access Google APIs using Pentaho, including Google Analytics and Google Docs.
Video Rating: 0 / 5
London, UK — April 27, 2010
Canonical today revealed strong software vendor support for the upcoming Ubuntu 10.04 LTS (Long-term Support) release for both server and desktop. Ubuntu 10.04 LTS, to be released on 29 April 2010, will ship with hundreds of open source applications available at install with many more open source and proprietary applications becoming available in the days and weeks following.
Long-term support versions of Ubuntu are released every two years and supported for three to five years on desktop and server respectively. Proven very popular with users as deployment platforms, LTS releases are therefore targeted by software vendors keen to deliver software to this rapidly growing Ubuntu user base. Ubuntu 10.04 LTS will see the distribution fully established at the core of the open source application universe and increasingly attractive to proprietary solutions with support from organisations such as Adobe, IBM, VMWare and more.
“A strong and varied ISV ecosystem is critical for Ubuntu to thrive and grow both on user’s desktops and in the world’s datacentres,” said Jane Silber, CEO, Canonical. “We expected Ubuntu 10.04 LTS to be popular with existing and prospective software partners, but response is fantastic. Users considering switching to Ubuntu or upgrading to 10.04 LTS will be encouraged by this industry support and reassured that they can use many of their favourite applications on what we are sure will become their favourite operating system.”
“Ubuntu’s user base continues to grow rapidly and it is important to Adobe® that Ubuntu users are able to enjoy the full Adobe Flash® experience,” said Anup Murarka, director for Technology Strategy and Partner Development, Flash Platform, Adobe. “We are working with Ubuntu and other partners to enable certification of Flash Player 10.1 for Linux on the Ubuntu 10.04 LTS release, an exciting release for Linux-based desktops and devices.â
âBoth the Likewise Open project and our enterprise business are growing exponentially and a key catalyst is our relationship with Ubuntu and its vibrant user community,â said Barry Crist, CEO, Likewise. âBy enabling Ubuntu 10.04 LTS users to quickly and easily integrate with networks on both desktops and servers, we support Ubuntu adoption in the enterprise.â
“Ubuntu Enterprise Cloud is already seeing considerable adoption across a range of industries as customers discover the benefits of private and hybrid cloud computing,” said Marten Mickos CEO, Eucalyptus. “As an LTS, the new Ubuntu Enterprise Cloud with Eucalyptus at its core will see this adoption accelerate.â
“Ubuntu is the most popular Linux distribution especially for desktop users and that makes it critical to our Linux support,” said Geoff Perlman, founder and CEO, REAL Software, makers of REAL Studio for Linux. “I’m confident that our Linux users will be supporting this important release for the software they have built with our development tool, REAL Studio.”
Vendors:
10gen
Accountz
Acquia
ActiveState
Alfresco
Arkeia
Bacula
Baidu
Beemaster ICP
Bluecherry
BonitaSoft
Boxee
Bricscad
Cloudera
Cloudkick
CodeWeavers
Colosa
Compiere
Corel
CyberLink
Cycle computing
Dimdim
EnterpriseDB
Eucalyptus Systems
eXo Platform
Fermat
Fluendo
Funambol
Gear6
Gluster, Inc.
Groundworks Open Source
Hanyi
Hippo B.V
Intalio
IBM
IDM Computer Solutions
JumpBox
Kaltura
KnowledgeTree
Liferay
LikeWise
Linux Game Publishing
Lucid Imagination
Magnolia
M/Gateway
Messaging Architects
Mindtouch
Mozilla
Mulesoft
NComputing
Northscale
Nuxeo
OpenBravo
OpenQRM
Optimum
Opscode
Pentaho
Puppet Labs
RabbitMQ
Real Networks
REAL Software
rSmart
rSmart
Safesquid
Scalr
SmartApp
Status.Net
SugarCRM
Terracotta Tech
Unitrends
Unison
Userful
Yahoo!
Volantis
Zarafa
Zend
ZenOSS Inc
Zimbra
Turnkey
The full list of Applications and Vendors is available at: http://www.ubuntu.com/news/ubuntu-10.04-for-software-vendors.
About Canonical
Canonical provides engineering, online and professional services to Ubuntu partners and customers worldwide. As the company behind the Ubuntu project, Canonical is committed to the production and support of Ubuntu â an ever-popular and fast-growing open-source operating system. It aims to ensure that Ubuntu is available to every organisation and individual on servers, desktops, laptops and netbooks.
Canonical partners with computer hardware manufacturers to certify Ubuntu, provides migration, deployment, support and training services to businesses, and offers online services direct to end users. Canonical also builds and maintains collaborative, open-source development tools to ensure that organisations and individuals can participate fully in innovations within the open-source community. For more information, please visit www.canonical.com.
Joseph Eckert, Baker Communications Group, 203-270-3711, canonical (at) bakercg (dot) com
###
Related Pentaho Press Releases

xml:lang=”en” lang=”en” xmlns=”http://www.w3.org/1999/xhtml”>
Levementum Announces Sweet âMigrate to Sugar 6 Programâ
Phoenix, AZ — September 22, 2010
Levementum, a leading reseller and implementation partner for SugarCRM, today announce three fixed-price offerings that enable current SugarCRM software users to move to the latest version of SugarCRM at a fixed price.
âThe new version of SugarCRM has dramatically improved functionality and usability,â said Douglas Guilbeau, Managing Director of Levementum. âAll customers must make it a priority to make the move to Sugar 6.”
The Migrate to Sugar 6 program is available for all users of SugarCRM version 4.5.1 or higher. The program allows customers to leverage the new features in Sugar 6, while keeping their legacy of data, users, security roles, teams, logic hooks and upgrade-safe customizations. Even in cases where previous customizations have not been implemented in an upgrade-safe manner, Levementum has a fixed price assessment and design review for these items, to ensure that these customizations are accounted for. Customer migrations usually can be accomplished within 1 to 3 business days.
âSugar 6 is the most intuitive, flexible and open CRM application on the market,â said Andy Dreisch, Vice President of Professional Services for SugarCRM. âLevementum has designed a powerful program to help customers benefit from Sugar 6 in an affordable and risk-free manner.â
Sugar 6 was released for general availability in July 2010. Since its release, it has received countless accolades and positive reviews, culminating with its award of the Information Week BOSSIE (Best of Open Source) in August 2010. The new version of the software not only delivers a new look and feel, it is also full of features that enhance the userâs experience. Here are some of the new features included in Sugar 6:
Sugar 6 delivers a clean, bold look with new buttons and icons that allow users to perform tasks more easily while increasing the information density of each screen. Simplified default views, inline filtering and one-click actions conform to the multitasking environment common to busy sales people.
Building upon its reputation as the most flexible CRM on the market, Sugar 6 empowers users with the ability to view and consume data and applications from nearly any source, thanks to the ultra-flexible Sugar 6 platform.
As a leader in open source, SugarCRM sets the bar in the business applications industry for offering users freedom and choice in deploying and managing their CRM. Sugar 6 is designed to run on any cloud service platform or on-premise operating system.
Additionally, the upgrade enables you to easily view and integrate information from social networks and data services such as Twitter, LinkedIn and Hooverâs inside of the SugarCRM user interface. SugarCRM also supports multiple operating systems and cloud platforms and a variety of mobile devices, and synchs with a number of common business applications, such as Microsoft Office.
“Existing SugarCRM users will find that the Levementum migration program is just what they need, as we take the risk and uncertainty out of that move by providing a migration offering that makes the costs clear before the project starts,â said Geoffrey Mobisson, Managing Director of Technology and Partnerships.
The Sugar 6 Migration program is available to all SugarCRM customers who are currently running version 4.5.1 or higher, Pricing and other information is available at http://www.levementum.com/sugar6. Or please contact us by phone at l (480) 320-2500, or email (sales(at)levementum(dot)com). In addition to the fixed price packaging, Levementum is including a Free two hour training session to enable customers to immediately take advantage of the power in Sugar6.
About Levementum
Levementum is a leading professional services firm focused on delivering world-class implementations of Open Source Enterprise Software, including ERP, CRM and Business Intelligence solutions. Our primary focus is on solving complex business problems, using open Source solutions. Levementum is a preferred implementation partner and system integrator for SugarCRM, Compiere, Magento, Mindtouch and Pentaho; supporting customers with locations worldwide out of its offices in Phoenix, New York, Atlanta, Portland, Green Bay and Sydney, Australia. For additional information, visit http://www.levementum.com, or call (1) 480 320-2500 in the North America, South America and EMEA, or call: +61 433 284 485 in Australia and Asia.
About SugarCRM
SugarCRM makes CRM Simple. As the world’s leading provider of open source customer relationship management (CRM) software, SugarCRM applications have been downloaded more than seven million times and currently serve over 600,000 end users in 80 languages. Over 6,000 customers have chosen SugarCRM’s On-Site and Cloud Computing services over proprietary alternatives. SugarCRM has been recognized for its customer success and product innovation by CRM Magazine, InfoWorld, Customer Interaction Solutions and Intelligent Enterprise.
For more information, call (408) 454-6900, (408) 454-6900, 1 87 SUGARCRM toll-free in the US, email contact(at)sugarcrm(dot)com, or visit http://www.sugarcrm.com.
# # #
Attachments
©Copyright 1997-2010, Vocus PRW Holdings, LLC.
Vocus, PRWeb and Publicity Wire are trademarks or registered trademarks of Vocus, Inc. or Vocus PRW Holdings, LLC.

London — June 13, 2007 -
Openads, the developer of a free, open source adserver designed for and used by publishers worldwide, secured a $ 5 million Series A financing led by Index Ventures, with participation from First Round Capital, Mangrove Capital Partners, and O’Reilly AlphaTech Ventures. The London-based company plans to use the funds to accelerate product development and expand its team.
Founded originally as a technology division within Unanimis, the UK’s leading digital advertising business, Openads is now incorporated as a standalone business. Investors Bernard Dalle and Saul Klein from Index Ventures, and Gerard Lopez from Mangrove Capital will join Damon Reeve from Unanimis on the Openads board of directors.
Openads allows publishers to have complete control of their advertising campaigns, offering sophisticated targeting, inventory optimization, rich media and inventory forecasting from a simple yet powerful interface. Openads also allows for integration with more than 30 leading ad networks worldwide. Embraced by more than 20,000 publishers across 140 countries in 20 languages, Openads powers more publishers than all competing solutions combined.
“Publishers are feeling pinched and need to improve their effective CPMs and we are providing a publisher based solution that is free, flexible and easy to use.” said Scott Switzer, Openads founder and community leader. “We are delighted that experienced firms such as Index and Mangrove decided to join us as partners, supporters and advisors as they have paved the road for successful ventures such as Skype, Spotrunner and MySQL.”
Popular Web sites such as Federated Media, Stardoll, and Sun are among those relying on Openads’ servers. “Open source has made an impact in market after market. How could we expect advertising to be otherwise,” adds Tim O’Reilly, publisher and Openads user. “Openads has quietly become a major player in the Web 2.0 ad scene via its open source adserver.”
“Openads’ success can be linked to the input and contribution of its users, a hallmark for widely-adopted open source projects, and that large, vibrant and global community is committed to guiding and supporting future releases,” said Bernard Dalle, general partner, Index Ventures. “For the ad industry, Openads is disrupting the market with a product that is so easy to use and a great alternative for publishers, regardless of size, sophistication, geography or language. No wonder they have secured more publishers than any other solution on the market today.”
About Openads
Openads offers the first free open source adserver product for publishers. The highly sophisticated and Openads adserver software gives site owners everything they need to generate revenue from their websites. Publishers get complete control of banners and campaigns along with a highly sophisticated tracking system for gathering statistics, all from the one simple screen interface. Openads was originally founded as a technology division of Unanimis, the leading UK digital advertising business, and incorporated as a stand alone company in June, 2007. The company is based in London and more information can be found on www.openads.com.
About Index Ventures
Index Ventures is a leading European venture capital firm active in technology venture investing since 1996. The firm is dedicated to helping top entrepreneurial teams in the Information Technology and Life Science sectors build their companies into market defining global leaders. The firm has offices in Geneva, London and Jersey and focuses its investment activity primarily on Europe and Israel. Investments include Skype (the pioneering communications company acquired by eBay); MySQL (the world’s most popular open source database); Zend (the company behind the PHP development language); Pentaho (the leader in open source business intelligence); Trolltech (provider of leading software for cross-platform application development on the desktop and for embedded Linux environments). For more information, please visit http://www.indexventures.com.
About Mangrove Capital Partners
Based in Luxembourg, Mangrove Capital Partners is committed to turning entrepreneurial visions into realities as a means to drive capital appreciation for investors. Mangrove’s hands-on philosophy in all areas of business and technological development is the cornerstone of the company’s investment strategy. The firm invests across Europe and was one of the early investors in Skype.
About Unanimis
Based in London, Unanimis is the UK’s leading digital advertising business. Unanimis offers internet advertisers the opportunity to maximise their return from advertising and web publishers a completely outsourced solution to delivering significant advertising revenue. Unanimis has been awarded the Number One UK Ad network 2007, NMA Marketing Services Guide, May 2007; and Top Ten listing in Real Business ‘Hot 100′ Fastest Growing UK Private Companies, Real Business, April, 2007. Further information about Unanimis is available at http://www.unanimis.co.uk.
###
Find More Pentaho Press Releases
Powered by CDN Rewrites
Recent Comments