Dear Fivetran Team,

I am writing to propose a new feature that would significantly enhance the flexibility and efficiency of data pipelines within Fivetran when using SAP ERP on HANA based connector.

Current Limitation:
At present, we are unable to create custom schedules for different objects within a single pipeline or pause ingestion for specific objects. This limitation has led us to consider duplicating the connector, which is not an ideal solution in terms of resource usage and potential cost implications.

Proposed Feature:

1. Option to Group tables in a connector based on user selection
2. Set custom sync schedules for individual objects or groups of objects within a single data pipeline.
3. Pause and resume ingestion for specific objects or groups of objects without affecting the entire pipeline.

Use Case:
In our current scenario, we need to:

• Run our main SaaS data pipeline on a regular schedule.
• Extract data from Compatibility Views on an ad-hoc basis (weekly or fortnightly).
• Have the flexibility to pause ingestion for certain objects when not needed, without affecting the entire pipeline.

Benefits:

1. Improved Resource Utilization: By allowing granular control, we can optimize our data syncs based on the actual needs of different data objects.
2. Cost Efficiency: This feature could potentially reduce unnecessary data syncs, leading to cost savings under the new MAR pricing model.
3. Enhanced Flexibility: It would allow us to adapt our data ingestion strategies more dynamically to changing business needs.
4. Simplified Management: We could manage all related data objects within a single pipeline, reducing complexity and potential for errors.

We believe this feature would not only benefit our specific use case but would also be valuable to many other Fivetran customers who require more granular control over their data pipelines.

Thank you for your consideration.

Best regards,
Himanshu Jain