Datasource Example

After Xephr® has been installed, and a repository has been created, the first step after you log in is to create a datasource and assign it to your repository.

Datasource properties are dependent upon the database type selected.

Datasource properties should not be modified unless absolutely necessary as it can have dire effects on the Xephr to database connections and performance.

Xephr is a registered trademark of NDS Systems, LC.

See Also

Datasources

Creating Datasources

In the following example, we are going to set up a datasource for an Oracle 9i database, from which we will get the data displayed on our entities.  The properties displayed are determined according to the database type selected.  

  1. In the Explorer Tree, select the Datasource Information object.

  2. Right click on the Datasource Information object and select Create Datasource.

  3. The Creating Database Datasource wizard will be displayed.

  4. Leave the Category pop-list set to Database Datasource.

  5. Set the Type pop-list to Oracle 9i for the database type.

  6. In the Name property, enter the name of the datasource.  For this example, enter PRODUCTION as the name of the datasource.

  7. In the Description property, you can enter a user-defined description of the datasource.  For this example, enter Xephr production database.

  8. In the User property, enter the user used to access this database.  For this example, enter dev7.

  9. In the Password property, enter the password used to access this database.

  10. Leave the Max Active property set to 5.  This is the total number of connections that can be created in the connection pool for this datasource.

  11. Leave the Read Only pop-list set to false, indicating that transactions can be both read from and written to the database.

  12. Leave the Default Catalog property blank as it is not supported by Oracle 9i databases.  

  13. In the Server property, the name of the server on which the database is installed needs to be entered.  The dev7 database is installed on the server named dodb9, so for this example, enter dodb9.

  14. In the Port property, enter the port number on the server that the driver must connect to in order to access this database.  For this example, leave the property set to its default value of 1521.

  15. In the SID property, enter the service identifier (SID) for the database.  The service identifier for the dev7 database is ora9.

  16. Press the Ok button to create the datasource.

  17. The datasource is created.  Press the Save button in the main toolbar.

  18. We need to define the columns in all of the views and tables that should either be ignored or should be passed through during transactions.

  19. In the Explorer Tree, left click on the PRODUCTION datasource to select it, and double click to display the property sheet.

  20. In the Ignore Columns property, enter TENANT_ID.  This is a column to be excluded from selection in tables when the column names query is executed during block creation.  Separate column names by commas.  This column will be completely ignored by Xephr.

  21. In the Passthrough Columns property, enter NDS_VERSION_NO.  This is a column to be excluded from selection in tables when the column names query is executed during block creation, but which will be passed through during transactions.  This column is used for transparent record versioning schemes.

  22. Press the Save button in the main toolbar to save the changes.

  23. Assign the datasource to your repository.  Click on the Repository Configuration object. The fact that it is pink indicates that it is invalid.  Once the datasource has been assigned, it will no longer be invalid.

  24. In the Property Sheet, select your new datasource for the Default Datasource property.

  25. Press the Save button in the main toolbar to save your changes.

Xephr is a registered trademark of NDS Systems, LC.

Copyright © 2007 NDS Systems LC.