- Log in to the Twitter Developer Portal, Sign in with your account and click Apps in the upper right.
- It should tell you you have no apps so click Create an App.
- You'll be asked to select a reason for using Twitter developer tools. Select anything > Next.
- Fill in all the required information in the subsequent pages, review, accept terms, and submit.
- You'll be sent and email to verify your email and receive your developer account. Click the confirmation button in the email and it will open up the get started web page.
Select Create an App and you be taken to the same page as step 2. Click Create an App
Fill in all the required App Details.
The Callback URL is http://localhost:6600/idbdata/console/api/callback
When everything is filled in click Create and you'll be taken to the App Details screen.
2. Obtaining and Entering credentials into the Instagram driver.
In this section we'll be building the connection string to be used later when setting up the data source connection.
Locate the Twitter driver
Double click the driver and it should open the drivers connection properties. If clicking doesn't work for you, you can do this via command line.
Navigate to the drivers folder and run command "java -jar cdata.jdbc.twitter.jar"
Scroll to the OAuth section of the connection properties and begin filling in the appropriate fields.
Set Initial OAuth to GETANDREFRESH
6700 is the default port for v.10 adjust accordingly.
Client ID and Client Secret
These can be found in the Keys and Tokens tab of your Twitter app. The OAuth Client ID and Secret are the API Key and API Secret Key in the Twitter app.
OAuth Access Token and Secret.
Click the generate button to reveal your access token and secret.
Copy all Keys and Secrets to the appropriate fields in the Twitter driver and click Test Connection.
When your Test comes back successful, click copy to clipboard and paste the connection string into a text file to be used in the final part of the setup.
3. Creating the Data Source Connection
- Log into either the Datahub or the Admin console > Data Sources Tab > New
- Data Source Type: Generic JDBC
- Give the Data Source a name
- Database URL*: Enter in the connection string you created in Step 2
- JDBC Driver Class: cdata.jdbc.twitter.TwitterDriver