TrustRadius
https://dudodiprj2sv7.cloudfront.net/product-logos/Se/HZ/7JS8TUMPT5RV.pngSolve that Dataset consolidation IssueToad Data point is a great product for joining datasets from all over the place. We constantly need to have the ability to bring together data from analytics, government organizations and internal data. This was previously a very cumbersome process having to use a ton of excel and access datasets. With Toad Data Point we immediately are able to join data and cleanse it right away.,Joins data from across Oracle, Access, Google Analytics Can pull from Sharepoint lists data The ability to cleanse data and transform easily The user interface is very easy to use for not so technical users,The connections can be a bit slow to setup More functionality could be added to the process that can easily be transformed or cleansed Continue to add more data sources,8,Tableau Desktop, Oracle Hyperion Enterprise Performance Management and Toad for Oracle,9,6,Microsoft Access, Oracle Hyperion Enterprise Performance Management, JabberConnection data from pretty much any source!Unfortunately (I am sure we are not the only organization) we have data in a lot of different datasets all over the company. We have access databases, oracle, mysql, sharepoint lists and excels from government entities that we previously had a hard to joining in a cohesive manner together. Toad Data Point takes all those pain points away seamless interactions amongst all of them.,We have excel files and sharepoint sites that we have to constantly be pulling data from. Previously we had to download, load into access or some other data software. Now we can just connect to all the sources. When you connect to a lot of different data sets the data can be a little unclean. The cleansing tool within Toad allows for you to sync up to layout of data pretty quickly The trending feature on the datasets that you pull is pretty useful, it basically shows how much variation their is in the column that you are looking at. For example if all the data is has the same value or every row is different (street addresses ).,In the past I have had some issues with the connections to some sources like google analytics. Toad can continue to build its connection tools Sometimes the transformation and cleansing tool could be better utilized if they had a few more capabilities The products UI could be updated a bit but honestly I really cannot complain about this product,9,Tableau Online and Oracle Hyperion Enterprise Performance Management,9,6,Microsoft Access, Toad for Oracle, Oracle Hyperion Enterprise Performance ManagementToad Data Point easy connection and reporting all in oneOur company is a real estate office along with an in house escrow. Our escrow company uses software to produce the escrows while on the real estate side of the house we use a Transaction Management Software to flow listings and transactions. We use TDP in several ways. The first way is to produce numerous reports for the owner regarding the escrow department. Some of those reports include weekly opening, closing and canceling of escrows and the number and dollars behind those. Along with the average closing time of escrows compared to previous years passed based on escrow officer along with real estate agent. On the real estate side of the house, we use the TMS companies API to pull data into our database and then use TDP to create reports on the agent's transactions and listings. Some of the reports look at the number of listings the agent takes compared to the number closed both in number and dollars, this information helps us develop classes for agents which are having problems getting listings but not being able to sell. Another report that is run once a month is agent production.,When I am not in the office, I can have someone that has used it only a hand full of times jump in and produce a great looking report by using the interface which is nice looking and intuitive. This strength of TDP is ideal for those reports that have to get out ASAP and an SMA is not available. The ER Diagrammer helps in building those relationships in a hurry if you're doing some business analysts. You can't get this feature for the price. I use the explain plan when I can't figure out why a query is not returning the results I think it should. It is a powerful tool and it's easy to see the problems with the representation.,At times the tool does seem a little slow some speed tweaks would be welcome. To make it even more intuitive adding intellisense would be nice. A data presentation dash would be a nice touch to customize data.,10,,8,8,PyCharm, Remote Desktop Manager, G SuiteToad Data PointMy team (IT Reporting & Analytics) is the only group within our organization that uses Toad Data Point.We use this product to analyze and track issues within our analytics environment. When needed we use it to develop and manage functions/procedures and packages to enhance the analytics functionality of our environment,We use Toad Data Point to analyze data structure and the quality of data within our analytics environment. It allows us to review, create, and modify programs within the Oracle database,I find the explain plans that can be generating difficult to use, and should provide better suggestions as to how to improve performance,9,Toad for Oracle,9,2,4,,We would like to give Toad Data Pont to some of our power users. They ones that would feel comfortable in using SQL,Reviewing data quality and what is causing issues Adding functionality to our analytics environment by the development of functions/procedures and packages,Using this product to develop simple data models,Yes,Product Features Product Usability Product Reputation Prior Experience with the Product,I wouldn't change how we determined to use this product,If you are familiar with using SQL and PL/SQL this system is easy to use. Otherwise it can be confusing. The feature to select an object and find out all information regarding it is the one I use the most,I find the explain plans difficult to use and understand, especially if you are not experienced with them.,8Toad Data Point - a useful tool for analysis/reporting/data prep across many types of Data StoresI see people using Toad Dat Point as a collaborative way of accessing data and then sharing it with others. The Toad suite of tools includes many things but it's the Intelligence Central that easily allows teams to share data, be alerted when data is ready, automatically run workflows and email out results, and more. I find in today's world, with important data in spread sheets and across various database environments, that a tool like Toad Data Point is essential for accessing and producing data/reports/Excel spreadsheets from a large variety of data stores including Office products.,Accesses and extracts data from 20 or more different data stores. Can include data selection even from data stored in Excel spreadsheets. Can automate a flow of tasks (some call it workflows) to provide an easy and automated solution, freeing the analyst from these types of data processing. Analysts don't need to know the SQL query language at all. Toad Data Point has a comprehensive Query Builder that allows for the selection from a large variety of data stores to be included in a single output data request. The data cleansing ability is top-notch. The analyst can 'fix' data at the data extract time. Of course, filtering (data selection) is an integral part of Toad Data Point...in both locating data to include as well as the data from each data store being included.,Data presentation. There really isn't a dashboard technology...Toad Data Point makes it very easy to request data and putting the data in a format for other tools...such as presentation software designed to build dashboards. Again...data presentation...Toad Data Point is more of a data prep/data analysis tool than a mobile app.,10,,10,10,Oracle BI Foundation Suite, Toad for Oracle, SQL Developer
Unspecified
Toad Data Point
24 Ratings
Score 8.6 out of 101
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>TRScore

Toad Data Point Reviews

Toad Data Point
24 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.6 out of 101
Show Filters 
Hide Filters 
Filter 24 vetted Toad Data Point reviews and ratings
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Industry
Department
Experience
Job Type
Role
Reviews (1-6 of 6)
  Vendors can't alter or remove reviews. Here's why.
Andrew Kuhn profile photo
March 20, 2018

Toad Data Point Review: "Solve that Dataset consolidation Issue"

Score 8 out of 10
Vetted Review
Verified User
Review Source
Toad Data point is a great product for joining datasets from all over the place. We constantly need to have the ability to bring together data from analytics, government organizations and internal data. This was previously a very cumbersome process having to use a ton of excel and access datasets. With Toad Data Point we immediately are able to join data and cleanse it right away.
  • Joins data from across Oracle, Access, Google Analytics
  • Can pull from Sharepoint lists data
  • The ability to cleanse data and transform easily
  • The user interface is very easy to use for not so technical users
  • The connections can be a bit slow to setup
  • More functionality could be added to the process that can easily be transformed or cleansed
  • Continue to add more data sources
An example of how we use Toad Data point is we have to connect data from external datasets outside of our company for government agents, access databases that we have built over the years, sharepoint lists and our core company data within an Oracle database. We previously had to do a very cumbersome process of exports to excel and try and pivot data. Now we can do it extremely quickly.
Read Andrew Kuhn's full review
No photo available
March 20, 2018

Toad Data Point Review: "Connection data from pretty much any source!"

Score 9 out of 10
Vetted Review
Verified User
Review Source
Unfortunately (I am sure we are not the only organization) we have data in a lot of different datasets all over the company. We have access databases, oracle, mysql, sharepoint lists and excels from government entities that we previously had a hard to joining in a cohesive manner together. Toad Data Point takes all those pain points away seamless interactions amongst all of them.
  • We have excel files and sharepoint sites that we have to constantly be pulling data from. Previously we had to download, load into access or some other data software. Now we can just connect to all the sources.
  • When you connect to a lot of different data sets the data can be a little unclean. The cleansing tool within Toad allows for you to sync up to layout of data pretty quickly
  • The trending feature on the datasets that you pull is pretty useful, it basically shows how much variation their is in the column that you are looking at. For example if all the data is has the same value or every row is different (street addresses ).
  • In the past I have had some issues with the connections to some sources like google analytics. Toad can continue to build its connection tools
  • Sometimes the transformation and cleansing tool could be better utilized if they had a few more capabilities
  • The products UI could be updated a bit but honestly I really cannot complain about this product
I cannot say a bad thing about this product, it has been a lifesaver for our teams multiple times. Before this product we would have had to spend hours trying to consolidate all the datasets from various areas into one area (usually ended up being Access unfortunately). I wish we would have purchased this product much earlier.
Read this authenticated review
Robb Glietz profile photo
August 17, 2017

Review: "Toad Data Point easy connection and reporting all in one"

Score 10 out of 10
Vetted Review
Verified User
Review Source
Our company is a real estate office along with an in house escrow. Our escrow company uses software to produce the escrows while on the real estate side of the house we use a Transaction Management Software to flow listings and transactions. We use TDP in several ways. The first way is to produce numerous reports for the owner regarding the escrow department. Some of those reports include weekly opening, closing and canceling of escrows and the number and dollars behind those. Along with the average closing time of escrows compared to previous years passed based on escrow officer along with real estate agent. On the real estate side of the house, we use the TMS companies API to pull data into our database and then use TDP to create reports on the agent's transactions and listings. Some of the reports look at the number of listings the agent takes compared to the number closed both in number and dollars, this information helps us develop classes for agents which are having problems getting listings but not being able to sell. Another report that is run once a month is agent production.
  • When I am not in the office, I can have someone that has used it only a hand full of times jump in and produce a great looking report by using the interface which is nice looking and intuitive. This strength of TDP is ideal for those reports that have to get out ASAP and an SMA is not available.
  • The ER Diagrammer helps in building those relationships in a hurry if you're doing some business analysts. You can't get this feature for the price.
  • I use the explain plan when I can't figure out why a query is not returning the results I think it should. It is a powerful tool and it's easy to see the problems with the representation.
  • At times the tool does seem a little slow some speed tweaks would be welcome.
  • To make it even more intuitive adding intellisense would be nice.
  • A data presentation dash would be a nice touch to customize data.
In our case, it is well suited for preparing data for management and also to compare the data between our escrow department and our real estate side. Comparing the two sides makes it easy to see patterns of agent behavior. We also use it to cross check both sides to make sure the dates in both applications match.
Read Robb Glietz's full review
No photo available
October 18, 2017

User Review: "Toad Data Point"

Score 9 out of 10
Vetted Review
Verified User
Review Source

My team (IT Reporting & Analytics) is the only group within our organization that uses Toad Data Point.

We use this product to analyze and track issues within our analytics environment. When needed we use it to develop and manage functions/procedures and packages to enhance the analytics functionality of our environment

  • We use Toad Data Point to analyze data structure and the quality of data within our analytics environment.
  • It allows us to review, create, and modify programs within the Oracle database
  • I find the explain plans that can be generating difficult to use, and should provide better suggestions as to how to improve performance

We receive calls from our functional areas complaining about inaccurate data. Toad makes it easy to track the data's progress from our ERP to the Analytics environment. This allows us to determine quickly were the problem lies and the ability to correct mistakes.

Toad Data point is not well suited for less technical users.

Read this authenticated review
Dan Hotka profile photo
February 24, 2017

Review: "Toad Data Point - a useful tool for analysis/reporting/data prep across many types of Data Stores"

Score 10 out of 10
Vetted Review
Verified User
Review Source
I see people using Toad Dat Point as a collaborative way of accessing data and then sharing it with others. The Toad suite of tools includes many things but it's the Intelligence Central that easily allows teams to share data, be alerted when data is ready, automatically run workflows and email out results, and more. I find in today's world, with important data in spread sheets and across various database environments, that a tool like Toad Data Point is essential for accessing and producing data/reports/Excel spreadsheets from a large variety of data stores including Office products.
  • Accesses and extracts data from 20 or more different data stores.
  • Can include data selection even from data stored in Excel spreadsheets.
  • Can automate a flow of tasks (some call it workflows) to provide an easy and automated solution, freeing the analyst from these types of data processing.
  • Analysts don't need to know the SQL query language at all. Toad Data Point has a comprehensive Query Builder that allows for the selection from a large variety of data stores to be included in a single output data request.
  • The data cleansing ability is top-notch. The analyst can 'fix' data at the data extract time. Of course, filtering (data selection) is an integral part of Toad Data Point...in both locating data to include as well as the data from each data store being included.
  • Data presentation. There really isn't a dashboard technology...Toad Data Point makes it very easy to request data and putting the data in a format for other tools...such as presentation software designed to build dashboards.
  • Again...data presentation...Toad Data Point is more of a data prep/data analysis tool than a mobile app.
I have not worked with another tool that covers so many different data stores so easily. I find the Query Builder and the data scrubbing abilities just top-notch and something the analyst needs. Toad Data Point is very good at working with Excel...can output directly to Excel, to a page in an existing spreadsheet (ie: refresh the data), to pivot tables, and can even set up Excel with the SQL behind the scenes so all you have to do is refresh the spreadsheet and Excel will pull the data! If your analysts use the SQL language, Toad Data Point has an extensive SQL editor, customized to the database environment the focus is pointing to...that includes templates, code snippets, SQL history, and more. This editor comes from the very popular Toad database access/development tool with a rich history in the IT world.
Read Dan Hotka's full review
Andy Corson profile photo
April 03, 2017

Review: "Toad Data Point - great for SQL queries and data export automation"

Score 8 out of 10
Vetted Review
Verified User
Review Source
Toad Data Point is used by one department to provide automated reports for multiple groups within Supply Chain. It is used to automate repetitive tasks that analysts would typically do manually such as exporting and manipulating data in Excel.
  • Toad is particularly good for writing SQL queries because of the drag and drop features that automatically create scripts as well as the intellisense feature for including specific columns in queries.
  • Toad has a simple yet powerful automation script interface which makes it very easy to automate execution of queries and exporting of data.
  • Toad has numerous data connection wizards, and it is very easy to connect to any data source.
  • Toad boasts a cross connection query wizard, but queries have always run very slowly for me, and I do not use this feature after I initially tried it out.
  • Toad sometimes crashes unexpectedly when I disconnect from data sources.
  • Occasionally the intellisense feature hangs and doesn't return the column list when coding SQL. Also, the filters on the query results hang with larger result sets and then never pop up.
Toad is well suited for creating ad hoc queries and exporting data to Excel. It is also good for analyzing tables in preparation for creating ETLs, creating and altering views and stored procedures quickly. It is less appropriate with complex ETL processes because it runs very slowly and cannot process multiple data flow simultaneously.
Read Andy Corson's full review

Feature Scorecard Summary

Pixel Perfect reports (3)
7.0
Customizable dashboards (2)
9.0
Report Formatting Templates (2)
9.2
Drill-down analysis (4)
7.6
Formatting capabilities (5)
7.6
Integration with R or other statistical packages (1)
10
Report sharing and collaboration (3)
7.9
Publish to Web (1)
8
Publish to PDF (5)
7.7
Report Versioning (2)
9.2
Report Delivery Scheduling (3)
8.5
Delivery to Remote Servers (3)
7.1
Pre-built visualization formats (heatmaps, scatter plots etc.) (3)
7.7
Location Analytics / Geographic Visualization (2)
8.0
Predictive Analytics (2)
8.5
Multi-User Support (named login) (2)
8.4
Role-Based Security Model (1)
10
Multiple Access Permission Levels (Create, Read, Delete) (1)
10
Responsive Design for Web Access (1)
7
REST API (1)
8
Javascript API (1)
7
Java API (1)
9
Customizable Platform (Open Source) (1)
10

About Toad Data Point

Toad Data Point Technical Details

Operating Systems: Unspecified
Mobile Application:No