Integrations Overview

DrillerDB integrates with popular business tools to streamline your workflows. The Integrations section allows you to connect and manage all third-party services from one central location.

Quick Start: Connect an Integration

1. Go to Settings > Integrations
2. Find the service to connect
3. Click Connect or Authorize
4. Complete the OAuth authentication flow
5. Configure sync settings as needed

Step-by-Step Workflow

1. Go to Settings > Integrations
2. Find the service to connect
3. Click Connect or Authorize
4. Complete the OAuth authentication flow
5. Configure sync settings as needed

Available Integrations

Accounting Software

Connect your accounting system to sync customers, invoices, and payments:

• QuickBooks Online - Full bidirectional sync with QuickBooks for general business accounting
• Foundation Software - Integration via Agave API for construction contractors using Foundation's job costing and accounting

These integrations eliminate double-entry by automatically syncing financial data between systems. Only one accounting system can be connected at a time.

Payment Processing

Enable online payment collection from customers:

• Stripe Connect - Credit card and ACH bank transfer processing for invoices

Stripe integration allows customers to pay invoices directly from the customer portal with credit cards or bank transfers.

Communication Services

DrillerDB integrates with communication platforms:

• Twilio - SMS notifications for field crews
• Mandrill - Email delivery service for transactional emails
• Google Identity - Single sign-on with Google accounts

Fleet Management

Connect fleet tracking services:

• Motive (formerly KeepTruckin) - Electronic logging device integration
• GPS TrackIt - Real-time vehicle tracking

Mapping & Location

Built-in integrations for location services:

• Google Maps - Project mapping and directions
• Google Places - Address autocomplete and validation

AI & Data Services

Automated data enrichment:

• OpenAI GPT-5 - Well log analysis and PDF extraction
• Wisconsin DNR - Automated well data import
• Synoptic Weather API - Real-time weather data

Managing Integrations

Connecting a Service

To connect a new integration:

1. Navigate to Settings > Integrations
2. Find the service you want to connect
3. Click Connect or Authorize
4. Follow the OAuth authentication flow
5. Grant necessary permissions
6. Return to DrillerDB to confirm connection

Active Connections

View all active integrations with status indicators:

• Green - Connected and syncing
• Yellow - Authentication needs refresh
• Red - Connection error, needs attention

Disconnecting

To disconnect a service:

1. Click Manage next to the integration
2. Select Disconnect
3. Confirm the action
4. Data already synced remains in DrillerDB

Integration Settings

Each integration has specific configuration options:

• Sync Frequency - How often data syncs (real-time, hourly, daily)
• Sync Direction - One-way or bidirectional sync
• Field Mapping - Which fields sync between systems
• Default Values - Fallback values for missing data

Access integration-specific settings by clicking Configure next to each connected service.

Troubleshooting Connections

If an integration shows an error:

• Check that your credentials are still valid
• Verify the service is not experiencing downtime
• Try disconnecting and reconnecting
• Contact support if issues persist

Integration logs are available in the Activity Log for debugging sync issues.

Beta Integrations

Some integrations are available in beta:

• Limited to select customers
• May have reduced functionality
• Contact support to request access

Beta integrations help us test new features before general release.

Related Topics

• QuickBooks Online - Accounting sync setup
• Foundation Software - Construction accounting
• Stripe Connect - Payment processing
• Activity Log - View sync logs