When you create a transport map and then associate the transport map with a database transport, you must specify a schema and then a table that you want to route data to. Selection of the table specifies where you want to store values from map variables you set using the Input tab. One of your tasks will be to associate the map variables with database table columns. This is the payload that will be stored on the enterprise system.
Assumptions
The following is assumed:
- You are familiar with Structured Query Language (SQL) and relational databases.
- A database transport has been created and is available on the node. If you want to learn more about transports and how the node uses them to deliver data, click Transports.
- The Workbench is started and you have logged on.
What's Inside