SQL Access to Twitter Data from Applications
- Click the gear icon for the visualization to configure the visualization properties and assign columns to the visualization.
- Select a visualization style and add it to the report.
- Select the table to visualize and drag it onto the workspace.
- Database: Choose the database you created from the drop-down menu ( twitterdb).
- Mode: Choose Live to query Twitter on-demand or choose Extract to load the data into Bold BI.
- Server name: Your Connect Server instance ( CONNECT_SERVER_URL).
- Choose the basic configuration and set the connection properties:.
- Log into your Bold BI instance, click the data sources tab, create a new data source, and choose the MySQL connector.
- The steps below outline connecting to CData Connect Server from Bold BI to create a new Twitter data source and build a simple visualization from the data. With the virtual database created, you are ready to connect to Twitter data from Bold BI.
- Click Privileges -> Add and add the new user (or an existing user) with the appropriate permissions.
- Click Test Database to authenticate with Twitter.
- Select "Twitter" from Available Data Sources.
- Login to Connect Server and click Databases.
- Using optimized data processing out of the box, CData Connect Server pushes all supported SQL operations (filters, JOINs, etc) directly to Twitter, leveraging server-side processing to quickly return the requested Twitter data.Ĭreate a Virtual MySQL Database for Twitter DataĬData Connect Server uses a straightforward, point-and-click interface to connect to data sources and generate APIs. As you build visualizations, Bold BI generates SQL queries to gather data. This article shows how to create a virtual database for Twitter and build reports from Twitter data in Bold BI.ĬData Connect Server provides a pure MySQL interface for Twitter, allowing you to easily build reports from live Twitter data in Bold BI - without replicating the data to a natively supported database.
When paired with CData Connect Server, you get instant access to Twitter data for visualizations, dashboards, and more.
Bold BI allows you to create, share, and collaborate on interactive BI dashboards.