Toad Data Point Beta Program Community

Toad Data Point - Beta Forum

yan2
Follow / 16 Apr 2018 at 10:16pm / Toad Data Point Beta Program
Latest post by on 17 Apr 2018 at 8:49pm

ODBC Generic Connection Properties - GUI issue

Expand content
Using 4.5.0.242, both General and Advanced tabs show overlapping fields on ODBC Generic connection: Can be reproduced just by trying to create a new ODBC connection

Using 4.5.0.242, both General and Advanced tabs show overlapping fields on ODBC Generic connection:

Can be reproduced just by trying to create a new ODBC connection

12 1 / Create an account to join the discussion.
Aleksey Bazhenov

Toad Data Point Beta 4.5.0.242 is now available

Expand content
Installer is available on the TDA Community website: https://www.toadworld.com/products/toad-data-point/toad_data_point_beta_program The latest list of fixes and enhancements can be found in the Release...

Installer is available on the TDA Community website:

https://www.toadworld.com/products/toad-data-point/toad_data_point_beta_program

The latest list of fixes and enhancements can be found in the Release Notes:

http://dev.toadfordataanalyst.com/releasenotes/beta/ToadforDataAnalystsRNBeta.htm

TDP Development Team

45 0 / Create an account to join the discussion.
A_G_A
Follow / 10 Apr 2018 at 3:08pm / Toad Data Point Beta Program
Latest post by on 11 Apr 2018 at 8:35am

Double-Line For Record Selected

Expand content
Hello all! With the new installation I am unable to locate the option to NOT show a double-line for the record selected. Thanks for any assistance!

Hello all!

With the new installation I am unable to locate the option to NOT show a double-line for the record selected.

Thanks for any assistance!

28 1 / Create an account to join the discussion.
A_G_A
Follow / 5 Apr 2018 at 8:01pm / Toad Data Point Beta Program
Latest post by on 5 Apr 2018 at 8:33pm

TDP Beta 4.5.0.219 x64

Expand content
Hello all! What is required to connect to a SQLServer DB via JDBC (JTDS)? Thanks!

Hello all!

What is required to connect to a SQLServer DB via JDBC (JTDS)?

Thanks!

66 3 / Create an account to join the discussion.
edmlicensing
Follow / 6 Mar 2018 at 7:47pm / Toad Data Point Beta Program
Latest post by on 23 Mar 2018 at 7:56pm

Toad Data Point 4.5 Beta When attempting to use replace function with...

Expand content
When attempting to use replace function with a variable a hard error is returned. This was not an issue in v4.0. When attempting to set a string variable to a character or leave it blank an error is...
  • When attempting to use replace function with a variable a hard error is returned. This was not an issue in v4.0.
  • When attempting to set a string variable to a character or leave it blank an error is returned. Screenshot is for the single character. This was not an issue in v4.0.

Thank you

294 15 / Create an account to join the discussion.
Aleksey Bazhenov

Toad Data Point Beta 4.5.0.219 is now available

Expand content
Installer is available on the TDA Community website: https://www.toadworld.com/products/toad-data-point/toad_data_point_beta_program The latest list of fixes and enhancements can be found in the Release...

Installer is available on the TDA Community website:

https://www.toadworld.com/products/toad-data-point/toad_data_point_beta_program

The latest list of fixes and enhancements can be found in the Release Notes:

http://dev.toadfordataanalyst.com/releasenotes/beta/ToadforDataAnalystsRNBeta.htm

TDP Development Team

54 0 / Create an account to join the discussion.
edmlicensing
Follow / 26 Feb 2018 at 5:57pm / Toad Data Point Beta Program
Latest post by on 2 Mar 2018 at 3:51am

Toad Data Point Beta 4.5 Cannot use the automation module when saving...

Expand content
what criteria the following message is based on “Cannot use the automation module when saving passwords is disabled.”? Is it based on having a connection with a saved password or windows allowance...

what criteria the following message is based on “Cannot use the automation module when saving passwords is disabled.”? Is it based on having a connection with a saved password or windows allowance for using the credential manager?

Thank you

Unanswered 117 1 / Create an account to join the discussion.
Mike Triplett
Follow / 26 Jul 2017 at 4:52pm / Toad Data Point Beta Program
Latest post by on 23 Feb 2018 at 5:55pm

Toad Data Point Beta 4.3.0.253 (32 bit) - Job Manager does not wo...

Expand content
I'm currently running Toad Data Point 4.2.1.303 (32 bit) and after upgrading to Windows 10 - Creators Edition the Job Manager fails and I cannot schedule any tasks. I saw a suggest to upgrade to...

I'm currently running Toad Data Point 4.2.1.303 (32 bit) and after upgrading to Windows 10 - Creators Edition the Job Manager fails and I cannot schedule any tasks.  

I saw a suggest to upgrade to the Beta to see if it fixes my problem.  I've installed Toad Data Point Beta 4.3.0.253 (32 bit) and that does not fix the error.

This is the error I receive when attempting to "Schedule" a "Automation".

Exception: (1,1306):WnfStateChangeTrigger:

I've also tried changing to Task Scheduler 1.0 and that fails also.

508 2 / Create an account to join the discussion.
Aleksey Bazhenov

Toad Data Point Beta 4.5.0.159 is now available

Expand content
Installer is available on the TDA Community website: https://www.toadworld.com/products/toad-data-point/toad_data_point_beta_program The latest list of fixes and enhancements can be found in the Release...

Installer is available on the TDA Community website:

https://www.toadworld.com/products/toad-data-point/toad_data_point_beta_program

The latest list of fixes and enhancements can be found in the Release Notes:

http://dev.toadfordataanalyst.com/releasenotes/beta/ToadforDataAnalystsRNBeta.htm

TDP Development Team

160 0 / Create an account to join the discussion.
yan2
Follow / 19 Mar 2017 at 3:22am / Toad Data Point Beta Program
Latest post by on 14 Feb 2018 at 6:25pm

Azure SQL DB - object MS_Description cannot be displayed

Expand content
There has been a recent (seamless ?) enhancement of Azure SQL db, namely, it does support now the addition of extended properties to tables, columns,... Maybe it did for a while but at https://msdn.microsoft...

There has been a recent (seamless ?) enhancement of Azure SQL db, namely, it does support now the addition of extended properties to tables, columns,... Maybe it did for a while but at https://msdn.microsoft.com/en-us/library/ms180047.aspx, the green checkmark next to Azure SQL DB is new (since Jan apparently).

e.g. the following statement does not error out anymore - it did last time I tried a few months ago.

EXEC sys.sp_addextendedproperty @name = N'MS_Description', @value = 'test description', @level0type = N'SCHEMA', @level0name = 'dbo', @level1type = N'TABLE',  @level1name = 'mytable' 


Can TDP be updated to act like with SQL Server connections and allow to display the Description, among others,

  • of the columns in the properties tab of a table
  • in the Object Explorer context-menu, Options > Extra Columnazure (in both Tables and Columns panes)
955 12 / Create an account to join the discussion.
unnatinarang
Follow / 22 Jan 2018 at 9:45pm / Toad Data Point Beta Program
Latest post by on 23 Jan 2018 at 9:12pm

Data Point 4.3 Install Not Working - BETA expired

Expand content
Toad Data Point Beta has expired, and prompts me to download a new version when I try to run it on my Windows PC. I got a new version (ToadDataPoint_Beta_4.3.0.702), however when I try to run the latest...

Toad Data Point Beta has expired, and prompts me to download a new version when I try to run it on my Windows PC. I got a new version (ToadDataPoint_Beta_4.3.0.702), however when I try to run the latest version 4.3, I get the same error that the beta period has expired. Here's the link: www.toadworld.com/.../toad_data_point_beta_program. Any ideas?

266 3 / Create an account to join the discussion.
Aleksey Bazhenov
Follow / 23 Oct 2017 at 6:42pm / Toad Data Point Beta Program
Latest post by on 22 Jan 2018 at 9:47pm

Toad Data Point Beta 4.3.0.702 is now available

Expand content
Installer is available on the TDA Community website: https://www.toadworld.com/products/toad-data-point/toad_data_point_beta_program The latest list of fixes and enhancements can be found in the Release...

Installer is available on the TDA Community website:

https://www.toadworld.com/products/toad-data-point/toad_data_point_beta_program

The latest list of fixes and enhancements can be found in the Release Notes:

http://dev.toadfordataanalyst.com/releasenotes/beta/ToadforDataAnalystsRNBeta.htm

TDP Development Team

336 2 / Create an account to join the discussion.
yan2
Follow / 16 Jan 2018 at 3:59pm / Toad Data Point Beta Program

support for Google BigQuery

Expand content
Any plan on supporting BigQuery ? It has an API for queries but one can also use the ODBC driver from Samba, which works in TDP. However a big limitation is that TDP does not render arrays of records...

Any plan on supporting BigQuery ? It has an API for queries but one can also use the ODBC driver from Samba, which works in TDP.

However a big limitation is that TDP does not render arrays of records (so-called STRUCT and ARRAYS data types).

Hence the request is to support BigQuery natively, that is

  1. SQL Dictionary (standard SQL dialect) as documented here: https://cloud.google.com/bigquery/docs/reference/standard-sql/
  2. parse the JSON returned for ARRAY (nested and repeated data) correctly - see https://cloud.google.com/bigquery/partners/simba-drivers/

Is there any way users can vote to support this feature ?

101 0 / Create an account to join the discussion.
david.franks
Follow / 10 Oct 2017 at 8:07pm / Toad Data Point Beta Program
Latest post by on 23 Oct 2017 at 7:13pm

Issue with Data Import Export when file is in use

Expand content
I'm on TDP Beta 4.3.0.510 and this issue is also in version 4.2.1.303: If I use the Data Import Export window to import an Excel file that is already open elsewhere on my screen, Toad takes me to...

I'm on TDP Beta 4.3.0.510 and this issue is also in version 4.2.1.303:

If I use the Data Import Export window to import an Excel file that is already open elsewhere on my screen, Toad takes me to a SharePoint List window in which the Cancel button doesn't work (but the X button does work).

Below is my Data Import Export window:

Below is the error message because the file I selected is already in use:

Below is the next window I get.  It's a problem because (1) I wasn't trying to import a SharePoint List, and (2) the Cancel button doesn't do anything.

I know the fix is to close the Excel file before starting the import, but the SharePoint window seems inappropriate for this situation.

Thanks!

Dave

346 1 / Create an account to join the discussion.
Leigh Roy
Follow / 4 Sep 2017 at 12:45am / Toad Data Point Beta Program
Latest post by on 2 Oct 2017 at 8:10pm

Current beta version (4.3.0.291) expired

Expand content
Hi, After installing the latest/current beta version 4.3.0.291 it says that the version has already expired. Kind regards, Leigh

Hi,

After installing the latest/current beta version 4.3.0.291 it says that the version has already expired.

Kind regards,

Leigh 

1184 12 / Create an account to join the discussion.
Aleksey Bazhenov

Toad Data Point Beta 4.3.0.510 is now available

Expand content
Installer is available on the TDA Community website: https://www.toadworld.com/products/toad-data-point/toad_data_point_beta_program The latest list of fixes and enhancements can be found in the Release...

Installer is available on the TDA Community website:

https://www.toadworld.com/products/toad-data-point/toad_data_point_beta_program

The latest list of fixes and enhancements can be found in the Release Notes:

http://dev.toadfordataanalyst.com/releasenotes/beta/ToadforDataAnalystsRNBeta.htm

TDP Development Team

276 0 / Create an account to join the discussion.
Aleksey Bazhenov

Toad Data Point Beta 4.3.0.347 is now available

Expand content
Installer is available on the TDA Community website: https://www.toadworld.com/products/toad-data-point/toad_data_point_beta_program The latest list of fixes and enhancements can be found in the Release...

Installer is available on the TDA Community website:

https://www.toadworld.com/products/toad-data-point/toad_data_point_beta_program

The latest list of fixes and enhancements can be found in the Release Notes:

http://dev.toadfordataanalyst.com/releasenotes/beta/ToadforDataAnalystsRNBeta.htm

TDP Development Team

305 0 / Create an account to join the discussion.
yan2
Follow / 29 Aug 2017 at 3:10pm / Toad Data Point Beta Program

Support for Google BigQuery

Expand content
Any plan on supporting BigQuery ? It has an API for queries but one can also use the ODBC driver from Samba, which works in TDP. However a big limitation is that TDP does not render arrays of records...

Any plan on supporting BigQuery ? It has an API for queries but one can also use the ODBC driver from Samba, which works in TDP.

However a big limitation is that TDP does not render arrays of records (so-called STRUCT and ARRAYS data types).

Hence the request is to support BigQuery natively, that is

  1. SQL Dictionary (standard SQL dialect) as documented here: https://cloud.google.com/bigquery/docs/reference/standard-sql/
  2. parse the JSON returned for ARRAY (nested and repeated data) correctly - see https://cloud.google.com/bigquery/partners/simba-drivers/

Is there any way users can vote to support this feature ?

Unanswered 337 0 / Create an account to join the discussion.
N.B.
Follow / 9 Sep 2016 at 6:58pm / Toad Data Point Beta Program
Latest post by on 29 Aug 2017 at 2:56pm

Toad Data Point Beta 4.0.1.670 - Source Control Options

Expand content
Are there any planned updates to the Source Control Options? Here's the original thread regarding TDP 3.8 - nothing changed in 4.0 or in the first 4.0.1 beta release. If there are no planned updates...

Are there any planned updates to the Source Control Options?  Here's the original thread regarding TDP 3.8 - nothing changed in 4.0 or in the first 4.0.1 beta release.

If there are no planned updates to allow the use of other Version/Source control systems, could the language on the associated dialog(s) at least be updated to not be misleading regarding the available options?  I've got management hounding me over putting everything in TFS because they see the options that would indicate that it's available, yet per the thread above it's not - but explaining that doesn't do any good.

1194 3 / Create an account to join the discussion.
Chris Barnett

Issue with Automation variables in TDP Beta

Expand content
Hi, I just upgraded my beta to 4.3.0.291 and I'm hitting an issue with the variable handling. Normally, whenever a new version comes out, variables fluctuate between showing up as quote-encapsulated...

Hi, I just upgraded my beta to 4.3.0.291 and I'm hitting an issue with the variable handling.  Normally, whenever a new version comes out, variables fluctuate between showing up as quote-encapsulated and not.  It normally doesn't affect functionality other than sort order and it's a beta, so no big deal.  This time around it's doing something new.

My automation basically sets a variable (#TODAY#)  which generates today's date in YYYY-MM-DD format as a string.   I then use that variable to name my query export and then in my notification emails, I provide a url with the filename for the day.  It's all pretty simple stuff. 

The export now exports the filename without quote-encapsulating the date portion, which is how I'd prefer it.  However, every other step in automation is still using & looking for the quote-encapsulated version, so parts of the job start failing.  I've tried simple things like the copy file action and my email notification action and they all fail.  

E.G.  I'm generated Filename_2017-08-11.xlsx and the rest of the job is looking for Filename_'2017-08-11'.xlsx ,  even though every step refers to the same #TODAY# variable.   

I've tried rebuilding the variable  as Date('YYYY-MM-DD') and to_char(Current_date(), "YYYY-MM-DD') and both behave the same way.    I've also tried setting it as a DateTime variable, which introduced new issues. 

Is there something I'm missing to get this to behave consistently ?  

Thanks,

Chris

289 0 / Create an account to join the discussion.