|You can create an Atom feed from an enterprise database query. Use SQL to query the database. The feed is created from the data that is returned in the query result set.
You can create an Atom feed from an enterprise database query. Use SQL to query the database. The feed is created from the data that is returned in the query result set.
Before you begin
For information about supported databases and setup requirements, see Configuring MashupHub for enterprise database feeds
About this task
To create a feed from an enterprise database:
- On the Home:Catalog page, click Create and select New Feed.
- Select Enterprise Database (JDBC) and click Next.
- In the Connection Profile field, select a database connection profile that is already known to MashupHub or select New to create a new profile.
Important: If you edit the connection profile, all feeds that use the profile are affected. Before you edit a profile, ensure that the database schema is the same and that no dependent feeds will be broken.
In the Database Type field, select the database type.
In the Connection Type field, select Driver Manager (Non-managed Connection) or JNDI (Managed Connection):
If you grant Edit permission for a database feed to another user, that user can change the profile, which will change the properties for all the feeds that use that profile.
- If you select a known profile, the remaining fields are automatically filled in.
- For a new connection profile, in the Connection Profile Name field, type the new profile name.
The fields that are displayed depend on the database and the connection type that you select.
- Driver Manager (Non-managed Connection): Connects to the database using the JDBC DriverManager interface. Connection management is not handled by WebSphere® Application Server, but through the API instead.
- In the Database Name field, type the database name that contains the tables from which to generate the feed.
For IMS™ databases, type the name of the IMS data store name.
In the Host field, type the hostname or IP address of the database server.
For Oracle, type the System ID (SID) in this field.
For IMS databases, type the name or IP address of the data store server (IMS Connect).
In the Port field, type the port number.
In the Username field, type the user ID that you use to connect to the database.
In the Password field, type the password that is associated with the user ID that you use to connect to the database.
For IMS databases only, in the Metadata URL field, type the URL for the location of the database view metadata class file. This metadata URL is case-sensitive. The metadata URL is the fully qualified name of the Java™ metadata class generated by the IMS Enterprise Suite DLIModel utility plug-in from the database source files that contain the database descriptions (DBDs) and program specification blocks (PSBs).
- For Derby, the default port is 1527.
- For DB2®, type the port number that your DB2 server listens on.
Tip: On Windows®, you can find the port number in the C:\\WINDOWS\\system32\\drivers\\etc\\services file.
- For IMS, type the required port number to be used to communicate with the TCP/IP server, IMS Connect.
The URL must be prefixed with class:// (for example, class://com.foo.BMP255DatabaseView).
JNDI (Managed Connection): Requires the specification of the JNDI name. With managed connections, a connection factory must have been defined by using the WebSphere Application Server Administrative console. This JNDI name needs to have been specified in the connection factory. The JNDI name is case-sensitive.
For more information about generating the metadata file for your database that can be used for Java applications to access IMS databases, see the IMS Enterprise Suite information in the IBM® Information Management Software for z/OS® Solutions Information Center.
Restriction: Only direct JNDI names are supported. With direct JNDI names, such as jdbc/myDataSource, the application server assigns default values to the resource reference data. Indirect JNDI names require the use of an assembly tool to define the resource references. They are not supported.
Select Display tables in SQL Query Builder if you want to select the tables and columns from the user interface in the next window. If the database has a large number of tables, clear this option to decrease the processing time required to display all the tables in the database. Instead of selecting the tables and columns in the user interface, you type the SQL statement.
Parent topic: Creating and registering new feeds: imc3
Choosing a feed generator for enterprise databases: imc3