|

Toad Intelligence Central

Prepare your business for the holiday rush.
For a limited time, get Office Home & Business included on select PCs and Windows Server OS included on select servers. Shop Now

Seamlessly connect data, files and users for improved collaboration.

Easily and securely share information across your team.


 
Toad Intelligence Central

 

Simplified file sharing and data provisioning across data analyst teams

Simplify data prep, provisioning, collaboration and sharing – and experience a time savings of up to 40%. Toad Intelligence Central is an easy–to–administer, IT managed, self–service data and file sharing server–based application that transfers power back to your business without a big price tag. Improve collaboration between 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 that any Toad user can use. It’s time to connect with Toad.

Features

Artifact publishing
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, 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/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, such as Microsoft®Excel, Tableau®, or Qlik® Sense™ etc.

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


    Configuration Desktop
    Connected users: 20
    Active users: 1-5
    Logical processors: 2
    Memory: 8GB
    Program data/Toad Intelligence Central: 500GB
    Network capacity: 100 Mbps

    Configuration Small server
    Connected users: 50
    Active users: 6–15
    Logical processors: 4
    Memory: 32GB
    Program data/Toad Intelligence Central: 2TB dedicated data disk or striped over 2-3 spindles
    Network capacity: 200 Mbps

    Configuration Large server
    Connected users: 100
    Active users: 16-30
    Logical processors: 8
    Memory: 64GB
    Program data/Toad Intelligence Central: 4TB striped over 3-4 spindles
    Network capacity: 400 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.

    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 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)
    Teradata ODBC driver
    Teradata .Net Data Provider
    Other ODBC 32-bit, System DSN

    Data connectivity license and data source connections


    Business Intelligence
    A valid data connectivity license supports the following data sources:
    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.

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

    Detailed requirements


    Download free trial
    to see the full list of system requirements.
Documents Documents
Download printable materials to gain insight on how this product can help you simplify IT challenges.
   
Events Events
Peruse webcasts and in-person activities near you to explore the technology behind this product.
   
Community Community
Get the most from this product as you join your peers and Dell experts to access tools and learn best practices.
Dell Software | Contact Us

Contact a Dell Expert

Get help with all your business needs.

Learn More
close
 
 
P61-CS03