Lyftrondata Pipedrive Provider
The Lyftrondata API Profile for Pipedrive allows you to query data from Pipedrive. The Pipedrive profile is a single file (i.e. pipedrive.apip) which is meant to be used with the Lyftrondata API Driver. The profile contains the table definitions and other Pipedrive specific metadata that the Lyftrondata API Driver uses to connect to Pipedrive.
To use the Pipedrive Profile set the Profile property of Lyftrondata API Driver to the path of the Pipedrive profile, as well as the other connection properties specified in the documentation below. Once the Lyftrondata API Driver has been configured, you can issue SQL queries to access data from any of the Pipedrive Tables.
Connecting to Pipedrive
You need your API key to connect to Pipedrive. It can be obtained by navigating to Settings > Customize > Personal > Other > API. Set the profile setting APIKey to this value.