In the demo below, a mashup application directly accesses a SnapLogic Pipeline configured to provide database-query results as a data service. In this example, the service returns nearly 50,000 records from a 10 MB database listing the mailing addresses of U.S. public schools.

The mashup displays a "sliding window" a few of those addresses as a time. When you click on one of the addresses, the other half of the mashup maps the address using Google Maps.

Try This

Use the slider on the right side of the address window to scroll through the list of names. You'll see that mashup retrieves only the records needed to populate the table. Note that at the bottom of the table you're accessing the last elements of a query that resulted in over 48 thousand records for the full data set (or the total number of records in a particular State).

Also notice that the State column is a hyperlink. When you click on the abbreviation for a state (e.g., CA), you will access a new data set that includes only that state's records, which now list each school's Zip Code. In this view, the Zip Code is also a link that lets you access a different data set that also includes the phone number.

Scroll the address record window up and down over the lists of name. You'll see that mashup retrieves only the records needed to populate the table.

Click on a row. Notice that the Google widget maps the location.

Click on a state's abbreviation. Notice that the grid now lists only records for that state.

Click on a ZIP Code. Notice that the grid now lists only records for that Zip Code.

Click on a school name. Google maps its location.

This linked views of data were created without any JavaScript coding. All this data is being provided from a live SnapLogic data service. The SnapLogic Dojo datastore queries the data service, then loads data direcdtly into the grid.

Why Is This a Big Deal?

For enterprise mashups and RIAs to really take off, they must be able to efficiently manage access to large amounts of data: not 10 customer records, but hundreds, thousands, or even millions of records, and data services are the way to do that. Being able to drill down into the data and explore it using a simple RESTful interface makes your applications simpler and higher performing.

The integration shown here—using the SnapLogic Live Data Framework and the Dojo Toolkit—makes this sort of integration as simple as writing a few lines of JavaScript.

The coding here is minimal: a few kilobytes. No complicated browser-side logic to manage data fetches in order to salvage performance. No CPU-killing inhalation of data that brings in-browser processing to a standstill.

Benefits

The benefits of the SnapLogic/Dojo solution include:

• Prompt access to vast amounts of data
• Minimal coding
• Minimal computational load in the browser
• Faster software development
• Re-usable components and re-usable data services
• Bottom line: Fast performance with minimal coding

Get SnapLogic today so you can begin your own Edge Integration development!

Want more information? Write to us a info@snaplogic.com.