Introduction
A data source isAmetys 's entry point into the information system. For example, a data source may include all the users of a site and their distribution in different populations.
The "Data sources" tool lets you manage connections to the various data sources (Database, Directory LDAP) used by CMS.
Display data sources
In the Administration tab, click on the Data sources button:
The Data Sources tool opens. You'll find a list of existing data sources, sorted by type:
Add a data source
To add a new data source, click on the "New database SQL" or "New directory LDAP" button, depending on the type of data source you wish to create:
Selecting this action will not create a new data source, but link an existing one to the administration interface.
You can then connect your sites to one of your data sources.
New source SQL
Specify database connection information:
- The data source name, which will be displayed when a data source is requested,
- An optional description,
- Database type (Derby, HSQLDB, MySQL, Oracle or PostGreSQL)
- theURL database server connection
- the user name used for connection
- the password used to log in
- check the Private source box if you want this data source to be private. It will only be visible in the administration interface if this is the case.
The Connect to database button SQL is used to check that the information you have entered allows you to establish a connection to the database.
If you are using an Oracle database, you may need to add the JARJDBC driver file to your application's library directory.
To download the driver, click here.
New directory LDAP
Specify directory connection information LDAP :
- The data source name, which will be displayed when a data source is requested,
- An optional description,
- l'URL ddu serveur LDAP,
- check the Secure connection box if you wish to use the 'ldaps' protocol rather than 'ldap' to establish the directory connection,
- the basic DN for all directory accesses,
- how alias entries are dereferenced:
- Always: always dereference aliases,
- Never: never dereference aliases,
- During resolution: dereference aliases only during name resolution,
- After resolution: dereference aliases only after name resolution.
- check the Follow references box to follow references in search results (mainly for dynamic LDAP groups),
- the type of authentication used between the application and the LDAP directory (anonymous or simple),
- the full DN of an all-power user in the LDAP directory,
- this user's password,
- check the Private source box if you want this data source to be private. It will only be visible in the administration interface if this is the case.
Modifying a data source
Once created, it is of course possible to modify the data source. Select the data source from the list, then click on the Modify button:
You can then modify all the characteristics of the data source.
Delete a data source
A data source can only be deleted if it is not used by the application.
If a data source is currently in use, a check mark appears in the "Used" column and the delete button is grayed out.
To delete a data source, you must first "disconnect" this source (no general configuration or site parameter must refer to this source).
Define a data source as the default data source
You can define a data source as the default data source. In this case, this data source will be preselected each time a data source is selected ( CMS configuration, site creation, population creation, etc.).
Only one default data source can be selected for each source type.
Select the data source from the list, then click on the "Set as default data source" button to define your default data source.
Open a data source
You can explore the contents of "Database" data sources by clicking on the "Open" button.
This feature is only available if your CMS application uses the plugin "Datasources Explorer" http://releases.ametys.org/releases/org.ametys.plugins /datasources-explorer/
Here's an overview of how to view a table in a data source:
This tool is for exploration only, and cannot be used to modify the content of a data source.
Back to top