|
= Process for Hooking Up AHP to Customer Databases = |
|
= Process for Hooking Up AHP to Customer Databases = |
- |
<font size="1">by Brad Galla â last modified Jul 25, 2011 10:29 AM</font>
|
+ |
<font size=1 face="Franklin Gothic Medium Cond">by Brad Galla â last modified Jul 25, 2011 10:29 AM</font>
|
- |
This is a short guide that instructs how to take a database received from a customer and have anthillpro connect to it so that it can be used.
|
+ |
'''This is a short guide that instructs how to take a database received from a customer and have anthillpro connect to it so that it can be used.'''
|
- |
Have customer send fresh dump of database via FTP or Supportal Ticket
|
+ |
== RETRIEVE DATABASE ==
|
- |
Set up instance of Database's application with Database and prepare for usage (open any ports needed to connect; etc.)
|
+ |
* Have customer send fresh dump of database via FTP or Supportal Ticket
|
|
|
+ |
* Set up instance of Database's application with Database and prepare for usage (open any ports needed to connect; etc.)
|
- |
|
+ |
== ASSEMBLE CONNECTION ==
|
- |
ASSEMBLE CONNECTION
|
+ |
# Install the version of anthillpro server that matches the version they were using with their database
|
|
|
+ |
## One method for finding this is analyzing the DB_VERSION table in the database.
|
- |
Install the version of anthillpro server that matches the version they were using with their database
|
+ |
## Use '''derby''' as the installation database; we will change this afterwards
|
- |
One method for finding this is analyzing the DB_VERSION table in the database.
|
|
|
- |
Use derby as the installation database; we will change this afterwards
|
|
|
|
Install an agent that matches that version of the server (if necessary). |
|
Install an agent that matches that version of the server (if necessary). |
|
Download/obtain the driver for the database type that was being used and copy it to the %SERVER_HOME%\lib\ext directory |
|
Download/obtain the driver for the database type that was being used and copy it to the %SERVER_HOME%\lib\ext directory |