Intalio|Mashup

Enterprise data integration made easy!


Enterprise Mashup Server

Intalio|Mashup is an application and data integration platform that allows both developers and business users to quickly and intuitively create enterprise mashups that unlock, integrate and transform information into consumable business assets.

Intalio|Mashup frees and connects locked up data wherever it can be found — frozen behind your firewall, or bound up in a far corner of the Web. It doesn’t matter if your data is not from SOA or Web 2.0-enabled sources, you can connect to and seamlessly link virtually any application, legacy system, database, Web service, or feed. Intalio|Mashup can even access and consolidate structured and unstructured content such as emails, Excel spreadsheets, and CSV files, as well as information contained in SQL databases, Web services, RSS feeds, and any Web-based data.

Intalio|Mashup

Sample Mashup multiple inputs and operations

With Intalio|Mashup, organizations can do more than integrate information from various internal and external sources — they can turn underused data into actionable services, feeds, and widgets that leverage information assets from across and beyond the enterprise — without any coding or manual programming required.


What is an Enterprise Mashup?

In simplest terms, a mashup is a way to grab data from multiple sources and combine it in new ways to create a powerful and flexible hybrid solution — a solution that’s much more than the sum of its bits. Using a mashup, you can combine internal company data of nearly any type, then mash it together with Web services, feeds, and just about any other outside information you can imagine.


What is an Intalio|Mashup?

It’s ROI — return on investment, return on infrastructure, return on information. It’s a way to get the most out of what you already have. It’s an enterprise mashup server that evolves right along with your business. It’s powerful, it’s quick, and it’s easy — without coding a single line or learning a complicated API, you can leverage both internal and external data without sacrificing security. No matter what your business is, it’s the answer you’ve been waiting for.

The Bottom Line is Integration

At Intalio, there’s one goal that guides the development and continual improvement of the Intalio|Mashup enterprise mashup server: easy and cost-effective data collection and integration. If Intalio|Mashup can help you bring data from inside and outside the enterprise together to boost your bottom line — without crippling and unnecessary expense — then we’re doing what we set out to do. In business, the bottom line is what it’s all about. And Intalio|Mashup is all about your bottom line.

Intalio|Mashup

Mashup of RSS Feeds and Yahoo Search


Bottom Line Ease

Attempting to integrate business data or simplify complex business processes with complicated tools might boost your bottom line — or it might not. One thing is certain, though: you’ll waste a lot of time and throw away a lot of money finding out. But Intalio|Mashup is so easy to use that you’ll quickly find yourself creating mashups to test new ways of doing business and new ways of integrating old data. No coding is required — just drag-drop-and-snap components together to create powerful business data mashups.


Bottom Line Speed

The most profitable companies are usually those that get to market first. Because Intalio|Mashup streamlines data integration and data-centric business processes, you’ll get to market while the competition is still figuring out what the market is. And your speed advantage just keeps getting bigger — reusable data sources and mashup components save you even more time and get you to your goals faster.


Bottom Line Extensibility

Got a mashup that was perfect when it was built but could now use a little extra oomph? With Intalio|Mashup, you don’t have to reinvent the wheel. Just tack components onto your existing application and get back to work. You can create add-on mashup components yourself or find them ready-made on Intalio|Exchange (to be released in Q3, 2009).


Bottom Line Savings

Bottom lines can benefit as much from lower costs as they can from increased sales. Intalio|Mashup enterprise mashups cut development costs, slash data integration costs, and clean up the everyday inefficiencies that cost your business time and money, while allowing you to implement new strategies or open new channels that will increase the top line.


Bottom Line Power

Leverage any kind of data no matter where it lives — internally or externally. Cut through the noise to find the data you need to move ahead quickly. Unlock frozen data and put it to work. Download Intalio|Mashup today and see what easy, powerful, and cost-effective data integration can do for your enterprise’s bottom line.

Intuitive Drag-and-Drop Interface

Intalio|Mashup features a visual browser-based “drag and drop” interface. Any user can combine data sources, perform complex operations, and design sophisticated transformations by simply dragging, dropping, and connecting the needed components with their mouse. Absolutely no hand coding, no technical savvy, and no extensive training are required.

100% Web-based
Launch your own Web browser and create & publish enterprise mashups right away (all major browsers supported).

Drag-and-Drop interface
Develop complex mashups visually and rapidly with Intalio|Mashup’s drag-and-drop interface. No coding is required.

Flexible Data Preview
All data returned by the mashup or exchanged by its component can be previewed using XML, tree, and data grid views.

Debugging
Mashups can be executed partially and display what information each component is receiving and producing.

Collaboration
Collaborate with other users on the creation and implementation of shared mashups.

Source Code Viewer
Get access to the underlying X# source code generated by mashups.


Wide Range of Connectors

Intalio|Mashup includes a complete suite of connectors that leverage standards-based interfaces to seamlessly link to a variety of information assets within and beyond the enterprise. Intalio|Mashup supports both structured data in business applications and databases — including sources that are not SOA or Web 2.0-enabled — as well as unstructured information — including e-mails and data from across the Internet.

View all Connectors


Flexible Publishing Options

Intalio|Mashup lets you publish mashups as SOA Web services that can be consumed by other applications, or as Web widgets for use in enterprise portals, websites, or through Web 2.0 and social media vehicles such as blogs, wikis, Facebook, or MySpace. Intalio|Mashup includes step-by-step wizards that take the guesswork out of creating and deploying Web services and widgets.

View all Publishing Options


Powerful Transformation Components

Intalio|Mashup includes an extensive portfolio of reusable components to explore, manipulate, and transform information. All components assist the user in choosing the right fields by exploring input data streams in a lazy manner. Components provide a pre-defined number of ports, but mashup developers can add additional ports with custom labels if necessary.

View all Components


Robust Repository

Intalio|Mashup is designed around a robust repository with advanced search capabilities, allowing users to quickly and easily locate deployed mashups, widgets, Web services, and other existing assets and components. In combination with Intalio|BPM, Intalio|Mashup can become the cornerstone of your service-oriented architecture (SOA).

Tags and Categories
In perfect Web 2.0 style, mashups can be tagged and categorized, and user-generated comments can be added to them.

Searching
Find mashups by name, tag, or descriptions.

Wide Database Support
Support for Apache Derby, IBM DB2, Ingres, Microsoft SQL Server, mySQL, Oracle, and PostgreSQL database backends.


Import, Export, Exchange

Intalio|Mashup lets you build mashups even more quickly by importing and exporting mashup components for reuse. Alternatively, you can import mashups created by other users and made available on Intalio|Exchange (Q3, 2009).

Upload support
Mashups can be uploaded and imported from the user’s local disk.

URL Import
Import complete mashups from URLs.

Mashup Exchange Import
Import complete mashups created by other developers from Intalio|Exchange.

Mashup Exchange Export
Export your mashups and download them to your computer, or sell them on Intalio|Exchange.

WSDL Import
Dynamic creation of mashups from WSDL files.


Reporting

Advanced reporting and charting capabilities that allow administrators to closely monitor system usage and performance.

Flexible Reporting
Generate tabular, summary, and matrix reports related to mashup usage and performance.

Charting
Generate 3D pie, line, bar, and area charts.

PDF Export
Export reports in PDF format.


Security and Governance

Intalio|Mashup leverages a comprehensive security infrastructure, including role-based access control, granular access levels, WS-Security support, and SSL encryption. Intalio|Mashup fully adheres to established security, compliance, and governance principles, therefore providing a solid foundation for your service oriented architecture (SOA).

Teams
Organize mashup users in different teams. Supports nesting teams.

Roles
Customizable user roles with user-defined read, write, delete, create, reassign, publish, and share permissions.

Granular Access Levels
Each mashup or component lets users set read, write, delete, reassign, and publish permissions to each user or team.

Sharing
Mashups can be temporarily or permanently shared with other users within the same platform.

Audit Trails
Complete audit trails stored in a robust meta-data repository.


Scalability

Intalio|Mashup can be deployed on multiple servers, and easily expanded to support an unlimited number of users.


Management Tools

Intalio|Mashup includes features to help system administrators and users optimize their use of the mashup platform.

Feed Reader
Allows exploring multiple RSS and Atom feeds. All feeds can be saved and organized in folders.

System Jobs
Manage system jobs. Schedule repeating system events using powerful recurrence rules.

Automatic Backups
Configure automatic backups of repositories.

Active Users Viewer
Display or disconnect active mashup users. Configure automatic inactive user disconnection rules.


Flexible Deployment

Intalio|Mashup is available for both on-demand, on-premises, and managed-on-premises deployment.

No Mashup Is an Island

The true power of mashups lies in their connectors, those bridges that turn remote, disconnected islands of data into an interconnected whole that easily shuttles data back and forth, and combines it in new and incredibly useful ways — no matter if the locals speak SQL or SOAP, or the backdrop is Excel or POP3. Of course, our connectors put your mashup components in touch with external SOA and Web 2.0 data sources, but Intalio|Mashup connectors are also your bidirectional bridges to private data stored in a wealth of data types, including:

SQL Databases
Read and write information from a wide variety of relational database servers, including Apache Derby, IBM DB2, Ingres, Microsoft SQL Server, mySQL, Oracle, and PostgreSQL. The SQL connector features a bi-directional interface, lazy data retrieval, and automatic database schema introspection.

Web Services
Consume SOAP and RESTful services using the Web services connector. This connector supports secure Web services implementing the WS-Security specification. A point-and-click WSDL (Web Services Definition Language) import wizard also lets you start using Web services in seconds, without having to write any code.

RSS and Atom
This connector allows you to retrieve information from RSS or Atom feeds. Intalio|CRM also includes a complete feed reader to quickly explore the feeds you need to work with.

HTML Web Clipping
All information available on the web can be accessed by Intalio|Mashup, even if it is inside HTML Web pages. Using this flexible connector, any static or dynamic HTML Web page can be used as a data source and integrated into your mashup. You can also use this connector to interact with dynamic sites that do not offer their content as SOAP/RESTful Web services or RSS feeds.

E-mail
Unstructured content such as e-mails can also be consumed or created with Intalio|Mashup. Using the e-mail connector, your mashups can retrieve data stored in e-mail bodies and even e-mail attachments from IMAP4 and POP3 servers, as well as send e-mail messages including attachments. For example, you could create a maship that e-mails its results as Excel attachments. The e-mail connector provides full support for SSL encryption and multiple authentication options.

File Retrieval
Unlike other integration platforms that can only utilize records from a database, Intalio|Mashup can also consume and manipulate plain files. Using this powerful connector, mashup users can rapidly retrieve any file, in any format, from local file systems, FTP/SFTP servers, HTTP/HTTPS sites, WebDAV folders, Windows shared folders (Samba), etc.

CSV
Using the CSV connector, mashups can read and create character-delimited files. This connector supports multiple file encodings, as well as lazy record parsing. Custom file encodings can also be used with this connector.

Excel
This connector lets you rescue information buried inside Excel documents, and integrate it with other data sources, or turn your Excel records into SOA assets. The Excel connector supports multiple worksheets, formulas, and all data types.

Zip/Unzip
Zip and Jar compressed files can be directly manipulated with this connector. With it, you can uncompress information stored in Zip files and use it immediately in your mashup without any external tools, compress your mashup-generated information, and publish a single Zip file for download.

DNS
This connector lets you perform DNS lookups quickly and easily.

Publishing Options

When Intalio|Mashup enterprise mashups offer so many alternatives for leveraging data in new ways, why should you be limited when it comes to publishing the results? Whether your business could benefit from flexible SOAP Web services, scalable and responsive RESTful services, portable and powerful widgets, or just a way to get your data back into Excel format, Intalio|Mashup makes it easy to publish your mashups in the way that works best for your organization.

Intalio|Mashup

Publishing Options


Data Services

Intalio|Mashup's Web service publishing options bring the very same easy-to-create, quick-to-implement connectivity to large-scale, globally networked operations as they do to simple file transfers behind your organization's firewall, all in a few point-and-click mouse operations.

Web Services
SOAP and RESTful Web services created with Intalio|Mashup feature automatically generated Web Services Definition Language (WSDL) files and WS-Security support, which enables you to set your own data protection policies.

RSS Feeds
Really Simple Syndication (RSS) is very simple with Intalio|Mashup — really. Just drag, drop, and publish your mashup as an RSS feed, then read the output using your favorite RSS reader, or the feed reader provided by Intalio|Office.

File Download
Need to export binary content generated by your mashup into an easy-to-download file? With Intalio|Mashup’s file download component, your answers are available anytime, anywhere — online and offline.

Excel
Want to download your mashup-generated information in Excel format? You can accomplish this by simply combining the Excel writer component and the File download service.


Embeddable Widgets

An Intalio|Mashup Widget is a little self-contained machine that does a single job — and does it very well, anywhere you want to use it. With widgets, you can add dynamic, graphical content to any sections of the Intalio|CRM application, as well as any Web page, blog, wiki, or enterprise portal, using components like these:

Chart Widget
This widget lets you display mashed-up data in real-time and in 3D, while leveraging a comprehensive collection of charts:

  • Pie
  • Area
  • Bar
  • Bubble
  • Candlestick
  • Column
  • High/Low — Open/Close
  • Line
  • Plot
Intalio|Mashup

Chart Widget

Data Grid Widget
Visualizing and organizing even the biggest data collections takes only seconds when using Intalio|Mashup’s AJAX-based grid widget.

Intalio|Mashup

Grid Widget

Yahoo! Maps Widget
With Intalio|Mashup's Yahoo! Maps widget, enterprises can generate maps based on mashup data, and update them on the fly using street names or geographic coordinates.

Intalio|Mashup

Map Widget

Data Combination Components

Union
Generates a new item set combining consecutively all items sets passed as inputs.

Merge
Generates a new item set by performing a direct product (Cartesian product) of the item sets passed as inputs.

Pairing
Generates a new item set where its n-th item is a tuple composed by the n-th item of each input item set.

Join
Combines all input items sets using a Merge operation, followed by a Filter operation and a Transform operation.


Filtering Components

Filter
Returns all items from the input item set that satisfy a specified condition (supports nested filters and XPath expressions).

Head
Returns the first n items of the input item set.

Tail
Returns the last n items of the input item set.

Drop
Discards the first n items of the input item set and returns the remaining items.

Unique
Removes duplicate items from the input item set determined by configurable criteria.


Ordering Components

Sort
Returns the input item set sorted by one or many fields (alphabetic or numeric ordering, ascending or descending).

Reverse
Returns the input item set in reverse order.


Item Transformation Components

Extract
Obtains a sub-item from each item in the input item set.

Transform
Transforms each item in the input item set. Item fields can be copied from source items or built using XPath expressions.


Dataset Manipulation Components

For Each
Iterates an input item set and executes a configurable subset of operations for each iterated item.

Grouping
Groups input items according to a configurable condition. For each group returns an item containing all items in it.

Aggregate
Calculates an aggregate operation on the input set. Returns a single item containing the result. Standard operations are count, average, min, max, summation, first, last, median, mode, standard deviation and variance. Custom operations can be created as well, using any language supported by the Java platform (Java, JavaScript, Perl, PHP, Python, Ruby, etc.)


Number Operations Components

Simple Math
Performs mathematical operations on integer or floating point numbers.


Date and Time Components

Current Date
Returns the current date and time.

Date Builder
Generates dates and durations.

Date Operation
Performs calendrical calculations on dates.


String Operations Components

Concatenate
Concatenates two or more strings received through the component ports.

Replace
Replaces all occurrences of a string with another.

Substring
Extracts a part of a string.

Tokenize
Splits a string into multiple tokens.

Regex Replace
Replaces all occurrences of a string using regular expressions.


Other Components

Input
Allows mashups to take input values from users or processes consuming it.

Constant Value
Specifies one or more static values that can be used by multiple components.

Custom Operation
Enables experienced programmers to create custom components using the X# XML-oriented programming language, or any language supported by the Java platform (Java, JavaScript, Perl, PHP, Python, Ruby, etc.).

Copyright © Intalio, 1999-2010.