TweetOut ODBC Connections

Users can access TweetOut content from a Flow database using an ODBC connection and TweetOut 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 TweetOut instance.
3. Use the System DSN Connection to connect to TweetOut content Views provided by Bannister Lake Support upon request.

Install MySQL ODBC Connector Driver

You need to install a MySQL ODBC connector driver on a local system in order to connect to your TweetOut content Views 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.

Download the correct driver from Bannister Lake as follows:

• 64-bit MySQL ODBC Driver
• 32-bit MySQL ODBC Driver

Create & Test System DSN Connection

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/ODBC parameters as described in the following table. If you need any help with these values, contact Bannister Lake Support for assistance.

   Parameter	Details
   Data Source Name	Enter a name for this data source. You will need to know this name when you establish a connection to TweetOut content Views using ODBC.
   Description	Describe this data source connection.
   TCP/IP Server	Enter the name of the MySQL server host which is the server name of your TweetOut Flow data server.
   User	Enter the user name for the connection to your TweetOut database.
   Password	Enter the password for the connection to your TweetOut database.
   Database	Select your TweetOut database.

   

5. Click Test to test your connection to your TweetOut database.
6. Click OK to save your changes.