IMasterRepositorySetup (Oracle Data Integrator Java API Reference)

Method Summary
`boolean`	`createMasterRepository(JdbcProperties pMasterRepositoryJdbcProperties, java.lang.String pDbaUsername, char[] pDbaPassword, int pMasterRepositoryId, TechnologyName pMasterTechnology, boolean pOverwrite, AuthenticationConfiguration pAuthenticationConfiguration, PasswordStorageConfiguration pPasswordStorageConfiguration)` Create an ODI master repository into the database specified by the given parameters.
`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`	`createMasterRepositoryFromExport(JdbcProperties pMasterRepositoryJdbcProperties, java.lang.String pDbaUsername, char[] pDbaPassword, int pMasterRepositoryId, TechnologyName pMasterTechnology, boolean pOverwrite, IMassImportExportResource pMasterImportSource)` Creates an ODI master repository into the database specified by the given parameters and populates the master with informations from a master export.
`void`	`upgradeMasterRepository(JdbcProperties pMasterRepositoryJdbcProperties)` Deprecated. replaced by `#upgradeMasterRepository(JdbcProperties, String, String)`
`void`	`upgradeMasterRepository(JdbcProperties pMasterRepositoryJdbcProperties, java.lang.String pDbaUsername, char[] pDbaPassword)` 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 `IMasterRepositorySetup#upgradeMasterRepository(JdbcProperties, String, String)`

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

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

upgradeMasterRepository

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 IMasterRepositorySetup#upgradeMasterRepository(JdbcProperties, String, 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(JdbcProperties pMasterRepositoryJdbcProperties)
                             throws RepositorySetupException

Deprecated. replaced by #upgradeMasterRepository(JdbcProperties, String, 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

createMasterRepository

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

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

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

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

upgradeMasterRepository

void upgradeMasterRepository(JdbcProperties pMasterRepositoryJdbcProperties,
                             java.lang.String pDbaUsername,
                             char[] pDbaPassword)
                             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
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