Versions Compared

Version Old Version 3 New Version Current
Changes made by

Carrie Warner (Unlicensed)

Chris Mintz (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

...

Section
If you are unfamiliar with database manipulation, a

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.
Column
width70%

Users running a cloud instance of TweetOut who want access to can access 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 Views for your cloud TweetOut 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 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.

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 System DSN Connection

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

...

  1. the Windows Start Menu, select

...

  1.  Control Panel > System & Security > Administration Tools > Data Sources (ODBC).
  2. On

...

  1. the System DNS

...

  1.  tab,

...

  1. click Add.
     Image Modified
     
  2. 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

...

  1. , you need to cancel out of creating a new data source and install the MySQL ODBC Connector Driver first.
    Image Modified

  2. Specify MySQL

...

  1. Connection/ODBC parameters as described in the following table. If you need any help with these values, contact Bannister Lake Support

...

  1.  for assistance.

    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 data server.
    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.
Column
width30%
Panel
borderColor#0070b1
bgColor#FFFFFF
borderWidth1

In this section:

Table of Contents
indent15px

Include Page
DAS:Promos Top
DAS:Promos Top

 

Include Page
DAS:Promos Bottom
DAS:Promos Bottom