-
Resources
- Forums
-
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.
01:45
Features
Artifact and data sharing
Rights management and data governance
Automation scripts
Active Directory support
Abstract data sources
Data repository
Data visualization integration
Tour
Data and file sharing
Specifications
- Connected users
20
- Active users
1-5
- Logical processors
2
- Memory
8GB
- Program data/Toad Intelligence Central
500GB
- Network capacity
100 Mbps
- 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
- 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.
- 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
Download free trial to see the full list of system requirements.