Bullhorn
Bullhorn’s industry-leading recruitment CRM system helps you manage existing and prospective client relationships and configure your sales process to be maximally efficient.
Connecting to Bullhorn, you need to make sure that:
- You or the user configuring Bullhorn have administrative access to the Bullhorn cloud based application.
Remember DataLakeHouse.io securely connects to your Bullhorn instance by redirecting you to the Bullhorn portal for you to sign in via Bullhorn's login. DataLakeHouse.io does not capture or store your password/credentials.
Using the form please complete the following basic steps:
- Enter a Name or Alias for this connection, in the 'Name/Alias' field, that is unique from other connectors.
- Enter in the 'Target Schema Prefix' field, a name that will be unique in your data cloud destination where you wish to land the data.
- Enter the 'Client Id' from your Bullhorn API integration
- See the How to request Client ID...section below to get this info
- Enter the 'Client Secret' credential from your Bullhorn API integration
- See the How to request Client ID...section below to get this info
- Click the Authorize Your Account button which will transport you to the Bullhorn.com login, where you will login with your account credentials. Once your credentials are accepted you will be automatically redirected back to this DataLakeHouse.io portal and you should be able to see a successful connection.
1) Log into Bullhorn and click on Help in the upper right corner
2) Submit a Support Ticket by providing the info below:
Hello,
We are working with our partner AICG to build an integration with Bullhorn's API. This integration will set the stage for our analytics which will automate a highly manual process and allow us to align team members actions with their productivity.
Please provide OAuth keys for developing applications with the Bullhorn REST API.
The redirect URI is https://app.datalakehouse.io/dashboard/oauth-redirect
3) Enter the information provided by Bullhorn in step #2 into the Source Connection for Client ID and Client Secret
The following entities are replicated by defualt to your Target Connection. These are the table names you will see in your Target Connection. There are 400 total entities available in Bullhorn and it's a best practice to replicate only the entities that you need since Bullhorn didn't their API with the intention to replicate every piece of data out of Bullhorn:
- ActivityGoalConfiguration
- ActivityGoalTarget Appointment
- AppointmentAttendee
- AppointmentEditHistory
- AppointmentEditHistoryFieldChange
- BillableChargeEditHistory
- BillableChargeEditHistoryFieldChange
- Branch
- BusinessSector
- Candidate
- CandidateCertification
- CandidateCertificationEditHistory
- CandidateCertificationEditHistoryFieldChange
- CandidateCertificationRequirement
- CandidateCertificationRequirementEditHistory
- CandidateCertificationRequirementEditHistoryFieldChange
- CandidateEducation
- CandidateFileAttachment
- CandidateHistory
- CandidateReference
- CandidateReferenceQuestion
- CandidateReferenceResponse
- CandidateSource
- CandidateTaxInfo
- CandidateWorkHistory
- Category
- Certification
- CertificationFileAttachment
- CertificationGroup
- CertificationRequirement
- CertificationRequirementStatusLookup
- ChipLayout
- ChipLayoutOption
- ChipLayoutOptionField
- ChipLayoutOptionTypeLookup
- ChipLayoutPositionLookup
- ClientContact
- ClientContact1
- ClientContact2
- ClientContact3
- ClientContact4
- ClientContact5
- ClientContactFileAttachment
- ClientContactHistory
- ClientCorporation
- ClientCorporation1
- ClientCorporation2
- ClientCorporation3
- ClientCorporation4
- ClientCorporation5
- ClientCorporationAppointment
- ClientCorporationCertification
- ClientCorporationCustomObject10EditHistory
- ClientCorporationCustomObject11EditHistory
- ClientCorporationCustomObject12EditHistory
- ClientCorporationCustomObject13EditHistory
- ClientCorporationCustomObject14EditHistory
- ClientCorporationCustomObject15EditHistory
- ClientCorporationCustomObject16EditHistory
- ClientCorporationCustomObject17EditHistory
- ClientCorporationCustomObject18EditHistory
- ClientCorporationCustomObject19EditHistory
- ClientCorporationCustomObject1EditHistory
- ClientCorporationCustomObject20EditHistory
- ClientCorporationCustomObject21EditHistory
- ClientCorporationCustomObject22EditHistory
- ClientCorporationCustomObject23EditHistory
- ClientCorporationCustomObject24EditHistory
- ClientCorporationCustomObject25EditHistory
- ClientCorporationCustomObject26EditHistory
- ClientCorporationCustomObject27EditHistory
- ClientCorporationCustomObject28EditHistory
- ClientCorporationCustomObject29EditHistory
- ClientCorporationCustomObject2EditHistory
- ClientCorporationCustomObject30EditHistory
- ClientCorporationCustomObject31EditHistory
- ClientCorporationCustomObject32EditHistory
- ClientCorporationCustomObject33EditHistory
- ClientCorporationCustomObject34EditHistory
- ClientCorporationCustomObject35EditHistory
- ClientCorporationCustomObject3EditHistory
- ClientCorporationCustomObject4EditHistory
- ClientCorporationCustomObject5EditHistory
- ClientCorporationCustomObject6EditHistory
- ClientCorporationCustomObject7EditHistory
- ClientCorporationCustomObject8EditHistory
- ClientCorporationCustomObject9EditHistory
- ClientCorporationCustomObjectEditHistoryFieldChange
- ClientCorporationCustomObjectInstance1
- ClientCorporationCustomObjectInstance10
- ClientCorporationCustomObjectInstance11
- ClientCorporationCustomObjectInstance12
- ClientCorporationCustomObjectInstance13
- ClientCorporationCustomObjectInstance14
- ClientCorporationCustomObjectInstance15
- ClientCorporationCustomObjectInstance16
- ClientCorporationCustomObjectInstance17
- ClientCorporationCustomObjectInstance18
- ClientCorporationCustomObjectInstance19
- ClientCorporationCustomObjectInstance2
- ClientCorporationCustomObjectInstance20
- ClientCorporationCustomObjectInstance21
- ClientCorporationCustomObjectInstance22
- ClientCorporationCustomObjectInstance23
- ClientCorporationCustomObjectInstance24
- ClientCorporationCustomObjectInstance25
- ClientCorporationCustomObjectInstance26
- ClientCorporationCustomObjectInstance27
- ClientCorporationCustomObjectInstance28
- ClientCorporationCustomObjectInstance29
- ClientCorporationCustomObjectInstance3
- ClientCorporationCustomObjectInstance30
- ClientCorporationCustomObjectInstance31
- ClientCorporationCustomObjectInstance32
- ClientCorporationCustomObjectInstance33
- ClientCorporationCustomObjectInstance34
- ClientCorporationCustomObjectInstance35
- ClientCorporationCustomObjectInstance4
- ClientCorporationCustomObjectInstance5
- ClientCorporationCustomObjectInstance6
- ClientCorporationCustomObjectInstance7
- ClientCorporationCustomObjectInstance8
- ClientCorporationCustomObjectInstance9
- ClientCorporationEditHistory
- ClientCorporationEditHistoryFieldChange
- ClientCorporationFileAttachment
- ClientCorporationHistory
- ClientCorporationNote
- ClientCorporationTask
- CorpFile
- CorporateUser
- CorporationDepartment
- Country
- CustomAction
- CustomEntity
- CustomEntityType
- CustomerRequiredFieldConfigurationVersion
- Deduction
- DeductionCategoryLookup
- Department
- DirectDepositAccount
- DirectDepositAccountTypeLookup
- DocumentDataFlowback
- EmployeePay
- EmployerContribution
- EntityFieldTypeLookup
- EntityTypeLookup
- EstaffMappableFlowback
- EstaffMappableFlowbackOverride
- GoalTarget
- HousingComplex
- HousingComplexAmenity
- HousingComplexFurnitureDelivery
- HousingComplexUnit
- HousingComplexUtilityAccount
- Issue
- IssueItems
- IssueResolutionStatusLookup
- JobBoardPost
- JobOrder
- JobOrder1
- JobOrder2
- JobOrder3
- JobOrder4
- JobOrder5
- JobOrderCustomObject10EditHistory
- JobOrderCustomObject1EditHistory
- JobOrderCustomObject2EditHistory
- JobOrderCustomObject3EditHistory
- JobOrderCustomObject4EditHistory
- JobOrderCustomObject5EditHistory
- JobOrderCustomObject6EditHistory
- JobOrderCustomObject7EditHistory
- JobOrderCustomObject8EditHistory
- JobOrderCustomObject9EditHistory
- JobOrderCustomObjectEditHistoryFieldChange
- JobOrderCustomObjectInstance1
- JobOrderCustomObjectInstance10
- JobOrderCustomObjectInstance2
- JobOrderCustomObjectInstance3
- JobOrderCustomObjectInstance4
- JobOrderCustomObjectInstance5
- JobOrderCustomObjectInstance6
- JobOrderCustomObjectInstance7
- JobOrderCustomObjectInstance8
- JobOrderCustomObjectInstance9
- JobOrderEditHistory
- JobOrderEditHistoryFieldChange
- JobOrderFileAttachment
- JobOrderHistory
- JobOrderRateCard
- JobOrderRateCardEditHistory
- JobOrderRateCardEditHistoryFieldChange
- JobOrderRateCardEffectiveDateChange
- JobOrderRateCardLine
- JobOrderRateCardLineGroup
- JobOrderRateCardVersion
- JobOrderTemplate
- JobShiftOfferContext
- JobSubmission
- JobSubmissionCertificationRequirement
- JobSubmissionCertificationRequirementEditHistory
- JobSubmissionCertificationRequirementEditHistoryFieldChange
- JobSubmissionEditHistory
- JobSubmissionEditHistoryFieldChange
- JobSubmissionHistory
- Location
- LocationEditHistory
- LocationEditHistoryFieldChange
- LocationEffectiveDateChange
- LocationVersion
- MappedEntityConfigurationEditHistory
- MappedEntityConfigurationEditHistoryFieldChange
- Note
- NoteEntity
- OpportunityCustomObject10EditHistory
- OpportunityCustomObject1EditHistory
- OpportunityCustomObject2EditHistory
- OpportunityCustomObject3EditHistory
- OpportunityCustomObject4EditHistory
- OpportunityCustomObject5EditHistory
- OpportunityCustomObject6EditHistory
- OpportunityCustomObject7EditHistory
- OpportunityCustomObject8EditHistory
- OpportunityCustomObject9EditHistory
- OpportunityCustomObjectEditHistoryFieldChange
- OpportunityCustomObjectInstance1
- OpportunityCustomObjectInstance10
- OpportunityCustomObjectInstance2
- OpportunityCustomObjectInstance3
- OpportunityCustomObjectInstance4
- OpportunityCustomObjectInstance5
- OpportunityCustomObjectInstance6
- OpportunityCustomObjectInstance7
- OpportunityCustomObjectInstance8
- OpportunityCustomObjectInstance9
- OpportunityEditHistory
- OpportunityEditHistoryFieldChange
- OpportunityFileAttachment
- PayableChargeEditHistory
- PayableChargeEditHistoryFieldChange
- PayCheck
- PayrollEmployeeTypeLookup
- PayrollSyncStatusLookup
- Person
- PersonCustomObject10EditHistory
- PersonCustomObject11EditHistory
- PersonCustomObject12EditHistory
- PersonCustomObject13EditHistory
- PersonCustomObject14EditHistory
- PersonCustomObject15EditHistory
- PersonCustomObject16EditHistory
- PersonCustomObject17EditHistory
- PersonCustomObject18EditHistory
- PersonCustomObject19EditHistory
- PersonCustomObject1EditHistory
- PersonCustomObject20EditHistory
- PersonCustomObject21EditHistory
- PersonCustomObject22EditHistory
- PersonCustomObject23EditHistory
- PersonCustomObject24EditHistory
- PersonCustomObject25EditHistory
- PersonCustomObject26EditHistory
- PersonCustomObject27EditHistory
- PersonCustomObject28EditHistory
- PersonCustomObject29EditHistory
- PersonCustomObject2EditHistory
- PersonCustomObject30EditHistory
- PersonCustomObject31EditHistory
- PersonCustomObject32EditHistory
- PersonCustomObject33EditHistory
- PersonCustomObject34EditHistory
- PersonCustomObject35EditHistory
- Placement
- Placement1
- Placement2
- Placement3
- Placement4
- Placement5
- PlacementCertification
- PlacementCertificationEditHistory
- PlacementCertificationEditHistoryFieldChange
- PlacementChangeRequest
- PlacementChangeRequestEditHistory
- PlacementChangeRequestEditHistoryFieldChange
- PlacementCommission
- PlacementCommissionEditHistory
- PlacementCommissionEditHistoryFieldChange
- PlacementCredentialDetail
- PlacementEditHistory
- PlacementEditHistoryFieldChange
- PlacementFileAttachment
- PlacementRateCard
- PlacementRateCardChangeRequestStatusLookup
- PlacementRateCardEditHistory
- PlacementRateCardEditHistoryFieldChange
- PlacementRateCardEffectiveDateChange
- PlacementRateCardLine
- PlacementRateCardLineGroup
- PlacementRateCardVersion
- PlacementShiftSet
- PlacementShiftSetAssociationChangeHistory
- PlacementShiftSetEditHistory
- PlacementShiftSetEditHistoryFieldChange
- PlacementShiftSetEffectiveDateChange
- PlacementShiftSetVersion
- Report
- SalesQuota
- Sendout
- Shift
- ShiftSetting
- ShiftSharedSchedule
- Skill
- Specialty
- State
- Task
- TaskEditHistory
- TaskEditHistoryFieldChange
- Tearsheet
- TearsheetMember
- TearsheetRecipient
- TextUsMessageLog
- TextUsSenderServiceLookup
- TimeUnit
- UserDepartmentGrouping
- UserEditHistory
- UserEditHistoryFieldChange
- UserHousingComplexUnit
- UserPulseCallLog
- UserPulseCallLogContact
- UserType
- WorkersCompensation
- WorkersCompensationRate
- ZipCodeGis
When the error message below appears this indicates that Bullhorn is having issues with their API. Please wait one hour and retry to authorize your connection.
Currently the following entities are not able to be retrieved as a delta load and all records will be retrieved at every sync if selected in the schema list for the connection:
- NoteEntity