Toad Intelligence Central

Seamlessly connect data, files and users for improved collaboration.

Easily share information across your team with Toad™ Intelligence Central. This centralized repository for sharing Toad files and other data enables efficient, well-governed collaboration. Whether you’re gathering and prepping data in Toad Data Point, or sharing PL/SQL code and code analysis reports in Toad for Oracle, you can centrally publish your work in Toad Intelligence Central. This makes it quick and easy to share and view queries, files, objects and datasets — right within the tool. With this server-side component, you’ll reduce the risk of reporting failures, security threats and data loss while ensuring data governance.


Available for both Toad Data Point and Toad for Oracle users:

  • Artifact publishing — Share all Toad artifacts — including diagrams, visual queries, automation, SQL files and more — with other Toad users.
  • Rights management and data governance  — Manage permissions and access rights to shared resources; uphold data governance rules.
  • Automation scripts — Create automation scripts in Toad and publish them to Toad Intelligence Central where they can be scheduled for execution.
  • Active Directory® support — Enable administrators to better manage users and teams, easily add and remove users and create logins.

Additional functionality for Toad Data Point users:

  • Centralized and controlled data access — Gain a single point of access to all your data.
  • Create SQL views — Access data directly from the source through SQL rather than moving data.
  • Data repository — Store datasets or snapshots and schedule regular updates.
  • Data visualization integration — Connect and share data with users of  third-party visualization tools like Microsoft®, Tableau®, Qlik® Sense™ and Spotfire®.
  • Connect with Dell tools — Connect to Dell Boomi® for application cloud integration and Dell Statistica™ for advanced analytics. Combining these tools with Toad provides a robust data management solution.

Additional functionality for Toad for Oracle users:

  • Web-based management reporting — Gain a consolidated view of code quality over time with online Code Analysis reporting.


Before installing Toad Intelligence Central 2.6, ensure that your system meets the following minimum hardware and software requirements.


Ensure your hardware is appropriate for the expected usage.
ConfigurationConnected Users1Active Users2Logical Processors3Memory


Toad Intelligence Central\4


Desktop201 - 528GB500 GB

100 Mbit/s

Small server506 - 15432GB2 TB dedicated data disk or striped over 2-3 spindles200 Mbit/s
Large Server10016 - 30864GB4 TB striped over 3-4 spindles400 Mbit/s


  1. Connected Users defines the maximum number of users who may be connected to Toad Intelligence
    Central at the same time.
  2. Active Users defines the number of connected users who may be executing queries or publishing
    objects at the same time.
  3. Logical Processors defines the number of sockets multiplied by the number of cores.
  4. ProgramData\Dell\Toad Intelligence Central\ stores user information, data source connection information and mappings, snapshots and datasets. The location of this folder is defined when Toad Intelligence Central is installed. The default location for the folder is \ProgramData\Dell\Toad Intelligence Central\.

TIP: For higher numbers of Active Users, disk performance (on ProgramData\Dell\Toad Intelligence Central\) will improve significantly if the data is striped across multiple spindles to enable concurrent I/O operations. This is especially true when Toad Intelligence Central snapshots or datasets are heavily used.


Operating system

Windows® 8.1 (64-bit)

Windows 7 (64-bit) Service Pack 1 (SP1)

Windows Server® 2012 (64-bit)

Windows Server 2008 R2 (64-bit)

Windows Server 2008 (64-bit)

.NET Framework.NET 4.5 or above is required.

ODBC Drivers

To connect to ODBC data sources, supporting ODBC drivers and necessary client files must be installed in the same machine as Toad Intelligence Central.

NOTE: To successfully publish data to Toad Intelligence Central from Toad Data Point theIntelligence Central server must have the same ODBC driver, DSN name, and necessary client files that exist on the Toad Data Point user’s computer. Toad Data Point is installed on the same machine as Toad Intelligence Central to ensure a compatible set of ODBC drivers are installed.


DB2 ODBC driver (included in the Toad Data Point install)
DB2 client
DB2 catalog


MySQL Connector/ODBC 5.1.6


Oracle (32 bit and 64 bit): 11g instant client + ODBC supplement
OCI client
Tnsnames.ora file

SQL Azure

SQL Server Native Client 10.0

SQL Server®

SQL Server Native Client 10.0


Sybase ODBC driver (included in the Toad Data Point install)


Teradata ODBC driver
Teradata .Net Data Provider

Other ODBC

32-bit, System DSN

Data Source Connections

Toad Intelligence Central2.6 can connect to the following data sources:
Business Intelligence

Dell Boomi

Azure DataMarket (Flexible Query datasets only. Fixed Query datasets are not supported.)

Google Analytics

Oracle Business Intelligence Enterprise Edition 10g and 11g

SAP Business Objects Query as a Web Service (QAAWS) XI 3.0, 3.1 and 4.1

Salesforce verified against API V29 - Winter 2014.

SharePoint Lists using Data Services over SharePoint Server 2010 and later via OData

Hive verified against versions 0.10 (CDH4.2) and 0.13. Hive Server 2 is not supported.

Microsoft Analysis Services

OData - Generic for any OData service versions 1, 2 and 3. Version 4 is not supported.

RelationalODBC-compliant databases. See above section on ODBC drivers for details.


Cloud database connections can be made via the Admin Console with views and snapshots published to the Intelligence Central Server. This release supports connections to:

  • Azure Table Services
  • Apache Cassandra™ verified against versions 1.0.5, 1.2.3 and 2.0.9.
  • Amazon SimpleDB™
  • Apache HBase™ verified against versions 0.89, 0.90.3 and 0.98.6.
  • MongoDB™ verified against versions 2.0.1, 2.6 and 2.6.5.
  • Amazon DynamoDB

Toad Intelligence Central Web Server

Use the Toad Intelligence Central installer to install the Toad intelligence Central Web Server on the same machine as Toad Intelligence Central. The minimum requirements of the Toad Intelligence Central Web Server are as follows.
IIS Express

The Toad Intelligence Central Web Server requires Microsoft IIS Express be installed. Installation of IIS Express is included in the installer and will run only if required and by your agreement.


.NET 4.5 or above is required.
ODBC Drivers

Port 80 is reserved for the web port. During installation, you can change this if required.

It is not advisable to install other web servers on the Toad Intelligence Central host.

Ensure the port is open for TCP inbound connection. Ensure the Windows firewall and any other firewalls affecting the Toad Intelligence Central Server host allow access to the Web Server.

Web Browser

Use the Web Server from any of the following web browsers:

  • Internet Explorer®: version 9 and above. Compatibility View not supported.
  • Chrome™ browser: latest stable version
  • Firefox®: latest stable version

Toad Intelligence Central Admin Console

Toad Intelligence Central Admin Console is installed on the same machine as Toad Intelligence Central or a machine with a network connection to Toad Intelligence Central. The minimum requirements of the Toad Intelligence Central Admin Console are as follows.
Operating System

As per Toad Intelligence Central.

NOTE: Toad Intelligence Central Admin Console can be installed on a 32 bit operating system.


Minimum Resolution: 1280x1024

DPI scaling is supported for 100% (Smaller) and 125% (Medium), but not 150% (Larger), 200% (Extra Large) and above.

Other Requirements

Internet access to open the Quick Start Guide.

Download free trial to see the full list of system requirements.