D ATA S H E E T

Jaspersoft ETL | Data Integration for BI

Jaspersoft ETL (extract, transform, and load) powered by Talend is the most flexible,
powerful, and affordable open source tool for data integration requirements. Designed
to support one to many developers while scaling to the highest levels of data volumes
and process complexity. Developers can graphically design, schedule, and execute data
movements and transformations for business intelligence projects, such as loading an
Operational Data Store (ODS), Data Mart, or Data Warehouse.

When used with Jaspersoft Business Intelligence suite, Jaspersoft ETL enables
organizations to develop, manage, and document data integration processes for
improved reporting and analysis.

Because Jaspersoft ETL is open source-based, you get the best of both worlds: contribu-
tions and support from the worlds largest community of data integration developers
as well as commercial support, professional services and training from Jaspersoft

MAKE FASTER, BETTER BUSINESS ETL TECHNOLOGY HIGHLIGHTS AND BENEFITS

DECISIONS WITH JASPERSOFT ETL
Metadata driven Central repository stores all
Consolidate data sources into a central data warehouse
architecture project information
or data mart
Improve developer productivity with 450+ pre-built
Distributed Data is processed at location closest
components and connectors
Architecture to source maximizing compute
Business-oriented process modeling integrates business
and IT user collaboration resources & latency
Shared design environment consolidates job dependencies
and metadata Business Rules governer describes data path
Rules support and related dependencies
Built-in advanced components support slowly changing
dimensions, data lineage, and more
Change data Support slowly changing dimen-
Highly available platform ensures maximum uptime in
capture support sions with CDC
mission critical environments
Monitoring and management dashboard presents instant
view to all data integration jobs Eclipse GUI Wizards and pre-built components
based framework speed design process
Dynamic event triggered job model supports automation
requirements
Audit records provides qualitative and quantitative metrics
for job optimization
D ATA S H E E T

Why Jaspersoft ETL? Load Data into a data warehouse

There are compelling forces driving the requirements for ETL to be or data mart for analysis
used for Business Intelligence: In contrast to an ODS, for analysis purposes data marts and
data warehouses are optimized for query expressiveness and
Well over 50% of data integration projects are high performance against large volumes of both current and
implemented through manual coding primarily
historical data. Data marts and warehouses typically use a
because proprietary data integration tools are too
de-normalized star or snowflake schema approach to improve
expensive
query response times.
Data volumes and heterogeneity of databases and
applications continue to increase year-over-year,
Typically data warehouses combine data from across an entire
and this heightens the requirement for data integra-
enterprise over time. In contrast data marts are more specific to
tion tools to deliver high productivity in terms of
data integration development, run-time perfor- an application and focus on a particular subject or department.
mance, and scalability Jaspersoft ETL is suited for extracting, transforming, and loading
an ODS, data mart, or data warehouse. With 450+ connectors,
Compliance and audit requirements have increased,
mandating documented, easily maintained integra-
tions Jaspersoft ETL can extract data from just about any environ-
ment whether its an application such as SAP, Salesforce.com, or
Data integration is critical for any BI system to
improve the timeliness and quality of reporting and SugarCRM. Once connected to the source data, several complex
analysis transformations can be performed on the data to appropriately
load into a relational, analytic, or non-relation data store.

Load Data into an ODS for Reporting

With Jaspersoft ETL, multiple data sources can be consolidated
into a single operational data store (ODS). An ODS provides a
centralized location for reporting, and takes the processing load
away from mission-critical operational applications so that their
performance is not impacted by reporting users.

An ODS is not the same as a data warehouse. An ODS has only

current operational data while a data warehouse contains both
current and historical data.

Reporting tools such as JasperReports Server are data source

agnostic, and can report against data in either operational
systems, or an ODS, or in fact pretty much anywhere else.

Using a Data mart or Data warehouse for Analysis

Jaspersoft ETL at a Glance

Jaspersoft ETL comprises of three major application
components, the Business Modeler, Job Designer, and Metadata
Manager, all housed within an Eclipse and web based develop-
ment environment.
Loading Data into an
ODS for Reporting
D ATA S H E E T

Key Benefits: Collaborative Development

Jaspersoft ETLs shared metadata manager is designed to
Productivity: Using Jaspersoft ETL, it is much
easier to create, manage, and maintain your data consolidate all project information and metadata into a central-
integration processes. The intuitive graphical user ized repository within an industry-standard source manager (SVN).
interface provides a rapid learning curve with This promotes reusability of objects with object-level check-in and
minimal training. check-out. Users, roles, permissions, & privileges are managed
Affordability: In contrast to traditional data centrally through integration with LDAP-compliant systems.
integration tools Jaspersoft ETL is available through
a low-cost subscription, minimizing initial invest- Enterprise Capable Features
ment.
Jaspersoft ETL supports a series of automation features to
Flexibility: Jaspersoft ETL can process ETL and ELT
facilitate the development and implementation of complex
(extract, load, and transform) models, connect to
data integration jobs.
operational applications such as SAP, and using
web services.
Impact Analysis & Data Lineage
Scalability: With its distributed architecture
Helps users know the path followed by data through the
Jaspersoft ETL provides a scalable solution ideal
for small and medium size businesses, or for larger information system and the impact of a change on the data
enterprises. structure or transformation processes

Change Data Capture

Graphical Business Modeler & Job Designer Quickly identify and capture data that has been added to, updated
The Business Modeler leverages in, or removed from the database tables, making these changes
a top-down approach, allowing available to subscribers
line-of-business stakeholders to
get involved in the design of the Business Rules
integration processes. The Business rules let users incorporate JBoss Rules Governer (BRMS)
Business Modeler provides a for a centralized definition and administration of JBoss compliant
non-technical view of a business business rules
workflow. This typically includes both the systems and processes
already operating in the organization, and future needs. Project Auditing
Capture qualitative and quantitative metrics that are calculated
The Job Designer provides both a graphical and a functional against best practices to help optimize data integration projects
view of the actual integration processes.
Distant Run
The graphical palette of components and connectors, known as Remote execution of jobs on any server directly from the
the Component Library, drives the design of integration jobs with central repository
a simple drag-and-drop efficiency. Relationships can be defined
between components and properties. Most of these properties
Centralized Administrative Dashboard
are already inherited from the metadata.
Web based administration
The Component Library includes over 450 components and center offers a complete view
connectors, providing basic functions such as mappings, into all job processing with
transformations, lookups; specialized functions such as data instant visibility to perfor-
filtering, data multiplexing, or ELT; and support for all major mance and execution status.
RDBMS, file formats, and LDAP directories. The Component
Library can easily be extended using industry-standard
languages such as Perl, Java or SQL.
D ATA S H E E T

Job & Grid Conductor Subscription Services

Schedule execution of jobs based on time or event while automati- Jaspersoft offers annual subscriptions for the entire Jaspersoft
cally mapping to available execution servers. Each job can be dis- Business Intelligence Suite. Subscriptions include high value items
tributed across a grid of servers for optimal use of server resources such as:

Distant Run Commercial platform support

Advanced features
Enable remote execution of jobs on specified systems for testing
Technical Support up to 7x24
jobs on a stage box or configuration or for simply running jobs upon Indemnification
request on specific systems Training
Commercial License grant
Activity Monitoring Advanced product documentation
Provides real-time gauges and status indicators of job execution Jaspersoft newsletters
Access to the Customer Portal
status and performance.

Open Approach Professional Services

Proprietary tools are truly proprietary: a black box which hides New ETL and Business Intelligence users can receive direct
back-end processes. Jaspersoft ETL is open source-based, and assistance from Jaspersoft Professional Services, and consultants
you can access, modify and extend the source code if you wish. can work directly with you to evaluate your needs and help you
Also traditional tools use proprietary transformation engines and develop optimal ETL, analysis, and reporting solutions. Also, if you
languages. In contrast Jaspersoft ETL generates open Perl, Java, are migrating to JasperReports Server, Jaspersoft OLAP, or Jaspersoft
and SQL code that is executed by industry-standard engines ETL, Jaspersoft consultants are ready to help architect and imple-
ment the most efficient solution for your organization.

Simple, Affordable Pricing

Traditional ETL tools have complex and expensive pricing
versus Jaspersoft ETLs simple pricing model. Traditional tools
may sometimes look affordable initially, but they often charge by Contact Jaspersoft Today
a combination of CPUs, platforms, developers, connectors, and For information about Jaspersoft partnerships,
data processed. In contrast Jaspersoft ETL pricing is based upon OEM licensing, products, support, or services offerings:
the number of ETL developer seats. Run Jaspersoft ETL on as many
CPUs and servers as you like, and business application and RDBMS Jaspersoft Headquarters:
connectors are included at no extra cost. Jaspersoft ETL delivers by 539 Bryant Street, Suite 100
far the lowest total cost of ownership in the ETL market, making it San Francisco, CA 94107, USA
affordable yet powerful for companies of all sizes. phone: +1 888.399.2199 or +1 415.348.2380
Email: [email protected]

Minimum Requirements Jaspersoft Europe, Middle-East, Africa:

Digital Court,
Jaspersoft ETL has few external dependencies: Rainsford Street, The Digital Hub
Java JDK 1.5 or higher Dublin 8, Ireland
Phone: +353 1 443 4700
Windows 2000, Windows, XP, or Windows Server 2003
Email: [email protected]
Red Hat, Ubuntu, SuSE and other leading distributions
Jaspersoft Asia Pacific, Japan, Australia/NZ:
36th Floor, CRC Tower, All Seasons Place
87/2 Wireless Rd., Lumpini, Phatumwan
Copyright 2011 Jaspersoft Corporation. All rights reserved. Jaspersoft, the Jaspersoft logo, Jaspersoft
Business Intelligence Suite, Jaspersoft OLAP, JasperReports Server, Jaspersoft ETL, JasperReports Bangkok 10330 Thailand
Library, and iReport Designer are trademarks and/or registered trademarks of Jaspersoft Corporation
in the United States and in jurisdictions throughout the world. All other company and product names Phone: +66 2 625-3165
are or may be trade names or trademarks of their respective owners. Email: [email protected]