TouchGraph Navigator 2, Welcome!
Licensing and Support
Samples Licensing
Installation
System Requirements
Navigator Web Installation
Applet Launcher Page
TouchGraph Navigator Overview
Menus
File Menu
Export Data dialog
Export Image dialog
Add Search Entity dialog
Settings Menu
Edit Menu
View Menu
Tools Menu
Help Menu
Definitions
Navigator 2: New Features
Loading Wizard
Select Input
Excel
CSV / TSV
MCSV
Navigator DB API
NavigatorDbApi Script
MySQL
Data Types & Delimiters
Entities & Relations
Choose A Table
Edit Entity
Edit Relation
Dynamic Relations
Co-occurrences
Dynamic Attributes
Aliases
Settings
Names - Types / Attributes
Names - Entity Labels
Filter - Inclusion
Filter - Attribute Filters
Add Filter Dialog
Node - Colors
Node - Label / Image
Node - Halo Size / Shape
Node - Node Tags
Edge - Colors
Edge - Width / Pattern
Edge - Tags / Arrows
Graph Layout
Graph Panel
Nodes, Edges
Graph Interaction
Connected Components
Zooming, Spacing
Graph Toolbar
Color Chooser Dialog
Cluster Dialog and Algorithm
< Previous page Next page >

Navigator DB API

Navigator DB API
 
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.