Toad Data Point
在线购买产品,请访问shop.quest.com
在线购买 »
通过提供免费培训和展示新功能,Toad World致力为您的Toad体验增添价值——同时,
还为您提供关于如何节省时间的技巧和建议。
访问社区 »

Toad Data Point

访问、整合及提供数据的正确数据分析工具

Toad™ Data Point是一款跨平台查询和数据整合工具,可简化数据的访问和分析,并为专业数据管理人员提供数据操作。 该数据分析工具可提供几乎不受限的数据连接性、桌面数据整合、生成可视型查询,以及工作流程自动化。

功能

不受限连接性——几乎可连接至任何数据源,可从传统的关系型源(包括Oracle、SQL Server、Sybase、DB2、Teradata、Access以及任何ODBC合规平台)连接至非数据库源(包括Excel和SharePoint)和非SQL系统(包括Salesforce.com、Business Objects以及Oracle Business Intelligence平台)。 能够运行针对上述任意源的SQL查询。

数据整合——通过夸平台SQL查询,简化数据整合。

自动化引擎——自动执行及安排日常任务以提高您的工作效率;建立先进的工作流程以支持高级项目。

本地数据存储——利用嵌入式数据库,灵活敏捷地管理您的数据集。

SQL IDE——在功能强大且可自定义的编辑器中编写SQL语句,该编辑器提供SQL Complete、自动格式化、即时调用SQL以及多种其他功能,让编写SQL更为简单。  

Visual Query Builder——运用简单的拖放界面,创建高级单平台和跨平台SQL查询。

高级分析库——通过SQL访问高级数学和统计功能。

数据可视化——浏览交互式数据视图以更好地理解您的结果集。

比较和同步——比较和同步不同数据源中的数据,以确保数据的一致性和有效性。

数据清理区——通过直观的界面转换及清理您的结果集(增加计算、列、分组、查找重复项等)。

ER图示化工具和数据浏览器——直观地显示和注解表格关系,以创建您自己的关系模板;查看主从关系;浏览数据库表格和对象。 

图标和报告——设计专业的图表和图形分享您的数据结果。

导入/导出工具向导——高效地加载和卸载数据。 您可以轻松地将数据导出,并以Excel、.CSV、.TXT、HTML、PDF等多种文件格式发布。

系统要求

System Requirements

Client Requirements

Before installing Toad, ensure that your client system meets the following minimum hardware and software requirements:

Platform

1 GHz Processor (recommended minimum)

Memory

512 MB of RAM minimum, 1 GB recommended
Note: The memory required may vary based on the following:

  • Applications that are running on your system when using Toad
  • Size and complexity of the database
  • Amount of database activity
  • Number of concurrent users accessing the database

Hard Disk Space

1.33 GB to install Toad
475 MB to run Toad Professional edition, 350 MB to run Toad Base edition
Note: The disk space required may vary based on the edition of Toad selected for installation.

Operating System

Windows Server 2003
Windows XP Professional (32-bit or 64-bit)
Windows Vista (32-bit or 64-bit)
Windows Server 2008 (32-bit or 64-bit)
Windows 7 (32-bit or 64-bit)
Windows Server 2012
Windows 8 (32-bit and 64-bit)

.NET Framework

Microsoft .NET Framework 4.0
Note: The .NET Framework Client Profile is not supported.
Teradata .NET Data Provider
You must install the Teradata .NET Data Provider (13.10 or later) to use a Teradata native connection in Toad.
Note: To use a Teradata connection in a cross-connection query, you must also install a Teradata (13.10 or later) ODBC driver.

Database Client

Existing DB2 Client Support (DB2 native provider only)
Toad installs a DB2 9.7 (fix pack 6) client as part of the installation process. The DB2 9.7 client can co-exist with an existing DB2 8 client, but is incompatible with a DB2 7 client. If a DB2 7 client already exists on your computer, the Toad installation stops and cannot complete. To resolve, first upgrade to the DB2 8 client. Then restart the Toad installation to avoid losing functionality in some DB2 native tools.
Existing 64-bit DB2 Client (DB2 native provider only)
If you have a 64-bit DB2 client installed, you must install Toad using the ToadDataPoint_64bit_Client.exe.
Oracle Client
Toad can connect to Oracle using Direct Connect (no need for an Oracle Client) or can connect using an Oracle Client or Oracle Instant Client. However, if you want to use LDAP, you must install an Oracle Client. Toad supports 9i or later Oracle Clients and Oracle Instant Clients.
Notes:

  • You cannot use Oracle Direct Connection in a cross-connection query.
  • To use an Oracle connection in a cross-connection query, you must install an Oracle Client (full install) or you must install the Oracle Instant Client plus the Oracle ODBC driver.

Additional Requirements

Web Browser
Microsoft Internet Explorer 6.0 or later

Server Requirements

Before installing Toad, ensure that your server meets the following minimum hardware and software requirements:

Operating System

Oracle Native Database Provider
IBM AIX 5.1, 5.2, 5.3
HP-UX 11i 1.5, 2 (32-bit or 64-bit)
Red Hat Enterprise Linux AS release 3 and 4 (32-bit or 64-bit)
Solaris 7, 8, 9, 10 (32-bit or 64-bit)
SuSE 7, 8, 9
Windows 2003 (32-bit or 64-bit)
Windows XP
SQL Server Native Database Provider
Windows Server 2000 Service Pack 4 or later
Windows 2000 Professional Edition Service Pack 4 or later
Windows XP (32-bit with Service Pack 2 or later and 64-bit)
Windows Server 2003 (32-bit or 64-bit) Service Pack 1 or later
Windows Vista (32-bit or 64-bit)
Windows Server 2008 (32-bit or 64-bit)
Windows Server 2008 R2 (64-bit)
Windows 7 (32-bit or 64-bit)
DB2 for z/OS Native Database Provider
z/OS (V1R6 Base Services [5694-A01] or later)
DB2 for LUW Native Database Provider
IBM AIX 5.1, 5.2, 5.3, 6.1
HP-UX 11i 1.5, 2 (32-bit or 64-bit)
Red Hat Enterprise Linux AS release 3 and 4 (32-bit or 64-bit)
Solaris 7, 8, 9, 10 (32-bit or 64-bit)
SuSE 7, 8, 9
Windows 2000, 2003 (including 64-bit), 2008, XP, Vista, Windows 7
MySQL Native Database Provider
Windows 2003
Windows Server 2000 Service Pack 4 or later
Windows 2000 Professional Edition Service Pack 4 or later
Windows XP (32-bit with Service Pack 2 or later and 64-bit)
Windows Server 2003 (32-bit or 64-bit) Service Pack 1 or later
Windows Vista (32-bit or 64-bit)
Windows Server 2008 (32-bit or 64-bit)
Windows Server 2008 R2 (32-bit or 64-bit)
Windows 7 (32-bit or 64-bit)
Sybase Native Database Provider
Windows XP (32-bit with Service Pack 2 or later and 64-bit)
Windows Server 2003 (32-bit or 64-bit) Service Pack 1 or later
Windows Vista (32-bit or 64-bit)
Windows Server 2008 (32-bit or 64-bit)
Windows Server 2008 R2 (64-bit)
Windows 7 (32-bit or 64-bit)

Native Database Server

Toad supports the following databases:
Oracle 9i, 10g, 11g, 11g R2
Toad has been tested on Oracle Exadata 2.0 running Oracle database 11g R2.
Limited support of SQL Server 2000 (Service Pack 3 or later)
Note: The following features are not available:

  • Index Defragmentation
  • Storage Management
  • Performance Monitor
  • Project Lucy Performance Analytics
  • Altering procedures, functions, views in the Editor
  • Version Control

SQL Server 2005 (Service Pack 2 or later) and SQL Server 2005 Express
SQL Server 2008 and SQL Server 2008 Express
SQL Server 2008 R2 and SQL Server 2008 R2 Express
SQL Server 2012 and SQL Server 2012 Express
Note: SQL Server Compact Edition is not supported.
IBM DB2 for LUW 8.1.5, 8.2, 9.1, 9.5, 9.7, 10.1
IBM DB2 for z/OS 8, 9, 10
Notes:

  • To run RUNSTATS and the native REORG utility on tablespaces and indexes in DB2 for LUW, Toad supports DB2 for LUW 8.2.2 or later.
  • Toad may support IBM DB2 Express and SWE in addition to listed above servers, but note that no testing was performed on it.
  • Toad supports DB2 8 for z/OS running in Full Function mode, but does not support DB2 8 for z/OS running in Compatibility mode.

MySQL 4.1, 5.0, 5.1, 5.6
Sybase ASE 12.5, 15.0.2, 15.0.3, 15.5
Sybase IQ 15
Sybase SQL Anywhere 12
Teradata 12.0, 13.0, 13.10
Access 2003, 2007, 2010
Excel 2003, 2007, 2010

ODBC Database Server

Toad Data Point allows you to create a connection to a database that supports an ODBC 3.0 or later driver. ODBC connectivity provides basic querying capability, but may not be as full-featured as a native connection in Toad. Toad has been tested on the following databases, using an ODBC connection:

  • DB2 for i5/OS V5R4 and IBM i 6.1
  • Informix Dynamic 10.00, 11.0 (limited testing)
  • Ingres Community Edition 2006 R2 on Windows 32-bit (limited testing)
  • Netezza Data Warehouse Appliance 4.6.6, 6.0
  • PostgreSQL 8.3.4
  • Vertica 4.1, 5.0, 5.1 (with 4.0, 4.1 ODBC driver), 6.0 (with 6.0 ODBC driver)

Note: For a list of databases that are not supported, see Known Issues in the Release Notes.

Cloud Database Service

Oracle databases running on Amazon EC2
SQL Azure
Note: To connect to SQL Azure, you must have read access to the master database and VIEW DEFINITION grant on the databases you want to work with.
SQL Server databases running on Amazon EC2
Amazon Redshift
Toad can manage Amazon RDS and any other cloud or service offering compatible with MySQL.

Quest Data Services -
Premium Connections

Toad has been tested with, and supports, the following Business Intelligence / Cloud platforms:

  • Business Objects XI 3.0, 3.1
  • Hive
  • Oracle Business Intelligence Enterprise Edition 11g
  • Salesforce.com
  • Microsoft SQL Server Analysis Services

Virtualization Support

Application Virtualization

Limited testing has been performed for Citrix XenApp 5.0 on Windows Server 2003 and Citrix XenApp 6.5 on Windows Server 2008 R2.

Desktop Virtualization (VDI)

Toad has been tested with Quest vWorkspace 7.0 running on Windows XP Professional 32-bit (Service Pack 2).

Server Virtualization

Toad has been tested with the following:

  • Oracle VM 3.1 running on Red Hat Enterprise Linux 64-bit with Oracle 11gR2
  • Oracle VM 2.2 running on Windows 2008 32-bit with Oracle 11gR2

Language Supported:

  • US English

 

视频

Toad for Data Analysts is now Toad Data Point.

截屏

Toad Data Point——不受限连接性

Toad Data Point

- 几乎可连接至任何数据源,从传统的关系型源(包括Oracle、SQL Server、Sybase、DB2、Teradata、Access以及任何ODBC合规平台),到非数据库源(包括Excel和SharePoint),乃至于NoSQL系统(包括Hadoop/Hive、Salesforce.com、Business Objects以及Oracle Business Intelligence平台)。 充分利用SQL的强大功能,对上述任意源进行查询。

Toad Data Point——数据整合

Toad Data Point

通过高性能、跨平台的拖放式查询,简化自助式数据整合流程。 只需一个简单的工具,即使您不是SQL专家也可轻松运行SQL查询,访问Excel、RDBMS、NoSQL、云、BI和大数据,然后快速实现数据的连接。

Toad Data Point——即使不是专家也可编写和编辑SQL查询

Toad Data Point

Toad Data Point让您能够在功能强大且可自定义的编辑器中轻松编写SQL语句,该编辑器提供SQL Complete、自动格式化、即时调用SQL以及多种其他功能,让编写SQL更为简单。 Toad提供一个熟悉的、完全可配置的界面,此界面可自定义为类似Toad for Oracle的外观,并能提供直观的拖放式向导,从而加快SQL编辑速度

Toad Data Point——对经常性的工作流程和任务进行自动执行并安排

Toad Data Point

通过Toad Data Point的自动化脚本安排时间表,让您摆脱重复性的人工工作流程任务。 通过灵活且可扩展的脚本提高生产率和效率,并根据业务需求或受众的不同对其进行自定义。 Toad Data Point提供丰富的自动化模板,包括用于导出数据、通过电子邮件发送数据、执行脚本以及其他用途的模板。

Toad Data Point——轻松转换和清理数据

Toad Data Point

无需IT部门的帮助,您在桌面上也可以轻松转换和清理数据。 借助于Toad,您可以轻松修改大型数据集、查找重复项,并通过在桌面上本地添加计算、格式化列和添加分组来转换数据。

Toad Data Point——通过比较和同步来确保并验证数据

Toad Data Point

通过创建数据集后对数据进行比较和同步,提高报告的准确性,减少下游的数据操作。 只有Toad允许您分析来自不同平台的数据、验证模式的准确性,并在出现了差异时对数据进行同步。

Toad Data Point——对数据进行有针对性的可视化和显示。

Toad Data Point

设计专业的图表和图形,以便更有针对性地将您的数据结果分享给用户。 Toad让您能够轻松生成自己的图表、图形和报告,而无需将数据导出至Excel。您也可以创建可视化界面,交互式地浏览数据。

Toad Data Point——ER图示化工具和数据浏览器

Toad Data Point

直观地显示和注解表格关系,以创建您自己的关系模板;查看主从关系;浏览数据库表格和对象。 此功能使您能够通过异构、不同的数据源快速建立数据模型,而无需将数据导出至另一工具。

Toad Data Point——通过SQL访问高级数学和统计功能

Toad Data Point

借助于超越历史报告的预测性分析,改进贵公司的盈利能力和效率。 借助于桌面上提供的超过170个数学和统计功能,您能够对各种对象进行高级分析,例如预测客户行为、客户评分、预测性建模、统计分析等。

Toad Data Point——轻松导入和导出至Excel和其他应用

Toad Data Point

高效地加载和卸载数据。 您可以轻松地将数据导出,并以Excel、.CSV、.TXT、HTML、PDF等多种文件格式发布。

文件