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: - Install a MySQL ODBC Connector Driver on a local system.
- Create and test a System DSN Connection to your TweetOut instance.
- Use the System DSN Connection to connect to TweetOut content 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 for your TweetOut instance. Contact Bannister Lake Support for assistance. |
| 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: | 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.- From the Windows Start Menu, select Control Panel > System & Security > Administration Tools > Data Sources (ODBC).
- On the System DNS tab, click Add.
- 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.
 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. |
- Click Test to test your connection to your TweetOut database.
- Click OK to save your changes.
|