oracle.odi.setup.support

Class MasterRepositorySetupImpl

java.lang.Object

oracle.odi.setup.support.MasterRepositorySetupImpl

All Implemented Interfaces:

IMasterRepositorySetup

public final class MasterRepositorySetupImpl
extends java.lang.Object
implements IMasterRepositorySetup

Default IMasterRepositorySetup implementation.

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	REPOSITORY_STATUS_INSTALL_FAILED
static java.lang.String	REPOSITORY_STATUS_OK
static java.lang.String	REPOSITORY_STATUS_UPGRADING

Fields inherited from interface oracle.odi.setup.IMasterRepositorySetup

MASTER_REPOSITORY_MAX_ID

Constructor Summary

Constructors

Constructor and Description
MasterRepositorySetupImpl()

Method Summary

Modifier and Type	Method and Description
boolean	createMasterRepository(JdbcProperties pMasterRepositoryJdbcProperties, java.lang.String pDbaUsername, char[] pDbaPassword, int pMasterRepositoryId, TechnologyName pMasterTechnology, boolean pOverwrite, AuthenticationConfiguration pAuthenticationConfiguration, PasswordStorageConfiguration pPasswordStorageConfiguration) Deprecated.
boolean	createMasterRepository(JdbcProperties pMasterRepositoryJdbcProperties, java.lang.String pDbaUsername, char[] pDbaPassword, int pMasterRepositoryId, TechnologyName pMasterTechnology, boolean pOverwrite, AuthenticationConfiguration pAuthenticationConfiguration, PasswordStorageConfiguration pPasswordStorageConfiguration, java.lang.String pRegistry) Deprecated.
boolean	createMasterRepository(JdbcProperties pMasterRepositoryJdbcProperties, java.lang.String pDbaUsername, char[] pDbaPassword, int pMasterRepositoryId, TechnologyName pMasterTechnology, boolean pOverwrite, AuthenticationConfiguration pAuthenticationConfiguration, PasswordStorageConfiguration pPasswordStorageConfiguration, java.lang.String pRegistry, CryptoAlgo pEncAlgo) Deprecated.
boolean	createMasterRepository(JdbcProperties pMasterRepositoryJdbcProperties, java.lang.String pDbaUsername, char[] pDbaPassword, TechnologyName pMasterTechnology, boolean pOverwrite, AuthenticationConfiguration pAuthenticationConfiguration, PasswordStorageConfiguration pPasswordStorageConfiguration)
boolean	createMasterRepository(JdbcProperties pMasterRepositoryJdbcProperties, java.lang.String pDbaUsername, char[] pDbaPassword, TechnologyName pMasterTechnology, boolean pOverwrite, AuthenticationConfiguration pAuthenticationConfiguration, PasswordStorageConfiguration pPasswordStorageConfiguration, CryptoAlgo pAlgo)
boolean	createMasterRepository(JdbcProperties pMasterRepositoryJdbcProperties, java.lang.String pDbaUsername, char[] pDbaPassword, TechnologyName pMasterTechnology, boolean pOverwrite, AuthenticationConfiguration pAuthenticationConfiguration, PasswordStorageConfiguration pPasswordStorageConfiguration, java.lang.String pRegistry)
boolean	createMasterRepository(JdbcProperties pMasterRepositoryJdbcProperties, java.lang.String pDbaUsername, char[] pDbaPassword, TechnologyName pMasterTechnology, boolean pOverwrite, AuthenticationConfiguration pAuthenticationConfiguration, PasswordStorageConfiguration pPasswordStorageConfiguration, java.lang.String pRegistry, CryptoAlgo pEncAlgo)
boolean	createMasterRepository(java.lang.String pMasterUrl, java.lang.String pMasterDriver, java.lang.String pMasterUsername, char[] pMasterPassword, int pMasterRepositoryId, TechnologyName pMasterTechnology, boolean pOverwrite, AuthenticationConfiguration pAuthenticationConfiguration, PasswordStorageConfiguration pPasswordStorageConfiguration, IMassImportExportResource pMasterImportSource) Deprecated.
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) Deprecated.
boolean	createMasterRepository(java.lang.String pMasterUrl, java.lang.String pMasterDriver, java.lang.String pMasterUsername, java.lang.String pMasterPassword, int pMasterRepositoryId, TechnologyName pMasterTechnology, java.lang.String pEditionName, boolean pOverwrite, AuthenticationConfiguration pAuthenticationConfiguration, PasswordStorageConfiguration pPasswordStorageConfiguration, IMassImportExportResource pMasterImportSource) Deprecated.
boolean	createMasterRepository(java.lang.String pMasterUrl, java.lang.String pMasterDriver, java.lang.String pMasterUsername, java.lang.String pMasterPassword, TechnologyName pMasterTechnology, boolean pOverwrite, AuthenticationConfiguration pAuthenticationConfiguration, PasswordStorageConfiguration pPasswordStorageConfiguration, IMassImportExportResource pMasterImportSource) Deprecated. Use the API in which password argument is of type character array (char[])
boolean	createMasterRepository(java.lang.String pMasterUrl, java.lang.String pMasterDriver, java.lang.String pMasterUsername, java.lang.String pMasterPassword, TechnologyName pMasterTechnology, java.lang.String pEditionName, boolean pOverwrite, AuthenticationConfiguration pAuthenticationConfiguration, PasswordStorageConfiguration pPasswordStorageConfiguration, IMassImportExportResource pMasterImportSource, CryptoAlgo pAlgo, java.util.Properties pProperties)
boolean	createMasterRepositoryFromExport(JdbcProperties pMasterRepositoryJdbcProperties, java.lang.String pDbaUsername, char[] pDbaPassword, int pMasterRepositoryId, TechnologyName pMasterTechnology, boolean pOverwrite, IMassImportExportResource pMasterImportSource) Deprecated.
boolean	createMasterRepositoryFromExport(JdbcProperties pMasterRepositoryJdbcProperties, java.lang.String pDbaUsername, char[] pDbaPassword, int pMasterRepositoryId, TechnologyName pMasterTechnology, boolean pOverwrite, IMassImportExportResource pMasterImportSource, java.lang.String pRegistry) Deprecated.
boolean	createMasterRepositoryFromExport(JdbcProperties pMasterRepositoryJdbcProperties, java.lang.String pDbaUsername, char[] pDbaPassword, int pMasterRepositoryId, TechnologyName pMasterTechnology, boolean pOverwrite, IMassImportExportResource pMasterImportSource, java.lang.String pRegistry, CryptoAlgo pAlgo, char[] pExportKey, boolean pImportWithoutCipherData, char[] pSupervisorPassword)
boolean	createMasterRepositoryFromExport(JdbcProperties pMasterRepositoryJdbcProperties, java.lang.String pDbaUsername, char[] pDbaPassword, TechnologyName pMasterTechnology, boolean pOverwrite, IMassImportExportResource pMasterImportSource)
boolean	createMasterRepositoryFromExport(JdbcProperties pMasterRepositoryJdbcProperties, java.lang.String pDbaUsername, char[] pDbaPassword, TechnologyName pMasterTechnology, boolean pOverwrite, IMassImportExportResource pMasterImportSource, CryptoAlgo pAlgo, char[] pExportKey, boolean pImportWithoutCipherData, char[] pSupervisorPassword) Creates Master Repository by importing the exported-resource
boolean	createMasterRepositoryFromExport(JdbcProperties pMasterRepositoryJdbcProperties, java.lang.String pDbaUsername, char[] pDbaPassword, TechnologyName pMasterTechnology, boolean pOverwrite, IMassImportExportResource pMasterImportSource, java.lang.String pRegistry) Deprecated.
IOdiProgressMonitor	getProgressMonitor() This method will return the IODIProgressMonitor instance.
boolean	isSupervisorPasswordRequired(JdbcProperties jdbcProperties, IMassImportExportResource pMasterImportSource, boolean pImportWithoutCipherData)
void	set11gcompatibleMode(boolean pIs11gCompatible) Sets 11g Compatible mode/
void	setProgressMonitor(IOdiProgressMonitor progressMonitor) This method will set the upgrade call back to report the status of the repository upgrades.
void	upgradeMasterRepository(JdbcProperties pJdbcProperties) Deprecated.
void	upgradeMasterRepository(JdbcProperties pJdbcProperties, CryptoAlgo pAlgo) Use to upgrade master repository
void	upgradeMasterRepository(JdbcProperties pMasterRepositoryJdbcProperties, java.lang.String pGlobalIdUpgradeKey)
void	upgradeMasterRepository(JdbcProperties pMasterRepositoryJdbcProperties, java.lang.String pDbaUsername, char[] pDbaPassword)
void	upgradeMasterRepository(JdbcProperties pMasterRepositoryJdbcProperties, java.lang.String pDbaUsername, char[] pDbaPassword, java.lang.String pRegistry) Upgrade the master repository schema for the database specified by the given parameters.
void	upgradeMasterRepository(java.lang.String pMasterUrl, java.lang.String pMasterDriver, java.lang.String pEdition, java.lang.String pMasterUsername, java.lang.String pMasterPassword, TechnologyName pMasterTechnology, CryptoAlgo pAlgo) Deprecated.
void	upgradeMasterRepository(java.lang.String pMasterUrl, java.lang.String pMasterDriver, java.lang.String pEdition, java.lang.String pMasterUsername, java.lang.String pMasterPassword, TechnologyName pMasterTechnology, java.lang.String pGlobalIdUpgradeKey, CryptoAlgo pAlgo) Use to upgrade Master Repository
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.
void	upgradeMasterRepository(java.lang.String pMasterUrl, java.lang.String pMasterDriver, java.lang.String pMasterUsername, java.lang.String pMasterPassword, TechnologyName pMasterTechnology, java.lang.String pGlobalIdUpgradeKey)
void	validateDatabase(JdbcProperties pMasterRepositoryJdbcProperties, java.lang.String pDbaUsername, char[] pDbaPassword, TechnologyName pMasterTechnology) This method validates the database versions
void	validateDatabase(JdbcProperties pMasterRepositoryJdbcProperties, java.lang.String pDbaUsername, char[] pDbaPassword, TechnologyName pMasterTechnology, java.lang.String pRegistry) This method validates the database version.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

REPOSITORY_STATUS_OK

public static final java.lang.String REPOSITORY_STATUS_OK

See Also:

Constant Field Values

REPOSITORY_STATUS_UPGRADING

public static final java.lang.String REPOSITORY_STATUS_UPGRADING

See Also:

Constant Field Values

REPOSITORY_STATUS_INSTALL_FAILED

public static final java.lang.String REPOSITORY_STATUS_INSTALL_FAILED

See Also:

Constant Field Values

Constructor Detail

MasterRepositorySetupImpl

public MasterRepositorySetupImpl()

Method Detail

createMasterRepository

@Deprecated
public 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

Deprecated.

Description copied from interface: IMasterRepositorySetup

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.

Specified by:

createMasterRepository in interface IMasterRepositorySetup

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

createMasterRepository

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

Deprecated.

Specified by:

createMasterRepository in interface IMasterRepositorySetup

Throws:

RepositorySetupException

createMasterRepository

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

Deprecated.

Throws:

RepositorySetupException

createMasterRepository

public boolean createMasterRepository(java.lang.String pMasterUrl,
                                      java.lang.String pMasterDriver,
                                      java.lang.String pMasterUsername,
                                      java.lang.String pMasterPassword,
                                      TechnologyName pMasterTechnology,
                                      java.lang.String pEditionName,
                                      boolean pOverwrite,
                                      AuthenticationConfiguration pAuthenticationConfiguration,
                                      PasswordStorageConfiguration pPasswordStorageConfiguration,
                                      IMassImportExportResource pMasterImportSource,
                                      CryptoAlgo pAlgo,
                                      java.util.Properties pProperties)
                               throws RepositorySetupException

Throws:

RepositorySetupException

createMasterRepository

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

Deprecated. Use the API in which password argument is of type character array (char[])

Specified by:

createMasterRepository in interface IMasterRepositorySetup

Parameters:

pMasterUrl - Master Repository Database url

pMasterDriver - Master Repository Database driver

pMasterUsername - Master Repository schema username.

pMasterPassword - Master Repository schema password.

pMasterTechnology - Master Repository technology.

pOverwrite - - Flag to indicate to overwrite the repository if exists.

pAuthenticationConfiguration - - The (internal / external) authentication configuration.

pPasswordStorageConfiguration - - The (internal / external) password storage configuration.

pMasterImportSource - - The source to be imported into the new master repository that is to be created.

Returns:

boolean - returns true if repository is created successfully. false otherwise.

Throws:

RepositorySetupException

upgradeMasterRepository

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

Specified by:

upgradeMasterRepository in interface IMasterRepositorySetup

Parameters:

pMasterUrl - Master Repository Database url

pMasterDriver - Master Repository Database driver

pMasterUsername - Master Repository schema username

pMasterPassword - Master Repository schema password

pMasterTechnology - Master Repository technology

pGlobalIdUpgradeKey - Upgrade key

Throws:

RepositorySetupException

upgradeMasterRepository

public void upgradeMasterRepository(java.lang.String pMasterUrl,
                                    java.lang.String pMasterDriver,
                                    java.lang.String pEdition,
                                    java.lang.String pMasterUsername,
                                    java.lang.String pMasterPassword,
                                    TechnologyName pMasterTechnology,
                                    java.lang.String pGlobalIdUpgradeKey,
                                    CryptoAlgo pAlgo)
                             throws RepositorySetupException

Use to upgrade Master Repository

Parameters:

pMasterUrl - Master repository Database url

pMasterDriver - Master repository Database Driver

pEdition - Edition name, as defined by EBR architecture

pMasterUsername - Master repository schema username

pMasterPassword - Master repository schema password

pMasterTechnology - Master repository Technology

pGlobalIdUpgradeKey - Upgrade Key

pAlgo - pAlgo the encryption algorithm end user can configure to use in ODI to encrypt password etc sensitive information. In 12.1.3 AES128 and AES256 are supported.

Throws:

RepositorySetupException

upgradeMasterRepository

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

Description copied from interface: IMasterRepositorySetup

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

Specified by:

upgradeMasterRepository in interface IMasterRepositorySetup

Parameters:

pMasterUrl - Master Repository Database url

pMasterDriver - Master Repository Database driver

pMasterUsername - Master Repository schema username

pMasterPassword - Master Repository schema password

pMasterTechnology - Master Repository technology

Throws:

RepositorySetupException

RepositoryScriptsNotFoundException - if the script files can't be found

upgradeMasterRepository

@Deprecated
public void upgradeMasterRepository(java.lang.String pMasterUrl,
                                                java.lang.String pMasterDriver,
                                                java.lang.String pEdition,
                                                java.lang.String pMasterUsername,
                                                java.lang.String pMasterPassword,
                                                TechnologyName pMasterTechnology,
                                                CryptoAlgo pAlgo)
                                         throws RepositorySetupException

Deprecated.

Throws:

RepositorySetupException

upgradeMasterRepository

@Deprecated
public void upgradeMasterRepository(JdbcProperties pJdbcProperties)
                                         throws RepositorySetupException

Deprecated.

Description copied from interface: IMasterRepositorySetup

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

Specified by:

upgradeMasterRepository in interface IMasterRepositorySetup

Parameters:

pJdbcProperties - the jdbc properties of the database where the master repository to upgrade is installed

Throws:

RepositorySetupException - if failed to upgrade the given repository

RepositoryScriptsNotFoundException - if the script files can't be found

upgradeMasterRepository

public void upgradeMasterRepository(JdbcProperties pJdbcProperties,
                                    CryptoAlgo pAlgo)
                             throws RepositorySetupException

Use to upgrade master repository

Specified by:

upgradeMasterRepository in interface IMasterRepositorySetup

Parameters:

pJdbcProperties - Master Repository JDBC properties (url, driver, user, password)

pAlgo - The encryption algorithm to be used for this repository. Valid algorithms are AES-128, AES-256 (Refer CryptoAlgo).

Throws:

RepositorySetupException

createMasterRepository

public boolean createMasterRepository(JdbcProperties pMasterRepositoryJdbcProperties,
                                      java.lang.String pDbaUsername,
                                      char[] pDbaPassword,
                                      TechnologyName pMasterTechnology,
                                      boolean pOverwrite,
                                      AuthenticationConfiguration pAuthenticationConfiguration,
                                      PasswordStorageConfiguration pPasswordStorageConfiguration)
                               throws RepositorySetupException

Specified by:

createMasterRepository in interface IMasterRepositorySetup

Parameters:

pMasterRepositoryJdbcProperties - Master Repository JDBC properties (url, driver, user, password)

pDbaUsername - Dba username

pDbaPassword - Dba password

pMasterTechnology - Master Repository technology

pOverwrite - Flag to indicate to overwrite the repository if exists.

pAuthenticationConfiguration - the (internal / external) authentication configuration.

pPasswordStorageConfiguration - the (internal / external) password storage configuration.

Returns:

boolean - returns true if repository is created successfully. false otherwise.

Throws:

RepositorySetupException

createMasterRepository

public boolean createMasterRepository(JdbcProperties pMasterRepositoryJdbcProperties,
                                      java.lang.String pDbaUsername,
                                      char[] pDbaPassword,
                                      TechnologyName pMasterTechnology,
                                      boolean pOverwrite,
                                      AuthenticationConfiguration pAuthenticationConfiguration,
                                      PasswordStorageConfiguration pPasswordStorageConfiguration,
                                      CryptoAlgo pAlgo)
                               throws RepositorySetupException

Specified by:

createMasterRepository in interface IMasterRepositorySetup

Parameters:

pMasterRepositoryJdbcProperties - Master Repository JDBC properties (url, driver, user, password)

pDbaUsername - Dba username

pDbaPassword - Dba password

pMasterTechnology - Master Repository technology

pOverwrite - Flag to indicate to overwrite the repository if exists.

pAuthenticationConfiguration - The (internal / external) authentication configuration.

pPasswordStorageConfiguration - The (internal / external) password storage configuration.

pAlgo - The encryption algorithm to be used for this repository. Valid algorithms are AES-128, AES-256 (Refer CryptoAlgo).

Returns:

returns true if repository is created successfully. false otherwise.

Throws:

RepositorySetupException

createMasterRepository

public boolean createMasterRepository(JdbcProperties pMasterRepositoryJdbcProperties,
                                      java.lang.String pDbaUsername,
                                      char[] pDbaPassword,
                                      TechnologyName pMasterTechnology,
                                      boolean pOverwrite,
                                      AuthenticationConfiguration pAuthenticationConfiguration,
                                      PasswordStorageConfiguration pPasswordStorageConfiguration,
                                      java.lang.String pRegistry)
                               throws RepositorySetupException

Specified by:

createMasterRepository in interface IMasterRepositorySetup

Parameters:

pMasterRepositoryJdbcProperties - Master Repository JDBC properties (url, driver, user, password)

pDbaUsername - Dba username

pDbaPassword - Dba password

pMasterTechnology - Master Repository technology.

pOverwrite - Flag to indicate to overwrite the repository if exists.

pAuthenticationConfiguration - The (internal / external) authentication configuration.

pPasswordStorageConfiguration - The (internal / external) password storage configuration.

pRegistry - The Schema Version Registry (SVR) of the MySQL database; null for other databases.

Returns:

boolean - returns true if repository is created successfully. false otherwise.

Throws:

RepositorySetupException

createMasterRepository

public boolean createMasterRepository(JdbcProperties pMasterRepositoryJdbcProperties,
                                      java.lang.String pDbaUsername,
                                      char[] pDbaPassword,
                                      TechnologyName pMasterTechnology,
                                      boolean pOverwrite,
                                      AuthenticationConfiguration pAuthenticationConfiguration,
                                      PasswordStorageConfiguration pPasswordStorageConfiguration,
                                      java.lang.String pRegistry,
                                      CryptoAlgo pEncAlgo)
                               throws RepositorySetupException

Specified by:

createMasterRepository in interface IMasterRepositorySetup

Parameters:

pMasterRepositoryJdbcProperties - Master Repository JDBC properties (url, driver, user, password)

pDbaUsername - Dba username

pDbaPassword - Dba Password

pMasterTechnology - Master Repository technology.

pOverwrite - - Flag to indicate to overwrite the repository if exists.

pAuthenticationConfiguration - - The (internal / external) authentication configuration.

pPasswordStorageConfiguration - - The (internal / external) password storage configuration.

pRegistry - The Schema Version Registry (SVR) of the MySQL database; null for other databases.

pEncAlgo - The encryption algorithm to be used for this repository. Valid algorithms are AES-128, AES-256 (Refer CryptoAlgo).

Returns:

boolean - returns true if repository is created successfully. false otherwise.

Throws:

RepositorySetupException

createMasterRepository

@Deprecated
public boolean createMasterRepository(JdbcProperties pMasterRepositoryJdbcProperties,
                                                  java.lang.String pDbaUsername,
                                                  char[] pDbaPassword,
                                                  int pMasterRepositoryId,
                                                  TechnologyName pMasterTechnology,
                                                  boolean pOverwrite,
                                                  AuthenticationConfiguration pAuthenticationConfiguration,
                                                  PasswordStorageConfiguration pPasswordStorageConfiguration)
                                           throws RepositorySetupException

Deprecated.

Description copied from interface: IMasterRepositorySetup

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.

Specified by:

createMasterRepository in interface IMasterRepositorySetup

Parameters:

pMasterRepositoryJdbcProperties - the jdbc properties of the database where the master repository to upgrade is installed

pDbaUsername - The database user that will be used to manage the Schema Version Registry. This user should have the DBA privileges. For Oracle user SYS, please enter SYS AS SYSDBA.

pDbaPassword - The password for the dba user.

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 PasswordStorageConfiguration.InternalPasswordStorageConfiguration 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

createMasterRepository

@Deprecated
public boolean createMasterRepository(JdbcProperties pMasterRepositoryJdbcProperties,
                                                  java.lang.String pDbaUsername,
                                                  char[] pDbaPassword,
                                                  int pMasterRepositoryId,
                                                  TechnologyName pMasterTechnology,
                                                  boolean pOverwrite,
                                                  AuthenticationConfiguration pAuthenticationConfiguration,
                                                  PasswordStorageConfiguration pPasswordStorageConfiguration,
                                                  java.lang.String pRegistry)
                                           throws RepositorySetupException

Deprecated.

Specified by:

createMasterRepository in interface IMasterRepositorySetup

Throws:

RepositorySetupException

createMasterRepository

@Deprecated
public boolean createMasterRepository(JdbcProperties pMasterRepositoryJdbcProperties,
                                                  java.lang.String pDbaUsername,
                                                  char[] pDbaPassword,
                                                  int pMasterRepositoryId,
                                                  TechnologyName pMasterTechnology,
                                                  boolean pOverwrite,
                                                  AuthenticationConfiguration pAuthenticationConfiguration,
                                                  PasswordStorageConfiguration pPasswordStorageConfiguration,
                                                  java.lang.String pRegistry,
                                                  CryptoAlgo pEncAlgo)
                                           throws RepositorySetupException

Deprecated.

Specified by:

createMasterRepository in interface IMasterRepositorySetup

Throws:

RepositorySetupException

createMasterRepositoryFromExport

public boolean createMasterRepositoryFromExport(JdbcProperties pMasterRepositoryJdbcProperties,
                                                java.lang.String pDbaUsername,
                                                char[] pDbaPassword,
                                                TechnologyName pMasterTechnology,
                                                boolean pOverwrite,
                                                IMassImportExportResource pMasterImportSource)
                                         throws RepositorySetupException

Specified by:

createMasterRepositoryFromExport in interface IMasterRepositorySetup

Parameters:

pMasterRepositoryJdbcProperties - Master Repository JDBC properties (url, driver, user, password)

pDbaUsername - Dba username

pDbaPassword - Dba password

pMasterTechnology - Master Repository technology

pOverwrite - Flag to indicate to overwrite the repository if exists.

pMasterImportSource - The source to be imported into the new master repository that is to be created.

Returns:

boolean - returns true if repository is created successfully. false otherwise.

Throws:

RepositorySetupException

createMasterRepositoryFromExport

public boolean createMasterRepositoryFromExport(JdbcProperties pMasterRepositoryJdbcProperties,
                                                java.lang.String pDbaUsername,
                                                char[] pDbaPassword,
                                                TechnologyName pMasterTechnology,
                                                boolean pOverwrite,
                                                IMassImportExportResource pMasterImportSource,
                                                CryptoAlgo pAlgo,
                                                char[] pExportKey,
                                                boolean pImportWithoutCipherData,
                                                char[] pSupervisorPassword)
                                         throws RepositorySetupException

Creates Master Repository by importing the exported-resource

Specified by:

createMasterRepositoryFromExport in interface IMasterRepositorySetup

Parameters:

pMasterRepositoryJdbcProperties - Master Repository JDBC properties (url, driver, user, password)

pDbaUsername - Dba username

pDbaPassword - Dba password

pMasterTechnology - Master Repository technology

pOverwrite - Flag to indicate to overwrite the repository if exists.

pMasterImportSource - The source to be imported into the new master repository that is to be created.

pAlgo - The encryption algorithm to be used for this repository. Valid algorithms are AES-128, AES-256 (Refer CryptoAlgo).

pExportKey - Export Key

pImportWithoutCipherData - Flag to continue import in case of invalid key

Returns:

returns true if repository is created successfully. false otherwise.

Throws:

RepositorySetupException

createMasterRepositoryFromExport

@Deprecated
public boolean createMasterRepositoryFromExport(JdbcProperties pMasterRepositoryJdbcProperties,
                                                            java.lang.String pDbaUsername,
                                                            char[] pDbaPassword,
                                                            int pMasterRepositoryId,
                                                            TechnologyName pMasterTechnology,
                                                            boolean pOverwrite,
                                                            IMassImportExportResource pMasterImportSource)
                                                     throws RepositorySetupException

Deprecated.

Description copied from interface: IMasterRepositorySetup

Creates an ODI master repository into the database specified by the given parameters and populates the master with informations from a master export.

This method will create the tables for master repository in the database schema, and will initialize master repository configuration based on the export source.

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.

Specified by:

createMasterRepositoryFromExport in interface IMasterRepositorySetup

Parameters:

pMasterRepositoryJdbcProperties - the jdbc properties of the database where the master repository to upgrade is installed

pDbaUsername - The database user that will be used to manage the Schema Version Registry. This user should have the DBA privileges. For Oracle user SYS, please enter SYS AS SYSDBA.

pDbaPassword - The password for the dba user.

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.

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

createMasterRepositoryFromExport

@Deprecated
public boolean createMasterRepositoryFromExport(JdbcProperties pMasterRepositoryJdbcProperties,
                                                            java.lang.String pDbaUsername,
                                                            char[] pDbaPassword,
                                                            TechnologyName pMasterTechnology,
                                                            boolean pOverwrite,
                                                            IMassImportExportResource pMasterImportSource,
                                                            java.lang.String pRegistry)
                                                     throws RepositorySetupException

Deprecated.

Description copied from interface: IMasterRepositorySetup

Creates an ODI master repository into the database specifiedOiss by the given parameters and populates the master with informations from a master export.

This method will create the tables for master repository in the database schema, and will initialize master repository configuration based on the export source.

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.

Specified by:

createMasterRepositoryFromExport in interface IMasterRepositorySetup

Parameters:

pMasterRepositoryJdbcProperties - the jdbc properties of the database where the master repository to upgrade is installed

pDbaUsername - The database user that will be used to manage the Schema Version Registry. This user should have the DBA privileges. For Oracle user SYS, please enter SYS AS SYSDBA.

pDbaPassword - The password for the dba user.

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.

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

pRegistry - the database to be used for the schema version registry. MySQL databases only.

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

createMasterRepositoryFromExport

@Deprecated
public boolean createMasterRepositoryFromExport(JdbcProperties pMasterRepositoryJdbcProperties,
                                                            java.lang.String pDbaUsername,
                                                            char[] pDbaPassword,
                                                            int pMasterRepositoryId,
                                                            TechnologyName pMasterTechnology,
                                                            boolean pOverwrite,
                                                            IMassImportExportResource pMasterImportSource,
                                                            java.lang.String pRegistry)
                                                     throws RepositorySetupException

Deprecated.

Description copied from interface: IMasterRepositorySetup

Creates an ODI master repository into the database specified by the given parameters and populates the master with informations from a master export.

This method will create the tables for master repository in the database schema, and will initialize master repository configuration based on the export source.

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.

Specified by:

createMasterRepositoryFromExport in interface IMasterRepositorySetup

Parameters:

pMasterRepositoryJdbcProperties - the jdbc properties of the database where the master repository to upgrade is installed

pDbaUsername - The database user that will be used to manage the Schema Version Registry. This user should have the DBA privileges. For Oracle user SYS, please enter SYS AS SYSDBA.

pDbaPassword - The password for the dba user.

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.

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

pRegistry - the database to be used for the schema version registry. MySQL databases only.

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

createMasterRepositoryFromExport

public boolean createMasterRepositoryFromExport(JdbcProperties pMasterRepositoryJdbcProperties,
                                                java.lang.String pDbaUsername,
                                                char[] pDbaPassword,
                                                int pMasterRepositoryId,
                                                TechnologyName pMasterTechnology,
                                                boolean pOverwrite,
                                                IMassImportExportResource pMasterImportSource,
                                                java.lang.String pRegistry,
                                                CryptoAlgo pAlgo,
                                                char[] pExportKey,
                                                boolean pImportWithoutCipherData,
                                                char[] pSupervisorPassword)
                                         throws RepositorySetupException

Specified by:

createMasterRepositoryFromExport in interface IMasterRepositorySetup

Parameters:

pMasterRepositoryJdbcProperties - Master Repository JDBC properties (url, driver, user, password)

pDbaUsername - Dba username

pDbaPassword - Dba password

pMasterRepositoryId - Master Repository Id

pMasterTechnology - Master Repository technology

pOverwrite - - Flag to indicate to overwrite the repository if exists.

pMasterImportSource - - The source to be imported into the new master repository that is to be created.

pRegistry - The Schema Version Registry (SVR) of the MySQL database; null for other databases.

pAlgo - The encryption algorithm to be used for this repository. Valid algorithms are AES-128, AES-256 (Refer CryptoAlgo).

pExportKey - Export Key

pImportWithoutCipherData - Flag to continue import without valid key

Returns:

boolean - returns true if repository is created successfully. false otherwise.

Throws:

RepositorySetupException

upgradeMasterRepository

public void upgradeMasterRepository(JdbcProperties pMasterRepositoryJdbcProperties,
                                    java.lang.String pGlobalIdUpgradeKey)
                             throws RepositorySetupException

Specified by:

upgradeMasterRepository in interface IMasterRepositorySetup

Parameters:

pMasterRepositoryJdbcProperties - Master Repository JDBC properties (url, driver, user, password)

pGlobalIdUpgradeKey - Upgrade key

Throws:

RepositorySetupException

upgradeMasterRepository

public void upgradeMasterRepository(JdbcProperties pMasterRepositoryJdbcProperties,
                                    java.lang.String pDbaUsername,
                                    char[] pDbaPassword)
                             throws RepositorySetupException

Specified by:

upgradeMasterRepository in interface IMasterRepositorySetup

Throws:

RepositorySetupException

upgradeMasterRepository

public void upgradeMasterRepository(JdbcProperties pMasterRepositoryJdbcProperties,
                                    java.lang.String pDbaUsername,
                                    char[] pDbaPassword,
                                    java.lang.String pRegistry)
                             throws RepositorySetupException

Description copied from interface: IMasterRepositorySetup

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

Specified by:

upgradeMasterRepository in interface IMasterRepositorySetup

Parameters:

pMasterRepositoryJdbcProperties - the jdbc properties of the database where the master repository to upgrade is installed

pDbaUsername - The database user that will be used to manage the Schema Version Registry. This user should have the DBA privileges. For Oracle user SYS, please enter SYS AS SYSDBA.

pDbaPassword - The password for the dba user.

Throws:

RepositorySetupException - if failed to upgrade the given repository

RepositoryScriptsNotFoundException - if the script files can't be found

setProgressMonitor

public void setProgressMonitor(IOdiProgressMonitor progressMonitor)

Description copied from interface: IMasterRepositorySetup

This method will set the upgrade call back to report the status of the repository upgrades.

Specified by:

setProgressMonitor in interface IMasterRepositorySetup

See Also:

IODIProgressMonitor

getProgressMonitor

public IOdiProgressMonitor getProgressMonitor()

Description copied from interface: IMasterRepositorySetup

This method will return the IODIProgressMonitor instance. if not set it will return null.

Specified by:

getProgressMonitor in interface IMasterRepositorySetup

Returns:

IODIProgressMonitor

validateDatabase

public void validateDatabase(JdbcProperties pMasterRepositoryJdbcProperties,
                             java.lang.String pDbaUsername,
                             char[] pDbaPassword,
                             TechnologyName pMasterTechnology)
                      throws DatabaseValidationException

This method validates the database versions

Parameters:

pMasterRepositoryJdbcProperties -

pDbaUsername -

pDbaPassword -

pMasterTechnology -

Throws:

DatabaseValidationException

validateDatabase

public void validateDatabase(JdbcProperties pMasterRepositoryJdbcProperties,
                             java.lang.String pDbaUsername,
                             char[] pDbaPassword,
                             TechnologyName pMasterTechnology,
                             java.lang.String pRegistry)
                      throws DatabaseValidationException

This method validates the database version.

Parameters:

pMasterRepositoryJdbcProperties -

pDbaUsername -

pDbaPassword -

pMasterTechnology -

pRegistry - - Registry DB name for MySql

Throws:

DatabaseValidationException

isSupervisorPasswordRequired

public boolean isSupervisorPasswordRequired(JdbcProperties jdbcProperties,
                                            IMassImportExportResource pMasterImportSource,
                                            boolean pImportWithoutCipherData)
                                     throws RepositorySetupException

Specified by:

isSupervisorPasswordRequired in interface IMasterRepositorySetup

Throws:

RepositorySetupException

set11gcompatibleMode

public void set11gcompatibleMode(boolean pIs11gCompatible)

Description copied from interface: IMasterRepositorySetup

Sets 11g Compatible mode/

Specified by:

set11gcompatibleMode in interface IMasterRepositorySetup