Toad Intelligence Central

Seamlessly connect data, files and users for improved collaboration.

Improve collaboration and sharing while ensuring data governance

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.

Features

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.

Specifications

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

Hardware

Ensure your hardware is appropriate for the expected usage.
ConfigurationConnected users1Active users2Logical processors3Memory

Program data/

Toad Intelligence Central4

Network
capacity

Desktop201-528GB500GB

100 Mbps

Small server506–15432GB2TB dedicated data disk or striped over 2-3 spindles200 Mbps
Large server10016-30864GB4TB striped over 3-4 spindles400 Mbps

NOTE:

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

Software

Operating system

Windows 10 (64-bit)

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 on the Toad Intelligence Central server host computer.

DB2

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

MySQL

MySQL Connector/ODBC 5.1.6

Oracle

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

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

Teradata

Teradata ODBC driver
Teradata .Net Data Provider

Other ODBC

32-bit, System DSN

Data connectivity license and data source connections

A valid data connectivity license supports the following data sources:
Business Intelligence

Dell Boomi

Azure DataMarket (Flexible query data sets only. Fixed query data sets are not supported.)

Google Analytics

Oracle Business Intelligence Enterprise Edition 10g and 11g

SAP BusinessObjects 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; HiveServer2 is 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

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
  • Apache HBase verified against versions 0.89, 0.90.3 and 0.98.6
  • MongoDB verified against versions 2.0.1, 2.6, 2.6.5 and 3.0
  • Amazon DynamoDB

Toad Intelligence Central Web Server

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

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: version 9 and above. Compatibility View not supported.
  • Chrome: latest stable version
  • Firefox: latest stable version
  • Safari: latest stable version (Safari 8 at time of release)

Toad Intelligence Central Admin Console

Install Toad Intelligence Central Admin Console on the same host computer as Toad Intelligence Central and/or a host 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 server.

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

Screen

Minimum resolution: 1280x1024

DPI scaling is supported for 100 percent (smaller) and 125 percent (medium), but not 150 percent (larger), 200 percent (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.

Videos