For the best web experience, please use IE11+, Chrome, Firefox, or Safari

Toad Intelligence Central

Become data-driven with data preparation and data provisioning across data analyst teams. Today’s always-on economy is generating data at ever-increasing rates. You know it’s essential to be data-driven and use that data to react and innovate quickly so you can outpace your competition. What if you could simplify data preparation and data provisioning? What if you could more easily perform database analysis and share data insights with data analysts across teams? What if you could do all this and realize a time savings of up to 40%?

Used in conjunction with Toad® Data Point, Toad Intelligence Central is a cost-effective, server–based application that transfers power back to your business. Improve collaboration among Toad users through secure, governed access to SQL scripts, project artifacts, provisioned data and automation workflows. Easily abstract structured and unstructured data sources through advanced data connectivity to create refreshable datasets for use by any Toad user.

Prepare for today’s data and you’re ready for tomorrow’s challenges 01:45

Features

Artifact and data sharing

Share all Toad artifacts — including entity relationship diagrams, query files, automation scripts, SQL files and more — with other Toad users.

Rights management and data governance

Manage permissions and access rights to shared folders and files for a governed working environment.

Automation scripts

Create automation scripts in Toad Data Point, publish them to Toad Intelligence Central and schedule them for execution on the server.

Active Directory support

Enable administrators to better manage users and teams, plus easily add or remove users.

Abstract data sources

Access data directly from the source through built-in connectivity to relational and non-relational sources.

Data repository

Store datasets or snapshots and schedule regular updates.

Data visualization integration

Connect and share data with users of third-party visualization tools, including Microsoft Excel, Tableau, or Qlik Sense and others.

Tour

Data and file sharing
User and team management
Administration panel
Artifact publishing from Toad Data Point
Third-party data access
Data and file sharing

Data and file sharing

Share and view queries, files, objects, automation scripts and more with other Toad users.

Specifications

Connected users

20

Active users

1-5

Logical processors

2

Memory

8GB

Program data/Toad Intelligence Central

500GB

Network capacity

100 Mbps

NOTE:

  • Connected users defines the maximum number of users who may be connected to Toad Intelligence
    Central at the same time.
  • Active users defines the number of connected users who may be executing queries or publishing
    objects at the same time.
  • Logical processors defines the number of sockets multiplied by the number of cores.
  • Program data/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 data sets are heavily used.

Operating system
  • Windows 8.1 (64-bit)
  • Windows 10 (64-bit)
  • Windows Server 2012 (64-bit)
  • Windows Server 2016 (64-bit)
  • Windows Server 2019 (64-bit) 
.NET Framework

.NET 4.7.2 or later is required.

Additional Software 

Update for Universal C Runtime in Windows. See KB2999226 or Visual C++ Redistributable for VS 

ODBC Drivers

To connect to ODBC data sources, supporting ODBC drivers and necessary client files must be installed on the Toad Intelligence Central server host computer.

  • 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 Native Client 10.0
  • Sybase ODBC driver (included in the Toad Data Point install)
  • Snowflake ODBC driver 2.24.2 (or later) 
  • Teradata ODBC driver
  • Teradata .Net Data Provider
  • Other ODBC 32-bit, System DSN
Business Intelligence

A valid data connectivity license supports the following data sources:

  • Google Analytics
  • Oracle Business Intelligence Enterprise Edition 10g, 11g and 12c
  • SAP BusinessObjects Query as a Web Service (QaaWS) XI 3.0, 3.1 and 4.1
  • Salesforce
  • SharePoint Lists using Data Services over SharePoint Server 2013 via OData. Also, SharePoint Online.
  • Hive versions 0.10 (CDH 4.2), 0.13, 1.1 (CDH 5.12), 2.1.0. HiveServer2 is supported.
  • SQL Server Analysis Services 2016
  • OData – Generic for any OData service versions 1, 2, 3 and 4 
Relational

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

Cloud
  • Azure Table Services
  • Apache Cassandra™ versions 1.0.5, 1.2.3, 2.0.9, 2.1.7, 3.0.5, 3.4 and 3.11.0
  • Apache HBase™ versions 0.89, 0.90.3, 0.98.6 and 1.2.6
  • MongoDB™ versions 2.0.1, 2.6, 2.6.5, 3.0, 3.2.4, 3.4.6 and 4.0.0
  • Amazon DynamoDB
  • Cloudera Impala 2.9.0
  • SimpleDB 

Use the Toad Intelligence Central installer to install the Toad Intelligence Central Web Server on the same host computer as Toad Intelligence Central. The minimum requirements of the Toad Intelligence Central Web Server are as follows.

Port

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 server 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

Access Toad Intelligence Central from any of the following web browsers:

  • Internet Explorer: 10 (or later). Compatibility View not supported.
  • Chrome: latest stable version
  • Firefox: latest stable version
  • Safari: latest stable version

 

Beginning with Toad Intelligence Central 4.3, the Admin Console is no longer required and is not included in the Toad Intelligence Central installation. The administrative functionality of the Admin Console is now superseded by the Web Server (Web Console). The activity of mapping/editing data objects is best performed through Toad Data Point.

After installing Intelligence Central 4.3 or later, it is recommended that you uninstall any earlier version of the Admin Console as some functionality may no longer be supported.

 

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

Support & Services

Product Support

Self-service tools will help you to install, configure and troubleshoot your product.

Support Offerings

Find the right level of support to accommodate the unique needs of your organization.