Creating a Chart from a Database
TeamOrgChart can create organization charts from a database hosted by yourselves. In order to do this the database must be "Internet" facing and accessible from the TeamOrgChart.Com IP address ( 126.96.36.199 ).
Choosing a Data Source
From the home page select the Create New Chart option. If you cannot see this option then you do not have administration rights to TeamOrgChart. You will need to contact your administrator and ask for rights to be granted to you.
Name the Chart & Choose the Data Source
Enter the name of the organization chart into the Chart Name text box and select Connect to an External SQL Server from the data source options.
Configure the Server Credentials
To connect to the server you will need to supply the following information:
- A valid database connection string.
- A valid SQL statement that will return the data required for the chart. This can be either a stored procedure or a SELECT statement.
- The name of the column that contains the primary key information. The primary key uniquely identifies each person within the organisation.
- The name of the column that contains the manager information.
- A valid SQL statement that will return the data from a user search query. For example if an user searches for 'John' the query should return all the rows that match John.
Once you have supplied the information press Test Connection. This will connect to the database and execute the SELECT query.
After successfully connecting to the database Save Changes to move to the next configuration step.
Choosing the Columns to Display
After defining the connection you will be required to pick the columns that will be shown on the chart.
Choose the relevant fields from the list and Save Changes. The chart configuration is now complete. You will now be able to style and view the chart.