DJExport Creates New Tables

Using DJExport to output records to a MySQL table resulted in the table being replaced with DDL from the DJExport object.

char(16) is the default field type for Process Designer.

This might not work in some environments because of restricted access rights that would prevent a data loading process from altering database objects. Also, the types would need to be kept in the VB code in Process Designer. Grants and indexes would also need to be created as part of the process.

There are 2 alternatives that come to mind that still are based on Process Designer.

1. DJX. Form a SQL insert statement from Process Variables containing the record to be written
2. Null Source Connector. Specify a target connector that is the MySQL table and a source of Null.

The Null source connector is appealing because it can also accommodate lookup functions. The target connector is set up as expected and will write out the looked-up values of a Process Variable. Set a ClearMapPut at the start of the transformation and use a prior Process Designer step to set it up.

This post is replicated from http://my.opera.com/walkerca/blog/2010/12/08/djexport-creates-new-tables.