Xephr Administration Console
Repositories

On the Repositories screen, you can view and add Xephr® repositories.  The repository created when installing Xephr is displayed with the description Initial Repository and can be edited.  

Location: The current location within the administration console.

Repository Name: the name of the repository.

Database Type: the repository's database type.

Status: the repositories status will be blank when there are no problems.  If the repository is not initialized, the field will display 'Not Initialized'.  If the schema of the repository does not meet the installed Xephr schema, the field will display 'Bad Schema'.  

If your repository displays 'Bad Schema', you need to update it on the Edit screen before opening the repository in the Studio.  Otherwise, the repository will be damaged and it will need to be rebuilt.

Connection Properties: the connection string for this repository.

Description: the repository description.

To add a new repository, select the Attach to New Repository link.

To edit or delete an existing repository, left click on the repository name.

SQL Execution during Repository Initialization

Xephr supports the execution of arbitrary SQL during the repository (re)initialization process.  This SQL, if present, will be executed in the repository schema as the database user defined by the repository setup.  This SQL will be executed on both initialization and re-initialization, and will honor existing rules for SQL execution.  Specifically if an error occurs during processing the entire repository initialization fails. Care should be taken to ensure that the SQL executed is "safe" for both cases.  

To take advantage of this feature, the user SQL should be placed in the file in the Xephr installation directory/sql/application.sql.

Add Repository

Click on the Attach to New Repository link.

The Location property displays the current location within the administration console.

Select the radio button for the appropriate database type for the new repository.  Depending on the radio button, the database properties will be different.

Microsoft SQL Server

  1. The Location property displays the current location within the administration console.

  2. In the Repository Name property, enter the user-defined repository name.

  3. In the Description property, enter the user-defined repository description.

  4. In the User property, enter the user name to connect to this repository database.

  5. In the Password property, enter the password to connect to this repository database.

  6. In the Max Active Connections property, enter the total number of connections that can be created in the connection pool.

  7. In the Server property, enter the name of the server on which this database lives.

  8. In the Port property, enter the port number on the server that the driver must connect to in order to access this database.

  9. In the Database property, enter the name of the database to which you are connecting.

  10. Set the Make Default flag to the desired setting  When this flag is set to on it indicates that this repository is the default repository for the host, so that when users access the Xephr runtime for the host, this is the repository that they access.

  11. Click on the Create Repository button to create the repository.

  12. Click on the Return to Repository link to return to the edit screen for the repository.

Oracle 9i

  1. The Location property displays the current location within the administration console.

  2. In the Repository Name property, enter the user-defined repository name.

  3. In the Description property, enter the user-defined repository description.

  4. In the User property, enter the user name to connect to this repository database.

  5. In the Password property, enter the password to connect to this repository database.

  6. In the Max Active Connections property, enter the total number of connections that can be created in the connection pool.

  7. In the Server property, enter the name of the server on which this database lives.

  8. In the Port property, enter the port number on the server that the driver must connect to in order to access this database.

  9. In the SID property, enter the service identifier (SID) for the database

  10. Set the Make Default flag to the desired setting  When this flag is set to on it indicates that this repository is the default repository for the host, so that when users access the Xephr runtime for the host, this is the repository that they access.

  11. Click on the Create Repository button to create the repository.

  12. Click on the Return to Repository link to return to the edit screen for the repository.

PostgreSQL

  1. The Location property displays the current location within the administration console.

  2. In the Repository Name property, enter the user-defined repository name.

  3. In the Description property, enter the user-defined repository description.

  4. In the User property, enter the user name to connect to this repository database.

  5. In the Password property, enter the password to connect to this repository database.

  6. In the Max Active Connections property, enter the total number of connections that can be created in the connection pool.

  7. In the Server property, enter the name of the server on which this database lives.

  8. In the Port property, enter the port number on the server that the driver must connect to in order to access this database.

  9. In the Database property, enter the name of the database to which you are connecting.

  10. Set the Make Default flag to the desired setting  When this flag is set to on it indicates that this repository is the default repository for the host, so that when users access the Xephr runtime for the host, this is the repository that they access.

  11. Click on the Create Repository button to create the repository.

  12. Click on the Return to Repository link to return to the edit screen for the repository.

Local Xephr QED Database

  1. The Location property displays the current location within the administration console.

  2. In the Repository Name property, enter the user-defined repository name.

  3. In the Description property, enter the user-defined repository description.

  4. Set the Make Default flag to the desired setting  When this flag is set to on it indicates that this repository is the default repository for the host, so that when users access the Xephr runtime for the host, this is the repository that they access.

  5. Click on the Create Repository button to create the repository.

  6. Click on the Return to Repository link to return to the edit screen for the repository.

Edit Repository

To edit an existing repository, left click on the repository name from the repository list, or click on the Return to Repository link when a repository is created.

Depending on the repository database type, the repository properties will be different.

Microsoft SQL Server

  1. The Location property displays the current location within the administration console.

  2. In the Repository Name property, enter the user-defined repository name.

  3. In the Description property, enter the user-defined repository description.

  4. In the User property, enter the user name to connect to this repository database.

  5. In the Password property, enter the password to connect to this repository database.

  6. In the Max Active Connections property, enter the total number of connections that can be created in the connection pool.

  7. In the Server property, enter the name of the server on which this database lives.

  8. In the Port property, enter the port number on the server that the driver must connect to in order to access this database.

  9. In the Database property, enter the name of the database to which you are connecting.

  10. Set the Make Default flag to the desired setting  When this flag is set to on it indicates that this repository is the default repository for the host, so that when users access the Xephr runtime for the host, this is the repository that they access.

  11. Click on the Update Repository Schema from (old schema version) to (current schema version) to update the repository to the current schema and correct the Bad Schema error message.  These version numbers refer to the Xephr schema version, not the Xephr Studio and Runtime version.  

    You will only see this link if the repository schema does not match that of the currently installed Xephr schema.  If your repository displays this link, you need to update it before opening the repository in the Studio.  Otherwise, the repository will be damaged and it will need to be rebuilt.

  12. Click on the Save Repository link to save the repository changes.

  13. Click on the Delete link to delete the repository.

  14. Additional links include:
    Reinitialize
    Load from Version 2.1
    Create Repository Admin User
    Export
    Import
    Compare to other repository

Oracle 9i

  1. The Location property displays the current location within the administration console.

  2. In the Repository Name property, enter the user-defined repository name.

  3. In the Description property, enter the user-defined repository description.

  4. In the User property, enter the user name to connect to this repository database.

  5. In the Password property, enter the password to connect to this repository database.

  6. In the Max Active Connections property, enter the total number of connections that can be created in the connection pool.

  7. In the Server property, enter the name of the server on which this database lives.

  8. In the Port property, enter the port number on the server that the driver must connect to in order to access this database.

  9. In the SID property, enter the service identifier (SID) for the database

  10. Set the Make Default flag to the desired setting  When this flag is set to on it indicates that this repository is the default repository for the host, so that when users access the Xephr runtime for the host, this is the repository that they access.

  11. Click on the Update Repository Schema from (old schema version) to (current schema version) to update the repository to the current schema and correct the Bad Schema error message.  These version numbers refer to the Xephr schema version, not the Xephr Studio and Runtime version.  

    You will only see this link if the repository schema does not match that of the currently installed Xephr schema.  If your repository displays this link, you need to update it before opening the repository in the Studio.  Otherwise, the repository will be damaged and it will need to be rebuilt.

  12. Click on the Save Repository link to save the repository changes.

  13. Click on the Delete link to delete the repository.

  14. Additional links include:
    Reinitialize
    Load from Version 2.1
    Create Repository Admin User
    Export
    Import
    Compare to other repository

PostgreSQL

  1. The Location property displays the current location within the administration console.

  2. In the Repository Name property, enter the user-defined repository name.

  3. In the Description property, enter the user-defined repository description.

  4. In the User property, enter the user name to connect to this repository database.

  5. In the Password property, enter the password to connect to this repository database.

  6. In the Max Active Connections property, enter the total number of connections that can be created in the connection pool.

  7. In the Server property, enter the name of the server on which this database lives.

  8. In the Port property, enter the port number on the server that the driver must connect to in order to access this database.

  9. In the Database property, enter the name of the database to which you are connecting.

  10. Set the Make Default flag to the desired setting  When this flag is set to on it indicates that this repository is the default repository for the host, so that when users access the Xephr runtime for the host, this is the repository that they access.

  11. Click on the Update Repository Schema from (old schema version) to (current schema version) to update the repository to the current schema and correct the Bad Schema error message.  These version numbers refer to the Xephr schema version, not the Xephr Studio and Runtime version.  

    You will only see this link if the repository schema does not match that of the currently installed Xephr schema.  If your repository displays this link, you need to update it before opening the repository in the Studio.  Otherwise, the repository will be damaged and it will need to be rebuilt.

  12. Click on the Save Repository link to save the repository changes.

  13. Click on the Delete link to delete the repository.

  14. Additional links include:
    Reinitialize
    Load from Version 2.1
    Create Repository Admin User
    Export
    Import
    Compare to other repository

Xephr Local QED Database

  1. The Location property displays the current location within the administration console.

  2. In the Repository Name property, enter the user-defined repository name.

  3. In the Description property, enter the user-defined repository description.

  4. Set the Make Default flag to the desired setting  When this flag is set to on it indicates that this repository is the default repository for the host, so that when users access the Xephr runtime for the host, this is the repository that they access.

  5. Click on the Update Repository Schema from (old schema version) to (current schema version) to update the repository to the current schema and correct the Bad Schema error message.  These version numbers refer to the Xephr schema version, not the Xephr Studio and Runtime version.  

    You will only see this link if the repository schema does not match that of the currently installed Xephr schema.  If your repository displays this link, you need to update it before opening the repository in the Studio.  Otherwise, the repository will be damaged and it will need to be rebuilt.

  6. Click on the Save Repository link to save the repository changes.

  7. Click on the Delete link to delete the repository.

  8. Additional links include:
    Reinitialize
    Load from Version 2.1
    Create Repository Admin User
    Export
    Import
    Compare to other repository

Delete Repository

To delete an existing repository, left click on the repository name from the repository list, or click on the Return to Repository link when a repository is created.

  1. When the repository properties are displayed, click on the Delete Repository link.

  2. You will get a pop-up message verifying the delete.

  3. Click on Ok to delete the repository and any hosts using it.

  5. The screen will display this message when the delete is complete.  

  6. Click on the Return to Repository List link.

Reinitialize

Reinitializing a repository will delete all existing data from the repository.

  1. From the Repository Edit screen, click on the Reinitialize link.

  2. Click on the Ok button.

Load from Version 2.1

This link allows you to load a repository from an existing 2.1 repository, converting all of the objects within the repository.  All existing information in the repository will be deleted before the load occurs.

  1. From the Repository Edit screen, click on the Load from Version 2.1 link.

  2. The Location property displays the current location within the administration console.

  3. In the Instance Name field, enter the Xephr version 2.1 instance name from which you are loading this repository.

  4. In the Old Repository field, enter the name of the old repository from which you are loading this repository.

  5. Click on the Convert button.

Create Repository Admin User

This link allows you to create a repository administration user for the repository.

  1. From the Repository Edit screen, click on the Create Repository Admin User link.

  2. The Location property displays the current location within the administration console.

  3. In the First Name field, enter the administrator user first name.

  4. In the Last Name field, enter the administrator user last name.

  5. In the User field, enter the user ID to use to connect as the administrator user.

  6. In the Password field, enter the password to use to connect as the administrator user.

  7. In the Retype Password field, re-enter the password to use to connect as the administrator user.

  8. Click on the Create button to create the administrator user.

Export

This link allows you to export the repository.

  1. From the Repository Edit screen, click on the Export link.

  2. The Location property displays the current location within the administration console.

  3. In the field, enter the location on the Xephr server of the file to which this repository will be exported.

  4. Click on the Export button.

Import

This link allows you to import the repository from an existing exported file.

  1. From the Repository Edit screen, click on the Import link.

  2. The Location property displays the current location within the administration console.

  3. In the field, enter the location on the Xephr server of the file that will be imported.

  4. Click on the Import button.

Compare to other repository

This link allows you to compare the contents of a repository to another repository.  This creates a list of the differences between the two repositories.

  1. From the Repository Edit screen, click on the Compare to other repository link.

  2. The Location property displays the current location within the administration console.

  3. In the pop-list, select the repository to which you wish to compare the current repository.

  4. Click on the Compare button.

  5. The repositories will be compared and the information will be displayed on the screen.

 

Xephr is a registered trademark of NDS Systems, LC.

Copyright © 2007 NDS Systems LC.