Dynamic Database Table Creator Component

Name: Dynamic Database Table Creator Component

Author: Elisa Yu

Version: 1.0

Created: 07/2003

Purpose: This component is a nice illustration of how to use Pilot-Script to dynamically create database tables and populate them. The Dynamic Database Component will inspect the stream of records in a pipeline and gather all the needed information such as property names and property data types. With this information the component will, using Pilot-Script dynamically generate a SQL CREATE statement. Once this statement is generated, the SQL CREATE statement is executed against the database. Once the database table is generated, the streaming records are inserted into this table. Prior to this insertion, a SQL INSERT Statement is generated dynamically for each record in the data stream and subsequently executed.

Keyword: Dynamic, Database

Installation and Use: To use the Dynamic Database Table Creator Component, one needs to place it at the end of a pipeline in a protocol. In addition, the user needs to provide valid ODBC DSN, username, and password information.