Versions Compared

Version Old Version 1 New Version 2
Changes made by

Carrie Warner (Unlicensed)

Carrie Warner (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
Column
width70%
Introductory text here.

TweetOut users running a cloud instance who want access to TweetOut content using an ODBC connection can do so using TweetOut Content Views.

Note

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

Install MySQL ODBC Connector Driver

In addition to the TweetOut Content Views, you also need to install a MySQL ODBC Driver connection on a local system used to connect to your TweetOut data. 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 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

Heading Here

...

Create System DSN Connection

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

From the Windows Start Menu, select Control Panel > System & Security > Administration Tools > Data Sources (ODBC).

Once installed, need to set up a System DSN (data source name) connection through Microsoft Windows.

Windows Start Menu > Control Panel > System & Security > Administration Tools > Data Sources (ODBC)

On the System DSN tab, click Add.

When prompted to select a driver, select the MySQL ODBC Driver option and click Finish.

Specify MySQL connection parameters as described in the following table and click OK.

 

 

 

  1.                In the Data Source Name box, enter the name of the data source to access. It can be any valid name that you choose.

  2. In the Description box, enter some text to help identify the connection.

  3. In the Server field, enter the name of the MySQL server host to access. By default, it is localhost.

  4. In the User field, enter the user name to use for this connection.

  5. In the Password field, enter the corresponding password for this connection.

  6. The Database pop-up should automatically populate with the list of databases that the user has permissions to access.

  7. To communicate over a different TCP/IP port than the default (3306), change the value of the Port.

  8. Click OK to save the DSN.

To verify the connection using the parameters you have entered, click the Test button. If the connection could be made successfully, you will be notified with a Success; connection was made! dialog.