Q. Can XErase integrate with my existing SQL or MYSQL database?
A. Yes, as long as you have the premium subscription or are using PXE boot licenses.
Configuring Database in XErase
1. Select the Database Configuration option under the Premium Menu.
2. Type in your server name, database name, username and password and all your tables will be presented to you.
3. Hit the Save As button and give your database profile a name.
4. Select the desired table you wish to inject data into and select each desired field and match it to one of the the EPS fields then hit add.
5. Once you have mapped all fields hit the update button.
6. To use the database navigate to Customize->Interface->Program Settings, turn on Auto Generate Database Entries and select your database profile.
Configuring Database in License Server
1. Select the Database Configuration graphic on the left hand side of license server.
2. Type in your server name, database name, username and password and all your tables will be presented to you.
3. Hit the Save As button and give your database profile a name.
4. Select the desired table you wish to inject data into and select each desired field and match it to one of the the EPS fields then hit add.
5. Once you have mapped all fields hit the update button.
6. To use the database navigate to your desired PXE profile and select Program Settings, turn on Auto Generate Database Entries and select your database profile.
Notes for SQL
For SQL databases, use ODBC to map your server into Microsoft’s SQL system.
1. Hit the windows button and type ODBC and select ODBC32
2. Click System DSN tab and hit the add button
3. Select SQL Server and hit the finish button
4. Give this data source a name. This is the name you will use as the server name in step 2 for both configurations above.
5. Add the name of the server (IP address or url) you wish to connect to and hit next
6. Choose your authentication method (username and password or windows authentication). Remember this because you will need it for step 2 above.
7. Test your connection and make sure it works. Then use the data in the above process.