Skip to main content

Freshdesk Connection with opnbi using airbyte

Let's make the connection between freshdesk and opnbi using the airbyte. Here, we take API key from freshdesk and integrate it in the airbyte using source to the destination then we add that Datasource connection into the opnbi to fetch the data.

Now, here we have some questions about the connection,

  1. does that work only once or 2. do we need to make the connection for every new freshdesk user. Basically, we need to make the connection only once in airbyte but if we find any change between one user to another user on freshdesk then we need to make a separate connection or just change the 'Personal Access Token' in airbyte.

Connection Overview

We connect the freshdesk with the opnbi using the airbyte, where we take the data from freshdesk and can make the reports and dashboards in opnbi.

Here airbyte provides the active synchronization of data from freshdesk to opnbi. the synchronization can be automatic or manual as per the user's requirements.

Benefits with airbyte connection between the freshdesk and opnbi

  • The Airbyte Auto Sync the updates of the data from the vendor as per the selected time for example from once in 5 minutes to every 24 hours.
  • Users can sync the data manually every time they update from the vendor.
  • User can add a prefix to streamed sources.

Note

  • The Airbyte only takes the data from the Vendor and delivers it to the opnbi application.
  • The Airbyte only fetches the data, which is provided by the vendor, we can say that the vendor is responsible for all the data limitations.
  • The Vendor can have data in the format of Excel, Multi-tab Excel, CSV, CSV without headers, Delimited Text, Fixed width Text e.g., 80Bytes, Fixed position text, Log files (grok patterns), EDI, Avro, Parquet, JSON, JSONL, XML, OCR.

Steps by step documentation of the freshdesk and opnbi connection:

https://docs.opnbi.com/opnbi/Master%20Data/Datasource/FreshdeskAirbyteConnection

Video Tutorial of the freshdesk and opnbi connection:

https://youtu.be/XsedJYv2qjE

Freshdesk reference site:

https://freshdesk.com/

Airbyte reference site:

https://airbyte.com/

Find API key from freshdesk support:

https://support.freshdesk.com/support/solutions/articles/215517