Backup and Restore
MANUAL BACKUP / RESTORATION
If you want to install a new version of DigDash Enterprise or migrate to a new environment (transition from a test environment to a production environment, modification of the server machine, ...), you can backup and restore the data of your current environment:
- Users, roles and use groups,
- Dashboards,
- Information portfolios and data models,
- Images, data dictionaries (translations, formats, connections, color palettes ...), etc.
- Data sources: Data sources in the UserDocs user data directory can be saved.
First select the items you want to save. This creates a zip file which you must then restore to the new environment or the new version.
Please note that the files in the DigDash Enterprise installation directory are not saved or restored by our tool, so you must copy them manually if you have made any changes:
- dashboard styles: if you have modified the dashboard styles from the dashboard.css file in the webapps / digdash_dashboard directory, this must be manually copied to the new environment.
- images, logos and icons: if you have modified the files located in the webapps / digdash_dashboard / icons directory, you will have to copy them to re-apply them on your new version.
Save data
- Display the home page:
Start the Internet browser of your choice, then type the URL http: // ServerName: Server Port (example: http: // localhost: 8080 ). The DigDash Enterprise home page appears.
- Click on the Configuration link then Backup management . Click on Save to save your current configuration
- In the login box, enter the user name and password
- Check in each section the items you want to save: See the definition of each item in the appendix .
- Click on Generate then on Download the restoration file to obtain the backup file (.zip file)
Restore data
- Display the home page:
Start the Internet browser of your choice, then type the URL http: // ServerName: Server Port (example: http: // localhost: 8080 ). The DigDash Enterprise home page appears.
- Click on the Configuration link then Backup management . Click Restore to restore a configuration.
- Click on Browse to select the zip file corresponding to your backup then click on Load
- The list of database connections present in the backup file is displayed so that you can update them if necessary.
Migration of connections and document servers:
In order to facilitate the migration of these elements, it is possible to modify their identifiers so that they are identical between the development and production servers.
During the first migration between a development server and a production server:
- Perform a full backup of the development environment
- Restore the backup to the production environment
- Modify connection strings to databases and file servers on the production environment (from the connection manager and the document server manager in Enterprise Studio).
During the following migrations to production environments:
- Selectively backup data: data models, portfolios, modified or new dashboards, ...
Do not save the file containing the connections (dbcnxrepository.xml) as well as the file containing the document servers (serverurlrepository.xml) even if these contain modifications
- Restore the backup to the production environment
- If changes have been made to connections or file servers in the development environment, post them manually to the production environment.
For new connections or new document servers, report the identifier used on the development environment.
To report the connection identifier, open the connection managers ( Tools menu \ database connections manager in Enterprise Studio). Edit the connection to modify then click on Edit to modify the identifier:
To report the identifier of a document server, open the connection managers ( Tools menu \ document servers manager in Enterprise Studio). Edit the document server to modify, then click Edit to modify the identifier:
AUTOMATION
You can automatically backup your environment. For this, DigDash Enterprise provides a backuptools.jar backup tool to run on the server.
This jar file is located in the <tomcat webapps> / ddenterpriseapi / WEB-INF / lib directory and must be used from this location (because it uses other jar files located in the same directory).
The options are:
- -url server_url: DigDash Enterprise server URL (default http: // localhost: 8080 )
- -domain dd_domain: domain name of the DigDash Enterprise application (by default ddenterpriseapi)
- -login user_login: DigDash Enterprise administrator login
- -pass user_pass: DigDash Enterprise administrator password
-export or -backup: save the DigDash Enterprise configuration in a zip file - -import or -restore: restore the configuration of DigDash Enterprise from a zip file
- -file zipfile: path of the backup file to restore
- -ldap: backup or restore of the LDAP directory
- -noldap: no backup or restore of the LDAP directory
- -help: display help
- -debug: display error messages
Examples of use:
java - jar backuptools . jar - admin login - admin pass - export - noldap
java - jar backuptools . jar - url http : // localhost: 8080 -domain ddenterpriseapi -login admin -pass admin -export -ldap -file C: \\ backup.zip
java - jar backuptools . jar - url http : // localhost: 8080 -domain ddenterpriseapi -login admin -pass admin -import -ldap -file C: \\ backup.zip
If you make a backup of your environment a backup file is created. This file has the name datedujour_backup.zip (for example 20141219_backup.zip if the backup was performed on December 19, 2014) and is located in the directory containing the DigDash Enterprise data (By default, Application Data / Enterprise Server / <domain> / config .)
DigDash Enterprise also provides a file “backup_export.bat” (interactive file with prompts) allowing you to save your environment:
- This file is located in the DigDash Enterprise installation directory. When executing the file, you must indicate:
- the URL of your server: by default, http: // localhost: 8080
- the DigDash Enterprise domain: by default, ddenterpriseapi
- user login: by default, admin
- the user's password: by default, admin
- whether or not to save the LDAP dictionary (users and roles): enter y to save and n not to save.
A backup file is created. This file has the name <datedujour> _backup.zip (for example 20130710_backup.zip if the backup was performed on July 10, 2013) and is located in a directory containing the DigDash Enterprise data. By default, Application Data / Enterprise Server / <domain> / config .
For example on Windows 7:
C: \ Users \ <user> \ AppData \ Roaming \ Enterprise Server \ ddenterpriseapi \ config
To restore a backup automatically, you can also use the backup_import.bat file. You must enter the same parameters as for backup_export (instead of indicating if you want to save the LDAP directory, indicate if you want to restore it). Also specify the name of the backup file (by default, it must be in the directory where the backup_import.bat file is included).
APPENDIX - LIST OF ELEMENTS OF A BACKUP
Here is the list of elements that can be saved / restored as well as their description.
When the element corresponds to a file, it is located in the data directory of the DigDash domain. For example: <AppData> / Enterprise Server / ddenterpriseapi. The file paths mentioned below are relative to this directory.
Element | Description |
Users Data relating to each user. | |
LDAP | User information stored in LDAP:
|
Wallets | Information portfolio and user flow File: /server/<user>/config/wallet.iwt |
Dashboards | User dashboards File: /server/<user>/config/dashboard.xml |
Data models | User data models File: /server/<user>/config/tabledatamodelrepository.xml |
Passwords | User passwords File: /server/<user>/config/passwordrepository.xml |
Roles Data relating to each role. | |
LDAP | Role information stored in LDAP:
|
Wallets | Information portfolio and role flow File: /config/wallet_<Id_Role>.xml |
Dashboards | Role dashboards File: /config/dashboard_<Id_Role>.xml |
Data models | Role data models File: /config/tabledatamodelrepository_<Id_Role>.xml |
Passwords | Role passwords File: /config/passwordrepository_<Id_Role>.xml |
Authorization groups Definition of authorization groups provided by DigDash or added by the user. Authorization groups are only stored in LDAP. | |
<Name of authorization group> | Definition of the authorization group:
|
Server common files List of files common to all users and roles. | |
Server common files / System files | |
serversettings.xml | DigDash Enterprise server settings:
File: /config/serversettings.xml Recommendations: Do not carry this file between several different configurations |
system.xml | System information and certain hidden parameters described in the document guide_avance_systeme File: /config/system.xml Recommendations: Do not carry this file between several different configurations |
userssettings.xml | User settings including the settings you have created. File: /config/userssettings.xml |
Server common files / Dictionaries Settings common to all users and roles. These files may or may not be present depending on the parameters used by the flows or the data models. | |
colortablerepository.xml | Dictionary of color palettes Scope: Flow configuration File: /config/colortablerepository.xml |
cssrepository.xml | Dictionary of CSS styles Scope: Flow configuration File: /config/cssrepository.xml |
clustersettings.xml | Configuration of cluster mode (advanced) Scope: System configuration File: /config/clustersettings.xml |
DDComments.h2.db | Database of comments on dashboard data streams and models. Scope: Display of dashboards and flows File: /config/DDComments.h2.db |
dbcnxrepository.xml | Dictionary of database connections (advanced) Scope: Configuration of data models (connections to data sources) File: /config/dbcnxrepository.xml |
favoritedevicesrepository.xml | Dictionary of devices used for synchronizing flows Scope: Export of flows File: /config/favoritedevicesrepository.xml |
flowsnapshotrepository.xml | Dictionary of user views of flows used in BI self-service Scope: Display of flows (editable in the dashboard) File: /config/flowsnapshotrepository.xml |
formatrepository.xml | Dictionary of number and date formats Scope: Configuration of data models and flows File: /config/formatrepository.xml |
jsfunctionrepository.xml | Dictionary of javascript functions used in derived measurements, filters, source transformations… Scope: Configuration of data models and flows File: /config/jsfunctionrepository.xml |
hierarchyrepository.xml | Dictionary of shared hierarchies used by data model dimensions Scope: Configuration of data models File: /config/hierarchyrepository.xml |
navigationsentencerepository.xml | Dictionary of phrases created for video and text navigation of text streams Scope: Flow configuration File: /config/navigationsentencerepository.xml |
passwordrepository.xml | Dictionary of global passwords. (Deprecated) File: /config/passwordrepository.xml |
serverurlrepository.xml | Dictionary of document servers used in DigDash Enterprise Scope: Configuration of data models File: /config/serverurlrepository.xml |
vectoriconrepository.xml | Dictionary of vector icons used by "Infographic" graphics Scope: Flow configuration File: /config/vectoriconrepository.xml |
vizmodelrepository.xml | Dictionary of shared presentation models associated with flows. Scope: Flow configuration File: /config/vizmodelrepository.xml |
Server common files / Translation files Translation dictionaries group messages in different languages. Each following translation file can be accompanied by a file corresponding to the chosen language. For example, the files dm.properties, dm_fr.properties, dm_es.properties are the translations of messages corresponding to the English language (default), French and Spanish. | |
dashboard.properties | Dictionary of translations used in the elements specific to the dashboard:
File: /config/dashboard.properties /config/dashboard_<lang>.properties |
dm.properties | Translation dictionaries used in data models and flows. Scope: Display of data model elements and streams Files: /config/dm.properties, /config/dm_<lang>.properties |
dmvoc.properties | Dictionary of spoken values for expressions of data models. Scope: Export video stream (optional) Files: /config/dmvoc.properties, /config/dmvoc_<lang>.properties |
dmtag.properties | Dictionary of synonyms created in data models. These dictionaries are used by the search function of the dashboard: query in natural language. Scope: Text search in the dashboard Files: /config/dmtag.properties, /config/dmtag_<lang>.properties |
<domain> .properties dashboard (Deprecated) | Dictionary of dashboard elements (name of pages,…). These files are deprecated and do not have to be backed up / restored |
Server common files / Others Other files related to the configuration of dashboards. | |
Pictures (* .png, * .jpg, * .gif ...) | List of images added from the dashboard editor. Folder: / config / web / public /, / config / web / public / <Id_Role> /, / config / web / public / <user> / |
Styles default.css * .css | Files containing the custom styles of the dashboard. CSS style sheets can be edited in the dashboard editing interface. File: /config/web/public/default.css, /config/web/public/*.css |
js-const.js | Constants of the DigDash Enterprise server (properties listed on the "Server configuration> Advanced" page, "Constants" section) + export parameters ("Export options" section) File: /config/web/session/js-const.js, |
js-default.js | Dashboard custom script file. This file can be directly edited from the dashboard editing interface. File: /config/web/session/js-default.js |
Server common files / Data sources Data sources in the UserDocs file server. The files contained in this server can be integrated into the backup |