Complete the following tasks to set up the database tables:
Switch to the Data Project Explorer view. This view is in the bottom left
pane of the toolkit panel. If this view is not present, open the Window menu, found on the toolbar at the top of the toolkit window, select
Show View and select Data Project Explorer.
Expand the DatabaseInput Data Design project.
Right-click dbinput_create_tables_db.sql where
db is db2 or oracle,
and select Run SQL.
Choose a connection to the database or create a new one
following the on-screen instructions, then click Finish.
Note:
When you create and access the DBINPUT_CUSTOMER and DBINPUT_EVENTS tables, be aware of the following issues:
When you run the script that creates the tables in the DBINPUT database, the user identifier from
which you run the script determines the database schema name. For example, if your user identifier
is USERID, the fully qualified name of the DBINPUT_CUSTOMER table is
USERID.DBINPUT_CUSTOMER.
When you set a node to access a table, if the node is not using the same user identifier to
access the database that you used when you created the database and table, include the schema name
in the integration node. For example, Database.USERID.DBINPUT_CUSTOMER.
The prebuilt ESQL used in this sample assumes the integration node is running as the same user as the tables
were created by and therefore do not specify a schema.