oracle.odi.setup
Interface IMasterRepositorySetup

All Known Implementing Classes:

MasterRepositorySetupImpl

public interface IMasterRepositorySetup

This interface defines methods to create and upgrade an ODI Master Repository.

Field Summary

static int

MASTER_REPOSITORY_MAX_ID Master repository ID maximum value.

Method Summary

boolean

createMasterRepository(java.lang.String pMasterUrl, java.lang.String pMasterDriver, java.lang.String pMasterUsername, java.lang.String pMasterPassword, int pMasterRepositoryId, TechnologyName pMasterTechnology, boolean pOverwrite, AuthenticationConfiguration pAuthenticationConfiguration, PasswordStorageConfiguration pPasswordStorageConfiguration, IMassImportExportResource pMasterImportSource) Create an ODI master repository into the database specified by the given parameters.

void

upgradeMasterRepository(java.lang.String pMasterUrl, java.lang.String pMasterDriver, java.lang.String pMasterUsername, java.lang.String pMasterPassword, TechnologyName pMasterTechnology) Upgrade the master repository schema for the database specified by the given parameters.

Field Detail

MASTER_REPOSITORY_MAX_ID

static final int MASTER_REPOSITORY_MAX_ID

Master repository ID maximum value.

See Also:

Constant Field Values

Method Detail

createMasterRepository

boolean createMasterRepository(java.lang.String pMasterUrl,
                               java.lang.String pMasterDriver,
                               java.lang.String pMasterUsername,
                               java.lang.String pMasterPassword,
                               int pMasterRepositoryId,
                               TechnologyName pMasterTechnology,
                               boolean pOverwrite,
                               AuthenticationConfiguration pAuthenticationConfiguration,
                               PasswordStorageConfiguration pPasswordStorageConfiguration,
                               IMassImportExportResource pMasterImportSource)
                               throws RepositorySetupException

Create an ODI master repository into the database specified by the given parameters.

This method will create the tables for master repository in the database schema, and will initialize internal master repository configuration. According to the type of pAuthenticationConfiguration parameter it will also

• for StandaloneConfiguration create a default ODI user with the name 'SUPERVISOR' and with the password given in the Standalone Configuration. That ODI user will be granted SUPERVISOR privilege.
• for ExternalAuthenticationConfiguration grant the user with the given username with SUPERVISOR privilege.

That method return true if the repository has been created, and false in case a previous repository was found but invoker had asked to not overwrite any existing repository.

Parameters:

pMasterUrl - the url of the database where the master repository will be created

pMasterDriver - the JDBC driver name of the database

pMasterUsername - the username to connect to the database

pMasterPassword - the password to connect to the database

pMasterRepositoryId - the ID of the repository that will be created

pMasterTechnology - the technology of the database

pOverwrite - true to override an existing repository, false otherwise. Note that overwrite of a repository having a different version might fail. In this case please cleanup your database schema manually.

pAuthenticationConfiguration - the authentication configuration

pPasswordStorageConfiguration - the PasswordStorageConfiguration to use for this repository. If this parameter is null the one defined in the specified pMasterImportSource if any will be used otherwise the PasswordStorageConfiguration.InternalPasswordStorageConfiguration will be used.

pMasterImportSource - the location of master repository configuration to use. If this parameter is null the default configuration shipped with the product will be used.

Returns:

true if the repository has been created, false otherwise

Throws:

RepositorySetupException - if failed to create that Master Repository

RepositoryScriptsNotFoundException - if the script files can't be found

upgradeMasterRepository

void upgradeMasterRepository(java.lang.String pMasterUrl,
                             java.lang.String pMasterDriver,
                             java.lang.String pMasterUsername,
                             java.lang.String pMasterPassword,
                             TechnologyName pMasterTechnology)
                             throws RepositorySetupException

Upgrade the master repository schema for the database specified by the given parameters.

Parameters:

pMasterUrl - the url of the database where the master repository will be created

pMasterDriver - the JDBC driver name of the database

pMasterUsername - the username to connect to the database

pMasterPassword - the password to connect to the database

pMasterTechnology - the technology of the database

Throws:

RepositorySetupException - if failed to upgrade the given repository

NotRepositorySchemaException - if the database doesn't hold an ODI master repository schema

RepositoryScriptsNotFoundException - if the script files can't be found