The Navigator Database API provides an easy way to load data from a database.  This input type requires that a NavigatorDpApi PHP script be installed on the server to which the connection is going to be made.

 

 

Database Type: The TouchGraph API uses the ADOdb library to enable connections to multiple database types such as MySql, MS Sql and Oracle. (Full list of databases)

 

API URL: The location of the associated Navigator DB API script placed on the server.

 

Database Host: The name of the host database as accessed by the script.  This should not start with http://

 

Database Name:  The name of the database accessed by the script.

 

User / Password:  The login details for the database.

 

1st Entity Type / 1st Entity Id: These are the type and id of the initial entity that gets passed to the API in order to return back a filtered result set.  In the server side script a WHERE SQL clause can be customized to return appropriate results for the specified entity type / id.

 

Result Limit:  Limits the number of results returned from each table.

 

Important: The Host, Database Name, User, and Password should be hard coded into the TouchGraph API script rather than specified as parameters.  Otherwise these values will be stored inside the project file, which can potentially lead to their discovery and malicious use.