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

Fields

Modifier and Type	Field and Description
static int	MASTER_REPOSITORY_MAX_ID Master repository ID maximum value.

Method Summary

Methods

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 pAlgo) 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 pAlgo)
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. replaced by #createMasterRepository(JdbcProperties, String, String, int, TechnologyName, boolean, AuthenticationConfiguration, PasswordStorageConfiguration) and createMasterRepositoryFromExport(JdbcProperties, String, char[], int, TechnologyName, boolean, IMassImportExportResource)
boolean	createMasterRepository(java.lang.String pMasterUrl, java.lang.String pMasterDriver, java.lang.String pMasterUsername, char[] pMasterPassword, TechnologyName pMasterTechnology, boolean pOverwrite, AuthenticationConfiguration pAuthenticationConfiguration, PasswordStorageConfiguration pPasswordStorageConfiguration, IMassImportExportResource pMasterImportSource)
boolean	createMasterRepository(java.lang.String pMasterUrl, java.lang.String pMasterDriver, java.lang.String pMasterUsername, char[] pMasterPassword, TechnologyName pMasterTechnology, boolean pOverwrite, AuthenticationConfiguration pAuthenticationConfiguration, PasswordStorageConfiguration pPasswordStorageConfiguration, IMassImportExportResource pMasterImportSource, CryptoAlgo pEncAlgo)
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. replaced by #createMasterRepository(JdbcProperties, String, String, int, TechnologyName, boolean, AuthenticationConfiguration, PasswordStorageConfiguration) and createMasterRepositoryFromExport(JdbcProperties, String, char[], int, TechnologyName, boolean, IMassImportExportResource)
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.
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)
boolean	createMasterRepositoryFromExport(JdbcProperties pMasterRepositoryJdbcProperties, java.lang.String pDbaUsername, char[] pDbaPassword, TechnologyName pMasterTechnology, boolean pOverwrite, IMassImportExportResource pMasterImportSource, java.lang.String pRegistry) Creates an ODI master repository into the database specifiedOiss by the given parameters and populates the master with informations from a master export.
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 pMasterRepositoryJdbcProperties) Deprecated. replaced by upgradeMasterRepository(JdbcProperties, String)
void	upgradeMasterRepository(JdbcProperties pMasterRepositoryJdbcProperties, CryptoAlgo pAlgo)
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 pMasterUsername, java.lang.String pMasterPassword, TechnologyName pMasterTechnology) Deprecated. replaced by upgradeMasterRepository(JdbcProperties, String)
void	upgradeMasterRepository(java.lang.String pMasterUrl, java.lang.String pMasterDriver, java.lang.String pMasterUsername, java.lang.String pMasterPassword, TechnologyName pMasterTechnology, java.lang.String pGlobalIdUpgradeKey)

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

@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)
                               throws RepositorySetupException

Deprecated. replaced by #createMasterRepository(JdbcProperties, String, String, int, TechnologyName, boolean, AuthenticationConfiguration, PasswordStorageConfiguration) and createMasterRepositoryFromExport(JdbcProperties, String, char[], int, TechnologyName, boolean, IMassImportExportResource)

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

createMasterRepository

@Deprecated
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. replaced by #createMasterRepository(JdbcProperties, String, String, int, TechnologyName, boolean, AuthenticationConfiguration, PasswordStorageConfiguration) and createMasterRepositoryFromExport(JdbcProperties, String, char[], int, TechnologyName, boolean, IMassImportExportResource)

Throws:

RepositorySetupException

createMasterRepository

@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)
                               throws RepositorySetupException

Deprecated.

Throws:

RepositorySetupException

createMasterRepository

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

Throws:

RepositorySetupException

createMasterRepository

boolean createMasterRepository(java.lang.String pMasterUrl,
                             java.lang.String pMasterDriver,
                             java.lang.String pMasterUsername,
                             char[] pMasterPassword,
                             TechnologyName pMasterTechnology,
                             boolean pOverwrite,
                             AuthenticationConfiguration pAuthenticationConfiguration,
                             PasswordStorageConfiguration pPasswordStorageConfiguration,
                             IMassImportExportResource pMasterImportSource,
                             CryptoAlgo pEncAlgo)
                               throws RepositorySetupException

Throws:

RepositorySetupException

upgradeMasterRepository

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

Deprecated. replaced by upgradeMasterRepository(JdbcProperties, String)

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

upgradeMasterRepository

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

Throws:

RepositorySetupException

upgradeMasterRepository

@Deprecated
void upgradeMasterRepository(JdbcProperties pMasterRepositoryJdbcProperties)
                             throws RepositorySetupException

Deprecated. replaced by upgradeMasterRepository(JdbcProperties, String)

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

Parameters:

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

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

upgradeMasterRepository

void upgradeMasterRepository(JdbcProperties pMasterRepositoryJdbcProperties,
                           CryptoAlgo pAlgo)
                             throws RepositorySetupException

Throws:

RepositorySetupException

upgradeMasterRepository

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

Throws:

RepositorySetupException

createMasterRepository

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

Deprecated.

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:

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.

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

createMasterRepository

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

Throws:

RepositorySetupException

createMasterRepository

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

Throws:

RepositorySetupException

createMasterRepository

@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)
                               throws RepositorySetupException

Deprecated.

Throws:

RepositorySetupException

createMasterRepository

@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 pAlgo)
                               throws RepositorySetupException

Deprecated.

Throws:

RepositorySetupException

createMasterRepository

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

Throws:

RepositorySetupException

createMasterRepository

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

Parameters:

pAlgo - the algorithm which end user configures to use for password etc sensitive information encryption in ODI. in 12.1.3 it is AES128 or AES256

Throws:

RepositorySetupException

createMasterRepositoryFromExport

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

Deprecated.

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.

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

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

Throws:

RepositorySetupException

createMasterRepositoryFromExport

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

Throws:

RepositorySetupException

createMasterRepositoryFromExport

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

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.

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

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

Throws:

RepositorySetupException

createMasterRepositoryFromExport

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

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.

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

upgradeMasterRepository

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

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

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

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

RepositoryScriptsNotFoundException - if the script files can't be found

Since:

11.1.1.5.0

upgradeMasterRepository

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

Throws:

RepositorySetupException

setProgressMonitor

void setProgressMonitor(IOdiProgressMonitor progressMonitor)

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

Parameters:

progressMonitor -

See Also:

IODIProgressMonitor

getProgressMonitor

IOdiProgressMonitor getProgressMonitor()

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

Returns:

IODIProgressMonitor

isSupervisorPasswordRequired

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

Throws:

RepositorySetupException

set11gcompatibleMode

void set11gcompatibleMode(boolean pIs11gCompatible)

Sets 11g Compatible mode/

Parameters:

pIs11gCompatible -