The Database layout Activity defines the procedure to insert, update, or delete data to and from a database table. It uses the predefined Database Info activity to connect to the database. With this, you can parse data from multiple tables within a particular database. You can insert or update data into multiple tables of a single database.
Prerequisites
- You must create Database Info activity before you create Database layout activity.
Steps to create Database layout
Go to Account and click Manage Objects.
- Click LAYOUTS > Database.
- Click CREATE Database Layout.
On Create Layout window, enter the name and description of the new Database Source in the Name and Description textboxes respectively.
Select the database info activity from the Select Database Info drop-down list or click the Create New button to create a new database info activity.
- To define schema definition, select one of the following options:
- Import XSD File
- Use Database Table
- To select the XSD file, which contains the schema information, select the Import XSD File radio button and then click the Browse button.
- To define a schema using database table, select the Use Database Table radio button and then click the Browse Tables button. The Select Schema screen is displayed with the list of RDBMS Schema in case of SQL Server and DB2 Database Info.
This action will show you the Select Schema screen that has the list of RDBMS Schemas, in case of SQL Server and DBO Database Info .