Service Data Integration
|
Data Mashups
Service Documentation
|
|
Data and Web Service Integration
Data Mashups provides a number of
tools to simplify integration and usage of web services and other data
for your mashup applications. These tools are part of the Online Visual Mashup Builder (AppliBuilder) provided with the
service. It
includes an embedded SQL database dedicated to each service
account. It provides tools for importing CSV and Excel files into
the SQL database. It provides a wizard for integrating SOAP web
services using WSDL definitions. And it provides tools for using
REST web services in your mashup applications.
Applications typically interact with data via one or more Datasource
objects. AppliBuilder users create Datasources to setup access to
specific data. For example, a datasource may provide access to a
specific SOAP web service, or a specific SQL prepared statement.
Dedicated Embedded SQL Database
Each service account holder gets a
dedicated embedded SQL database to store configuration and application
data for each account. Each application gets its own schema
within that database. Application and account information is
stored in common schemas used across applications.
Applications interact with the database via Datasource objects that
represent SQL prepared statements on the database. AppliBuilder users create these
Datasources to setup access to specific database tables or queries.
Please see the AppliBuilder documentation for more information on using the
dedicated database.
CSV/Excel Imports
Data Mashups provides a tool to
import CSV or Excel files into your dedicated SQL database. For
example, the service user can import a CSV or Excel file of data
to integrate this data with other application data or web service
data. Once the data is imported into the database, Datasource
objects can be created to access the data and use it in mashup
applications.
Please see the AppliBuilder
documentation for more information on using the CSV and Excel
import features.
Web Service Integration
The Data Mashups service provides a
SOAP Web services wizard to make it easy to integrate SOAP web services
into mashup applications. This wizard uses the web service WSDL
file to enable point and click integration of a web service operation,
and create a new datasource in AppliBuilder.
AppliBuilder provides support for
invoking and consuming REST web services from AppliBuilder scripts.
Please see the AppliBuilder documentation for more information on using web
services in your mashup applications.