Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

New Connector: RMS WEB SERVICE

Answered
Sho Kazari User

Subject: Request for RMS Web Service Connector

Hello Fivetran Support Team,

I hope you’re doing well. We’re currently leveraging Fivetran to centralize data from multiple systems into our Snowflake data warehouse, and we’d like to request the addition of an RMS Web Service connector.

Use Case
We need to ingest our retail management system (RMS) data—specifically sales orders, inventory levels, and product metadata—via its REST/Web Service API on a daily incremental schedule. This data is critical for our downstream reporting and analytics workflows.

Connector Requirements

  • Authentication: Basic OAuth or API key support

  • Endpoints:

    • /orders (sales orders)

    • /inventory (stock levels)

    • /products (product catalog)

  • Sync frequency: Daily incremental updates

  • Schema mapping: Tables for orders, inventory, and products under a designated “rms_web_service” schema

Could you please let us know:

  1. If you plan to support the RMS Web Service connector in an upcoming release?

  2. An estimated timeline or roadmap for its availability?

  3. Any additional details or credentials you would need from our side?

Thank you for your help—this connector would streamline our ETL process and greatly enhance our data reliability. Please let me know if you have any questions or require further information.

Best regards,
Sho Kazari

https://webservice.rms.rakuten.co.jp/merchant-portal/view/ja/common/1-1_service_index/purchaseitemapi/getorderitem/

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Unnikrishnan Nair Fivetranner

    Hi Sho,
    Thanks for the details around the new connector ask. 
    It looks like our By Request program might be the right solution for you.

    The By Request process allows you to request that Fivetran prioritize a new Lite connector that delivers an immediate business impact to your company. As a participant in this program, your team will have free, first access to the data during the build and validation phase. In exchange, you will provide us access to portions of your data to help Fivetran validate the Lite Connector during the build process as we build out the connector and full ERD.

    If you're interested in working with us to build a lite connector please complete the Fivetran Lite Connector Request Form to submit your request. You can find more details about the program in our By Request documentation.

    Once submitted, one of our Technical Product Specialists will review the request and follow up with you.

    Thank you for being a valued customer and happy data pipelining!