This will require Data Admin privileges to setup and Builder for implementation.
iDashboards is able to connect to a LinkedIn REST API by using a JDBC driver. A JDBC driver is a software component enabling a Java application to interact with a database. To connect with individual databases, JDBC (Java Database Connectivity API) requires specific drivers for each database. The JDBC driver gives out the connection to the database and implements the protocol for transferring the query and result between the client and the database. iDashboards implements native protocols and does not require additional software installed on the driver host. In other words, iDashboards provides driver connectivity with the JDBC Data Source via the specified driver. This document explains a step-by-step procedure to create the Data Source with a Premium Data Connector.
CDATA for LinkedIn – Making the LinkedIn Connection – Data Connection
CDATA for LinkedIn
CData JDBC Driver for LinkedIn is where we get the documentation on making this connection, however, the Premium Data Connectors are not a straight forward process which is why we make articles like this to help you make the connections more easily. This one requires a few steps, with a few different links to get very specific pieces of information to make this connection within iDashboards. The LinkedIn API connector is part of the Premium Data Connectors if you do not have these connectors please contact your Client Success Manager.
Making the LinkedIn Connection
Create Your App in LinkedIn
Log in to the LinkedIn Developer Portal, and click Create App.
You'll be asked to provide basic details about your app, including:
-
-
- App name
- Company
- Privacy policy URL
- Business email
- App logo
-
You'll also need to select the products you'd like to add/integrate into your app. By default, you'll get the abilities to Share on LinkedIn and Sign In with LinkedIn. You can, however, also use the Marketing Developer Platform.
Indicate that you agree to LinkedIn's legal terms, and click Create App.
Finally, you need verify the app
In the app settings tab you should see your company with a verify button. Clicking this will provide you a link which your LinkedIn Page Admin (whoever that might be) will use to verify the account.
Callback/Redirect URL
http://<ServerName>:6700/idbdata/console/api/callback
*6700 is the default port, please adjust accordingly.
Client ID and Client Secret
These can be found in the Auth tab of the API app created in the previous steps. In this Auth tab you can enter in the Redirect URL at the bottom under OAuth 2.0 Settings.
Set Initiate OAuth to GETANDREFRESH
Authorization Code
- Next you need to build a URL to obtain the Authorization Code that you need to get the access token.
- Copy and paste the two URLs below into a text editor
- https://www.linkedin.com/oauth/v2/authorization?response_type=code&client_id=<YourClientId>&client_secret=<YourClientSecret>&redirect_uri=<YourRedirectURI>&state=3jf893jd89&scope=r_liteprofile%20r_emailaddress%20w_member_social
- https://www.linkedin.com/oauth/v2/accessToken?grant_type=authorization_code&client_id=<YourClientId>&client_secret=<YourClientSecret>&code=<Your Auth Code Goes Here>&state=3jf893jd89&redirect_uri=<YourRedirectURI>
- Fill in your Client ID, Client Secret, and Redirect URI
- When the first URL is filled out, copy and paste it into a browser
- Hit enter and the URL will change and you will receive the Authorization Code
- For security reasons, the authorization code has a 30-minute lifespan and must be used immediately. Copy the code into the second URL below after code=
- Copy this URL into a browser and hit enter to receive your Access Token
- https://www.linkedin.com/oauth/v2/accessToken?grant_type=authorization_code&client_id=<YourClientId>&client_secret=<YourClientSecret>&code=<Your Auth Code Goes Here>&state=3jf893jd89&redirect_uri=<YourRedirectURI>
OAuth Access Token
Copy the URL below to a text editor and fill in your Access Token
jdbc:linkedin:Callback URL="<YourRedirectURI>";Initiate OAuth="GETANDREFRESH";OAuth Access Token="<Your Access Token Goes here>";
CDATA for LinkedIn – Making the LinkedIn Connection
Data Connection
Follow the steps below to set up a data source in iDashboards Admin or Data Hub.
- Log into either Data Hub or the iDashboards Admin
- Click on Data Sources then New
- Fill out the highlighted fields below:
- Database URL*: Enter in the URL you created previously with the Access Token
- JDBC Driver Class: cdata.jdbc.linkedin.LinkedInDriver
- In Optional Driver Properties
- OAuth Client Id="[Your Client ID]";OAuth Client Secret="[Your Client Secret]";
- *Please remove the bracket but leave the quotes
- Click Save, your data connection has been made!
For More Information:
- Creating a Database URL (Connection String)
- LinkedIn API Documentation
- iDashboards Admin Manual 10. Managing Data Sources
Disclaimer: iDashboards Technical Support Engineers are not proficient in the Management and Integration of every API that exists as new APIs are being created everyday with each company that wants to provide seamless integration with other software. However, we do our best to help you make these connections because we want to assist you in your success. If you do not see an article for a connection you would like to make please contact iDashboards Support and know that it will take a bit of time to figure out what is necessary for this integration.
If the above is unable to resolve the issue, then please contact iDashboards Support for further assistance.
CDATA for LinkedIn – Making the LinkedIn Connection – Data Connection
Comments
0 comments
Please sign in to leave a comment.