Versions Compared

Version Old Version 6 New Version 7
Changes made by

Chris Mintz (Unlicensed)

Carrie Warner (Unlicensed)

Saved on

Key

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

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

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

Install MySQL ODBC Connector Driver

Anchor
InstallMySQLODBCDriver
InstallMySQLODBCDriver
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:

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

In this section:

Table of Contents
indent15px

Include Page
DAS:Promos Top
DAS:Promos Top

...

  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.

    Image Removed
  5. Click Test to test your connection to your TweetOut database.
  6. Click OK to save your changes.
  7. ParameterDetails
    Data Source NameEnter a name for this data source. You will need to know this name when you establish a connection to TweetOut content Views using ODBC.
    DescriptionDescribe this data source connection.
    TCP/IP ServerEnter the name of the MySQL server host which is the server name of your

...

  1. TweetOut Flow database.
    UserEnter the user name for the connection to your

...

  1. TweetOut database.
    PasswordEnter the password for the connection to your

...

  1. TweetOut database.
    DatabaseSelect

...

  1. your TweetOut database.

    Image Added

  2. Click Test to test your connection to your TweetOut database.
  3. Click OK to save your changes.

Include Page
DAS:Promos Bottom
DAS:Promos Bottom