The CData JDBC Driver for LinkedIn integrates connectivity to live LinkedIn data in IDEs that support JDBC. The JDBC standard enables you to use built-in data access wizards and other tools supporting rapid development. This article shows how to connect to LinkedIn data in NetBeans. You will create a connection and edit and save LinkedIn data in the Table Editor.
Create a JDBC Data Source for LinkedIn in NetBeans
To create the JDBC data source, expand the Database node in the Service window, right-click the Drivers node, and select New Driver. In the New Driver wizard that results, enter the following information:
- Driver File(s): Click Add and, in the file explorer dialog that appears, select the cdata.jdbc.linkedin.jar file. The driver JAR is located in the lib subfolder of the installation directory.
- Driver Class: Click Find to search for the driver class inside the JAR. Then select cdata.jdbc.linkedin.LinkedInDriver from the menu.
- Name: Enter the name for the driver.
Define Connection Parameters
Follow the steps below to define required connection properties:
In the Service window, right-click the Database node and click New Connection.
In the New Connection Wizard, enter the following connection properties:
- Driver Name: In the menu, select the CData JDBC Driver for LinkedIn.
- User Name: Enter the username. This can also be defined in the JDBC URL.
- Password: Enter the password. This can also be defined in the JDBC URL.
JDBC URL: Specify the JDBC URL.
LinkedIn uses the OAuth 2 authentication standard. You will need to obtain the OAuthClientId and OAuthClientSecret by registering an app with LinkedIn.
For more information refer to our authentication guide.
Built-in Connection String Designer
For assistance in constructing the JDBC URL, use the connection string designer built into the LinkedIn JDBC Driver. Either double-click the JAR file or execute the jar file from the command-line.
java -jar cdata.jdbc.linkedin.jar
Fill in the connection properties and copy the connection string to the clipboard.
A typical JDBC URL is the following:
jdbc:linkedin:OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;CallbackURL=http://localhost:portNumber;CompanyId=XXXXXXXInitiateOAuth=GETANDREFRESH
Query LinkedIn Data
To connect to LinkedIn data, right-click the connection in the Database node and click Connect. After the connection is established, you can expand it to discover schema information.
To load a table in the Data Views window, right-click the table and then click View Data. You can also insert, update, or delete records in the Data Views window.