Setting up the repository

Before you start the setup, ensure that you have created these databases on your preferred database platform:

  • di_prd_repository
  • di_prd_staging

Multiple profiles are supported. To have a test or development environment you must create the databases. For example:

  • di_tst_repository
  • di_tst_staging

The DI Designer icon:

../images/image1.png

To set up the repository:

  1. Double-click the DI Designer icon.
  2. On the Tools menu select Repository > Connect .
  3. Click + in the dialog box to add a new repository.
  4. Select the Kettle Database Repository and click OK .
  5. Click New (Database connection).
  6. Specify your preferred type and connection settings.
  7. In the Advanced menu, clear these Identifiers check boxes:
    • Supports the Boolean data type
    • Supports the timestamp data type
  8. Click Test to verify and click OK.
  9. Specify a name and description for the repository.
  10. Click Create or Upgrade.
  11. Click Yes and confirm by clicking Yes again.
  12. Click Execute to run the required SQL statements.
    The tables where to store and to hold the information regarding your new repository are generated.
  13. To close the dialog box, click OK
  14. Click OK to close the Generation dialog box.
  15. Specify a password in the Repository dialog box. The default password for the Admin user name is admin .
  16. Select the Show this dialog at startup check box, to display this dialog box before login.
  17. Click OK to finish the installation.