| Section |
|---|
| Column |
|---|
| TweetOut users running a cloud instance who want access to TweetOut content Users can access TweetOut content from a Flow database using an ODBC connection can do so using and TweetOut Content Views.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 Views for your cloud instance if you are unfamiliar with database manipulationTweetOut instance. Contact Bannister Lake Support for assistance. |
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 used 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 operating system.You can download Download the correct driver directly from Bannister Lake at any time as follows: | | Column |
|---|
| | Panel |
|---|
| | borderColor | #0070b1 |
|---|
| bgColor | #FFFFFF |
|---|
| borderWidth | 1 |
|---|
| In this section:
|
...
...
| CreateSystemDSN | | CreateSystemDSN |
|---|
|
Once the correct MySQL ODBC connector driver is installed on a local system, you need to set up |
|
...
...
connection through Microsoft Windows on that same local system. - From
|
|
...
- the Windows Start Menu, select
|
|
...
- Control Panel > System & Security > Administration Tools > Data Sources (ODBC).
|
|
Once installed, need to set up a System DSN (data source name) connection through Microsoft Windows.
Windows Start Menu > Control Panel > System & Security > Administration Tools > Data Sources (ODBC)
On the System DSN tab, click Add.
- On the System DNS tab, click Add.
 Image Added
- 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
|
|
...
...
...
In the Data Source Name box, enter the name of the data source to access. It can be any valid name that you choose.
...
In the Description box, enter some text to help identify the connection.
...
. 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 |
|
|
...
...
| the connection to your TweetOut database. |
|
|
...
| Password | Enter the password for |
|
|
...
| the connection to your TweetOut database. |
|
|
...
The Database pop-up should automatically populate with the list of databases that the user has permissions to access.
...
To communicate over a different TCP/IP port than the default (3306), change the value of the Port.
...
Click OK to save the DSN.
...
| Database | Select your TweetOut database. |
 Image Added
- Click Test to test your connection to your TweetOut database.
- Click OK to save your changes.
|
| Column |
|---|
| | Panel |
|---|
| borderColor | #0070b1 |
|---|
| bgColor | #FFFFFF |
|---|
| borderWidth | 1 |
|---|
| In this section: | Include Page |
|---|
| DAS:Promos Top |
|---|
| DAS:Promos Top |
|---|
|
|
|
|
| Include Page |
|---|
| DAS:Promos Bottom |
|---|
| DAS:Promos Bottom |
|---|
|
