To create feeds with Mashup Center from enterprise databases you have two options. You can use the enterprise database (JDBC) feed generator or the data objects feed generator. The feed generator that you choose depends on the complexity of the SQL query and the relationships of the database tables and data objects that you want to capture in your feed.
Enterprise database (JDBC) feed generator
The enterprise database feed includes an SQL query window where you can specify the tables and columns to construct a basic SQL query. You can also use an Advanced field to type the SQL statement. The complexity of the SQL statement can depend on how the tables in the database are related to each other. You might need to build an SQL statement that joins tables that based on the primary and foreign keys. After you create the feed, you might need to create a data mashup and use the Transform operator to structure the hierarchy of the output.
The enterprise database feed supports several databases. See Configuring MashupHub for enterprise database feeds
for the list.
Data objects feed generator
With the data objects feed generator, you provide the data object model file for the database. The data object model file captures the relationships between the tables in the database. Using the relationship information, the data object feed generator generates the underlying relational joins to retrieve related information scattered across multiple tables. The data objects feed generator is easier to use than the enterprise database feed generator, but might not be as flexible depending on the results that you want from the feed.
The data objects feed generator supports DB2® databases and Optim™ archives.
Parent topic: Creating and registering new feeds: imc3