In ENA, you can export data from the ENA database to a specified target database. Both the ENA and the target database must be the same version of that database. Entuity Support recommends that you first set up the target database and user access permissions before creating the data export jobs. Entuity also recommend that the target database is installed to a separate machine from the Entuity server.
The target database must be configured to allow full access privileges to the user accounts defined within the Data Export Jobs. The user account that access the target database must be allowed to:
- create new tables.
- amend existing table structures by adding new columns.
- update existing data within the tables.
The data structure of a table in the target database is derived from the attributes in the dataset definition. When an attribute is removed from a dataset definition, subsequent data exports do not include data for that attribute's associated database column. Instead, ENA will write a null value. Data Export does not delete columns from target database tables.
To create a target database:
- From the command line, login to the database:
mysql -h host -u user -p
- host is the server name or IP address.
- user is the username.
- Database prompts you for a password. Enter the password.
- Check that the database you want to create does not already exist:
- If the required database does not exist, create the database:
CREATE DATABASE targetDatabase;
- Exit the database:
To grant the Entuity server access to the target database:
Next, you must set up the Data Export user account on and configure the target database to accept database connections from ENA.
- Log on to the server hosting the target database.
- From the bin directory of the database installation, and using a local connection, connect to the database, e.g.:
./mysql -u root -h 127.0.0.1
- Grant the Entuity server permission to access the targetDatabase database:
grant all on targetDatabase.* to user@address identified 'by password';
- targetDatabase is the name of the target database to which ENA exports data.
- user is the account name used by Data Export to establish a connection with the target database.
To test the Data Export access to a target database:
Next, you should test the connection. There are two ways in which you can do this:
- from the command line.
- from the Data Export Job page.
From the command line, enter e.g.:
- ./mysql -uEYEuser -pxyz1234 -h10.44.1.1 -DtargetDatabase -P3306
where 10.44.1.1 is the IP address of the remote server.
From the Data Export Job page:
- Click the Main Menu and then Administration.
- Under the Export section, click Jobs. This will open the Data Export Jobs page.
- Select the job that you want to test.
- Under the Target Database section, enter the database details, where:
- Server is the IP address or resolved name of the server. When the target database is installed to the same server as ENA, you should still enter an IP address or resolved name and not enter Localhost.
- Username is the user account granted access to the target database.
- DB Name is the target name.
- Password is the user account password.
- Click Test Connection.