Toad Data Point - Toad World

Get more from Toad Data Point...

with onsite training

Toad™ Data Point is a multi-platform data preparation tool that’s built for anyone who needs to access data from multiple sources, quickly integrate and prepare data to produce datasets and reports for analysis. It dramatically simplifies data access, writing SQL queries and data preparation – all from a single tool and without needing to be a SQL expert. With Toad, you can:

  • Access almost any source from a single tool
  • Visually drag and drop to create SQL queries
  • Profile, transform and cleanse data easily
  • Automate frequent reporting tasks

Toad Data Point v4.2 is now available 

Check out what's new!

Use these links below to learn more about the most popular Toad Data Point topics!


Getting Started



Mastering
Connectivity

Writing
Queries

Import/Export


Automation

Community Discussion

jemery
Follow / 20 Jun 2017 at 3:09pm / Toad Data Point
Latest post by on 21 Jun 2017 at 8:39pm

ERROR: Object reference not set to an instance of an object.

Expand content
Hello, I am trying to create an automation which will export data into an .xlsm spreadsheet which then runs a macro. However, whenever I run my automation I receive an "Object reference not set...

Hello,

I am trying to create an automation which will export data into an .xlsm spreadsheet which then runs a macro. However, whenever I run my automation I receive an "Object reference not set to an instance of an object" error. This error occurs whether or not I am running a macro after the export. Additionally, none of my colleagues here have this issue; we will perform the exact same steps and I get an error whereas they do not.

I am currently running Toad Data Point 4.1.0.226 (64 bit), which is a newer version than any of my colleagues are running, as far as I know. We are all running Windows 7 Professional. The only difference between my system and theirs is that I am running Microsoft Office 2016, while everybody else uses 2013.

Is there a known export issue with Toad Data Point and the Office 2016?

I have attached the log, set to verbose, but I don't think it'll be too helpful.

If anybody could shed some light on how to resolve this, I would be greatly appreciative. We have the ability to revert my Office to 2013, if that might be a solution to this issue.

-- 6/20/2017 8:20:38 AM: Daily_New_Dealers_Report.log: Setting up environment
-- 6/20/2017 8:20:38 AM: Daily_New_Dealers_Report.log: Script run by Toad Data Point 4.1.0.226 as jemery on FFC-xxx
-- 6/20/2017 8:20:38 AM: Daily_New_Dealers_Report.log: Build started
-- 6/20/2017 8:20:38 AM: Daily_New_Dealers_Report.log: Compiling script
-- 6/20/2017 8:20:38 AM: Daily_New_Dealers_Report.log: Start CompileWorkflow
-- 6/20/2017 8:20:38 AM: Daily_New_Dealers_Report.log: Before Compile
-- 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Return from CompileWorkflow
-- 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Workflow Compiled without Errors
-- 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Workflow Compiled has warnings
-- 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Warning: No Exception Handler. To send an Email when there is an error, change the value of Email on Error to true and enter email values.
-- 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Build completed
-- 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Create Workflow instance
-- 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Started workflow instance
-- 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Begin execution script activities
-- 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Variable "ROOT_PATH" set to ''
-- 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Running embedded export template
-- 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Executing export using connection CompassDB2 (FNDODBCxxxxx) is not XQuery Connection
-- 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Export_1 - Object reference not set to an instance of an object.

-- 6/20/2017 8:20:39 AM: Daily_New_Dealers_Report.log: Failed

Thank you,

John

Unanswered 50 2 / Create an account to join the discussion.
PGW
Follow / 19 Jun 2017 at 5:42pm / Toad Data Point
Latest post by on 21 Jun 2017 at 7:14pm

How to Create a Correlated Sub-query in Toad Data Point using Visual...

Expand content
Hello, I am evaluating Toad Data Point as a replacement for OracleEPM/Hyperion/Brio. So far, I like what we see, but want to test in a bit more detail. I am not a developer but an applied data analyst...

Hello,

I am evaluating Toad Data Point as a replacement for OracleEPM/Hyperion/Brio. So far, I like what we see, but want to test in a bit more detail. I am not a developer but an applied data analyst. I generally do not write SQL directly, but rely instead on a visual query builder.

I need help writing a correlated subquery using the visual query designer in Toad Data Point. I can build a subquery but cannot figure out how to join it back to the main query properly. What follows is the SQL we wish to replicate using the Visual Designer in TOAD Data Point:

          SELECT AL1.SGBSTDN_PIDM, AL1.SGBSTDN_TERM_CODE_EFF FROM SATURN.SGBSTDN AL1 WHERE (AL1.SGBSTDN_TERM_CODE_EFF IN

          (SELECT MAX ( AL2.SGBSTDN_TERM_CODE_EFF ) FROM SATURN.SGBSTDN AL2 WHERE (AL2.SGBSTDN_PIDM=AL1.SGBSTDN_PIDM)))

I've exported the above from Oracle EPM/Hyperion/Brio. Of course, I can paste it into the query builder in TOAD Data Point, execute it, and it works fine. However, I would like to be able to build it using the visual designer (the DIAGRAM tab in Query Builder). The particular thing I cannot figure out is how to link the subquery back to the main query, which is represented by this:

          WHERE (AL2.SGBSTDN_PIDM=AL1.SGBSTDN_PIDM)

I understand that Toad Data Point may approach a problem like this differently than did Oracle EPM/Hyperion/Brio, I just can't figure out what that approach may be.

Thanks for any advice you may have, and please forgive my ignorance.

Paul

Unanswered 45 2 / Create an account to join the discussion.
veskojl
Follow / 13 Jun 2017 at 8:18pm / Toad Data Point
Latest post by on 20 Jun 2017 at 1:15am

Custom DATE format for ODBC (PostgreSQL)

Expand content
Hi, I'm using TDP 4.2.0.207 to connect to a PostgreSQL database. The thing is I want the DATE and the DATETIME columns to be formatted in a different way: Date = yyyy-MM-dd TimeStamp = yyyy-MM...

Hi, 

I'm using TDP 4.2.0.207 to connect to a PostgreSQL database. The thing is I want the DATE and the DATETIME columns to be formatted in a different way:

Date = yyyy-MM-dd
TimeStamp = yyyy-MM-dd hh:mm:ss

I've tried to set up a custom format just for the dates by configuring: 

 Odbc:DATE=yyyy-MM-dd, (as mentioned in a very old thread here)

but this doesn't seem to work. I'm pretty sure that technique works in "Toad for SQL Server", where it is possible to have different formatting, but I'm not sure if TDP allows this for ODBC.

Does anybody know if this is feasible at all?

Unanswered 111 5 / Create an account to join the discussion.