Skip to content

Salesfource with Data Endpoints

Image

  • By using this document user will know how to connect Salesforce to aiv using Data Endpoints.

  • Salesforce integration is the process of merging the data and functionality of Salesforce with another application to provide users with a single unified experience.

Objective

  • Connect Salesforce to aiv using Data-Endpoints.

Usecase

  • Salesforce allows users to fetch data from salesforce & integrate it with your application. For example: in this document, we will fetch the data from salesforce & integrate it with aiv.

Steps to Connect Salesforce to aiv

1. Salesforce

  • Salesforce provides the powerful source of the API which helps in developing and customizing your data.
  1. log in to your Salesforce developer edition.

  2. Follow the given links to know how to set up your salesforce login.

  1. User needs to Create the Connected App first.
  1. While creating the Connected App fill below details:
  • Connected App Name: aiv
  • API Name: aiv (it will be filled automatically)
  • Contact Email: Your email address
  • Enable OAuth Settings: Check the checkbox
  • Set callback URL: https://na11.salesforce.com/ConnectTest/oauth/_callback
  • Selected OAuth Settings: Manage user data via APIs (API)

Image

Image

  1. Scroll down & click on the Save button. It will ask you for permission.

  2. Click on Continue button & your connected app is created.

    Image

  3. User can copy & paste Consumer Key, Consumer Secret & Callback URL to a notepad for further use.

  • How to get Security Token?
  1. By following this link use can generate the Security Token.

  2. Reset your security token & save it in a notepad for further use.

2. IntelliJ IDEA

  1. Download IntelliJ IDEA Community Edition & import the dowloaded project into it.

  2. Open java project file & new.properties file.

  3. User needs to fill the below details in the new.properties file:

  • url: https://'your domain name'.my.salesforce.com/services/data/v54.0/query/?
  • loginInstanceDomain: login.salesforce.com
  • apiVersion: ” your salesforce api version ”
  • userName: ” your salesforce login username ”
  • password: ” your salesforce login password+security token ”
  • consumerKey: ” your consumer key ”
  • consumerSecret: ” your consumer secret ”
  • grantType: password
  1. Save & Run your project file.

3. aiv

  • aiv is a Business Intelligence application for both personal and business use.
  1. Start your server & launch aiv.

  2. Go to hamburger menu Image —> datasource.

  3. Click on Create from the bottom-most toolbar.

Image

  1. Find Data Endpoints from the search box:

Image

  1. Click on Data Endpoints & fill in the details as shown:

Image

  1. Click on the TEST CONNECTION button & one message is shown for Connection Successful.

Image

  1. Click on the OK & SAVE button & Go to the Datasource section in aiv.

  2. Select created Datasource & click on Create Dataset from the bottom-most toolbar.

  3. Give your dataset the name S_contacts.

  4. In query box write your query as shown. (User can get the query from the readme file available in the project zip file)

Image

  1. Click on the PREVIEW button & data of contacts is shown.

Image

  1. Click on SUBMIT button & your dataset is created.

  2. To know how to create dashboard using this dataset follow this link.