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 ( 137.117.241.226 ).

 

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.

 

How can we help?

Our products

SharePointOrgChart

  • For Microsoft SharePoint
  • Download, install & configure
  • $750
 

TeamOrgChart

  • For Office 365 and Microsoft Azure
  • Online, interactive service based application
  • From $100
 

OrgChartComponent

  • For ASP.NET websites and applications
  • Versatile & feature rich
  • $200 +