Back to Index |

Using the Create Table wizard

BlueSky Integration Studio now offers an easy to use Create Table wizard so that you can quickly create tables in your database without ever leaving the software. The Create table wizard button is located in Mapping screen (dbl-click on the Join object). Many times it is necessary to create a resulting table from the columns of the input source objects. The create table wizard walks you through this necessary function and also automatically maps your input columns to your output columns for you on the fly!

For instance, say you have a job with multiple input sources and you want to output to a single table in SQL Server: MySqlServer (facts)

Before you even define the properties in the output object, MySqlServer (facts), you can simply dbl-click the Join object icon to go into the mapping screen, then click the Create Table Wizard button.

If you have multiple outputs, you can select the output object that you want to create a table for. If you only have one output object, simply click the Next button.

Next, fill in the database connection information and also supply the Table name that you want to create.

Now, simply drag and drop columns from your input source to the resulting ColumnLayout, or you can click on the input table name and use the Move All > button. The resulting output will remember how you mapped these columns and is able to automatically map the input columns to the output columns in the mapping screen for you!

You can also change the Column Order at any time.

Click the Generate CREATE TABLE button to automatically build your create table statement based on the ColumnLayout from the previous screen. At this point, you can also modify the statement, or add any database specific properties.

To create the table now, click the Execute Now button. This will connect to your database and automatically submit the create table statement to your database.

Options

You can choose to run this create table statement every time your job runs, as well as drop it. Sometimes it is a lot faster to drop and re-create a table when it is being completely rebuilt than to delete the data through a DELETE statement.

When you click the Finish button, you can choose to overwrite the output columns in the specified output object and to automatically map the input columns to the output columns as specified in this wizard.

That's it! When you click Finish you will be returned to the mapping window where your output columns are defined, and all of the input columns have been mapped automatically for you!

© 2003 - 2007 Relational Solutions, Inc. - All rights reserved