Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Include Page
_This_Is_a_Draft
_This_Is_a_Draft
Anchor
top
top

Table of Contents

From Archetype

...

Section
Column
width25px

 

Column
width1000px
Code Block
languagebash
titleExample of filtered list of available archetypes
$ mvn archetype:generate | grep bradleysmithllc
768: remote -> org.bitbucket.bradleysmithllc.etlunit:etlunit-database-schema-archetype (-)
769: remote -> org.bitbucket.bradleysmithllc.etlunit:etlunit-feature-archetype (-)
770: remote -> org.bitbucket.bradleysmithllc.etlunit:etlunit-project-archetype (-)
771: remote -> org.bitbucket.bradleysmithllc.etlunit:feature-archetype (-)
772: remote -> org.bitbucket.bradleysmithllc.etlunit:project-archetype (-)
Column

 

Press <Ctrl>-C to end the command.

Next, list ALL archetypes from which you can select the one you want.

...

Your project has been generated.  There isn't much there yet.

Go to top

Generated POM

Below is a sample of the Maven generated POM.

...

Section
Column
width25px

 

Column
width200px

 

 

Folders generated by archetype:generate

Column
width250px

 

Basic layout before addition of database

Column
width250px

Basic layout after adding Informatica

EDW_EXTRACTS matches the name of an Informatica folder.

Column
 

Push to Bitbucket

You can follow steps to setting up a Bitbucket repository for your project on the Bitbucket Create a Repository page.

You may Go to top

Basic Configuration for Database

Example Using SQLServer Database

Create or Make Available the Database Schema

You can put the schema in your project or in another project and then make that project available by including its JAR file as a dependency in your project.

Example

Place a data definition file in a location named for the database.

Section
Column
width25px

 

Column

Image Added

Configure the database folder, the database name and the schema script in etlunit.json.

Section
Column
width25px

 

Column
width900px
Panel
bgColor#E0E6F8
titleColor#0B0B61
titleBGColor#CED8F6
titleetlunit.json

{

"install-features": ["database", "sql-server-database", "log-assertion"],

"features":

{

"database":

{

"database-definitions":

{

"edw":

{

"implementation-id": "sql-server",

"user-name": "user",

"password": "pwd",

"schema-scripts":

[

"EDW.SQL"

]

}

}

}

}

}

Column

 

  • "sql-server" implementation-id: The implementation-id corresponds to the folder in which the database folders are placed.
  • "edw" database-definition:  Corresponds to the folder bearing the database name.  This name will be used in the @Database annotations in ETLUnit tests.
  • "EDW.SQL" schema-script: Name of the file with the data definitions.

Push to Bitbucket

You can follow steps to setting up a Bitbucket repository for your project on the Bitbucket Create a Repository page.

You may also want to use a graphical user interface like SourceTree.

Go to top