Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
If you are unfamiliar with database manipulation, a

and TweetOut content views. Setting up an ODBC connection consists of three steps:

  1. Install a MySQL ODBC Connector Driver on a local system.
  2. Create and test a System DSN Connection to your cloud TweetOut instance.
  3. Use that System DSN Connection to connect to TweetOut content views provided by Bannister Lake Support upon request.
Column
width70%

Users running a cloud instance of TweetOut who want can access to TweetOut content from a Flow database using an ODBC connection can do so using TweetOut content views.

Note
Note

A Bannister Lake Support Database Administrator will need to assist you in setting up TweetOut content views for your cloud instance. Contact Bannister Lake Support for assistance.

Install MySQL ODBC Connector Driver

In addition to the TweetOut content views, you also

Anchor
InstallMySQLODBCDriver
InstallMySQLODBCDriver
You need to install a MySQL ODBC Driver connection connector driver on a local system in order to connect to your TweetOut datacontent using an ODBC connection. The MySQL ODBC driver comes in both a 64-bit and 32-bit OS version, so be sure to install the correct driver for your local Microsoft® Windows® operating system.

You can download Download the correct driver directly from Bannister Lake at any time as follows:

Column
width30%
Panel
borderColor#0070b1
bgColor#FFFFFF
borderWidth1

In this section:

Table of Contents
indent15px

Create & Test System DSN Connection

Anchor
CreateSystemDSN
CreateSystemDSN
Once

...

the correct MySQL ODBC

...

connector driver is installed on a local system, you need to set up a System DSN connection through Microsoft Windows on that same local system.

  1. From the Windows Start Menu, select Control Panel > System & Security > Administration Tools > Data Sources (ODBC).
  2. On the System DNS tab, click Add.
     
     
  3. When prompted to select a driver, select the MySQL ODBC Driver option and click Finish. If you don't see the MySQL ODBC Driver option, you need to cancel out of creating a new data source and install the MySQL ODBC Connector Driver first.
  4. Specify MySQL connection Connection/ODBC parameters as described in the following table. If you need any help with these values, contact Bannister Lake Support for assistance.
  5. Click Test to test your connection to your TweetOut database.
  6. Click OK to save your changes.

...