Users running a cloud instance of TweetOut who want access to TweetOut content using an ODBC connection can do so using TweetOut content views.
If you are unfamiliar with database manipulation, a Bannister Lake Support Database Administrator will need to assist you in setting up TweetOut content views for your cloud instance. 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 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:
In this section:
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).
- On the System DNS 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. If you need any help with these values, contact Bannister Lake Support for assistance.
- Click Test to test your connection to your TweetOut database.
- Click OK to save your changes.
| 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 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 cloud instance database. |
| User | Enter the user name for the connection to your cloud instance database. |
| Password | Enter the password for the connection to your cloud instance database. |
| Database | Select your cloud instance database. |