Cannot Publish automation using MySQL

Toad Data Point & Toad Intelligence Central
1

I’m trying to publish an automation that uses a MySQL connection and TDP is not letting me.

I’m getting an error stating ‘This automation script contains one or more connections that are not supported by Intelligence Central’.

This is using native MySQL ODBC 5.3 driver. Anyone seen/able to overcome this issue?

2

Hello Felipe,

This message is encountered when trying to publishing automation steps which involve Local Storage or a local TIC connection. If this is your use case, I’m afraid it is not supported in Toad.

In order to determine whether there is a workaround for your specific scenario, could you provied more details about what you are trying to achieve?

1 Like
3

this is correct @milos.djordjevic - I’m trying to get data from _toad_automation db thru a script; I want to get data about jobs that ran on a given period. are you aware of any workaround for this situation?

4

You can try:

  • Creating a MySQL connection to your TIC’s internal database (using TIC Server IP, your Administator TIC credentials, and port 2166) on a remote TDP instance.
  • Then create an Automation script with ‘Select to file’ step that exports your query results to a CSV\Excel report using the previously created MySQL connection (for TIC’s internal database),
  • And finally schedule the script to run on your remote TDP machine.