Develop > Develop Content > Extend Content > IDE > IDE Basic Tasks > Generate Content Package

Generate Content Package

The IDE can generate the relevant schemas and ETLs that are required for the integration.

The ETL Generator generates the required artifacts based on the modeling in the previous steps. The artifacts contain ETL SQL scripts as well as the data models and stream configuration XML files that are imported into the Data Warehouse metadata repository. Once the metadata has been loaded, the schema generation mechanism performs the schema changes in the target and the staging databases.

ClosedTo access:

When a designer is open, the ETL button is displayed in the top right toolbar in the IDE workspace. If it is not displayed, navigate to Window > Customize Perspective and make sure BA IDE is selected.

Click to begin the ETL Generator.

ClosedContent Pack Creation Tool

The Content Pack Creation Tool enables you to create a new Content Pack structure using existing source content packs. This allows you to use the IDE to extend content as well as develop entirely new Content Packs for use in the Data Warehouse and ITBA.

The ETL Generator action is relevant to the selected designer. The ETL button is only displayed when a designer is open.

ClosedCreate a new entity and a new Content Pack with the ETL Generator

To create a new entity and a new Content Pack with the ETL Generator:

  1. Click in the toolbar on the top right of the IDE workspace to begin the ETL Generator. The ETL Generator dialog box opens.

  2. In the dialog box:

    • In BA ETL Version, select the relevant version.
    • In Content Type: select BA Content.

    • Select the Generate Content Pack check box if you are creating a new Content Pack (not existing content). This creates a new content pack structure along with the generated ETL files. This capability is only available when generating the ETL files in the Designer.

      Note The Generate Content Pack check box is not available when generating the ETL files from the Architect Target Designer.

      When you generate the ETL files from the Engineer Stream Designer, the Generate Content Pack check box is disabled if there are no source entities in the Engineer Stream Designer.

    • In Directory, browse to the directory where you want the generated Content Pack to be placed.

  3. Click OK. The process may take some time.

  4. Proceed to package and deploy your content.