Fivetran Scheduling Modes

NextETL provides four flexible scheduling modes for Fivetran connectors, giving you precise control over when and how your data syncs occur:

1. Auto Fivetran Scheduling

   • Leverages Fivetran’s native scheduling system
   • Choose from preset sync frequencies:
     • 5 minutes
     • 15 minutes
     • 30 minutes
     • 1 hour
     • 2 hours
     • 6 hours
     • 12 hours
     • 24 hours
   • Ideal for predictable, routine sync schedules

2. Cron-based Scheduling

   • Define custom sync schedules using cron expressions
   • Supports complex scheduling patterns
   • Example: 0 */4 * * * runs every 4 hours
   • Perfect for syncs that need to run at specific times or irregular intervals
   • Full cron expression flexibility for advanced scheduling needs

3. Continuous Scheduling

   • Runs syncs continuously without pauses
   • Each sync automatically triggers when the previous sync completes
   • Optimal for:
     • Real-time data requirements
     • High-volume data sources
     • Minimal latency needs
   • Maximizes data freshness while respecting API rate limits

4. Chain Scheduling

   • Executes connectors sequentially in a defined order
   • Each connector sync triggers automatically when the previous sync completes
   • Benefits:
     • Ensures data dependencies are respected
     • Optimizes resource usage
     • Maintains data consistency across related sources
   • Ideal for:
     • ETL workflows with dependencies
     • Complex data transformations
     • Multi-stage data pipelines
   • Easily configure sync chains through the visual interface

Choose the scheduling mode that best fits your data synchronization needs and workflow requirements. You can adjust these settings at any time through the NextETL interface.