By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.
Case Study

RAVACAN chooses OneSchema over Flatfile and Dromo

RAVACAN, a collaborative platform used by global sourcing teams, needed a CSV Importer solution. After a detailed evaluation process of OneSchema and Flatfile, RAVACAN moved forward with OneSchema due to its intuitive user experience and ease of setup and maintenance.

Sol Chen

Sol is the Chief of Staff at OneSchema.

July 31, 2024

Background

RAVACAN is a collaborative platform used by global sourcing teams to manage orders, inventory, prices, and lead times with suppliers. For sourcing teams, RAVACAN is a major upgrade from spreadsheets and legacy solutions. But, to get value from RAVACAN, customers first need to load Excel or CSV data into the platform. The data is often messy and poorly formatted, so the team had concerns that data import would drive huge onboarding delays.

With CSV import sitting at such a key moment for their customers, RAVACAN wanted to make sure they had the most seamless possible experience and looked to 3rd party vendors specializing in data import. Anne-Sophie Le Bloas, CEO of RAVACAN, had a few key criteria as they evaluated CSV import options:

  1. Customer Experience: The CSV importer needed to have an extremely simple UI so that customers would not abandon onboarding or contact support. The solution needed to be extremely stable and bug-free to give customers a great first impression of RAVACAN.
  2. Launch & maintenance time: As a fast-moving startup, RAVACAN wanted to launch CSV import in days, not months.
  3. Security: Since RAVACAN serves enterprise sourcing teams, data security is paramount. 

Evaluating CSV Import options

Armed with these requirements, Benjamin Beguin, Technical Co-founder at RAVACAN, kicked off a detailed evaluation process. He built out full proofs-of-concept with three CSV import options: OneSchema, Flatfile, and Dromo. 

RAVACAN then did a deeper dive into the comparative differences between OneSchema and Flatfile. “While Flatfile has a great enterprise offering, we preferred the intuitive user experience offered by OneSchema. After spending time implementing both products, it was also clear to our engineering team that OneSchema would be easier to productionize and maintain”.

Customer Experience

When evaluating the customer experience differences between the tools, Benjamin considered carefully which features would make customer onboarding as simple as possible. 

They had a couple of advanced CSV import scenarios they wanted to validate would work well. The first was upload times for very large files. When using Dromo, they found that after 200 rows there were significant resource demands created on the client side, causing the uploads to take far too long. “I really liked that OneSchema leverages an in-memory architecture,” said  Benjamin. “I don’t have to worry about the product scaling to suit our needs, as it performed well as I stress tested it on much larger files that we’re planning to upload”. 

The second was custom columns. “OneSchema’s custom columns feature is far more robust than Flatfile’s. While Flatfile allows customers to create new columns during an import, we couldn’t enforce any data validation on the newly created columns”.

Stability was also a core consideration for RAVACAN. 

“We quickly ruled out Dromo as it felt more like a tool for hobbyist developers, not software teams developing for enterprise,” said Benjamin. “There were some core issues with stability during our POC, so we didn’t have confidence the product would perform well consistently in production”. 

OneSchema allows users to export Excel files that maintain error highlighting

There were a number of other advanced features that swayed Benjamin to prefer OneSchema, the most important being “export errors to Excel”. Benjamin continued, “when our customers are uploading thousands of rows of data, it’s impossible for them to correct errors one row at a time. OneSchema lets the customer export their file to Excel, annotated with error highlighting, making it easy for customers to correct data with issues”. A final differentiator for Benjamin was OneSchema’s robust multiple select dropdown feature, which supports custom delimiters. This feature wasn’t available in any other option he evaluated. 

Launch & maintenance time

Like any fast-growing startup, RAVACAN wanted to launch this critical feature as fast as possible. To meet their launch date, they needed to find a solution that could be production ready in under one month (see: why building CSV import in-house can take years). 

“I was blown away by how fast it was to set up the OneSchema POC”, said Benjamin. With OneSchema’s out-of-the-box validation library, I didn’t have to spend any time writing data validations. I got a working implementation set up in just a couple of hours”.

Since he had implemented Flatfile first, he was expecting to have to write custom validation logic for every column in their data model. “All of the customizations we needed were as easy as flipping a switch in OneSchema’s dashboard, instead of having to write extensive custom code.” 

Maintaining the solution was also top of mind for RAVACAN. “I want our engineers to be focused on other priorities than maintaining CSV import,” said Benjamin. “With all the custom code I had to write in the Flatfile POC, it was just a lot more surface area for our team to maintain”. 

{{blog-content-cta}}

Security

Protecting the security of their customer’s sensitive business data was an absolute priority for RAVACAN.

“In combination with the stability issues, the lack of transparency in security practices and absence of compliance audits was a dealbreaker for us with Dromo” said Bloas. “We wanted to feel confident our vendor had made substantial investments in their security posture”. 

“The OneSchema team was also able to provide detailed answers to all of our security and compliance questions. OneSchema had gone through multiple SOC2 Type II audits and had clearly thought through how to maintain compliance as they scale and launch new features”, added Benjamin (see also: OneSchema’s Best Practices for Getting SOC2 Type II Certified).

Conclusion

After implementing a proof-of-concept for both OneSchema and Flatfile it was clear to the RAVACAN team that OneSchema was the right long-term partner. 

“OneSchema really nailed the CSV import customer experience, and that’s ultimately what’s most important to us”.

Benjamin Beguin, Engineering Manager at Ravacan

"The product is incredibly easy for our customers to use. They’ve taken the huge headache of CSV import off of our hands. We’re so glad to be able to focus our engineering resources on the many, many other features on our long product roadmap".

Read more about why startups are choosing OneSchema over Flatfile here

OneSchema logo

Engineering and product teams use OneSchema to easily build out best-in-class data import capabilities for their customers. Instead of spending months writing data validations and handing CSV parsing edge cases, focus your development resources on your core product development. With minimal engineering investment, improve your customer activation rates and launch better onboarding than your competitors.

Ready to make data imports effortless and efficient? Request a demo of OneSchema here or email us at sales@oneschema.co.

Continue reading

Human with plants and dashboards

Make data imports effortless and efficient

Ready to get started?

Case Study
August 17, 2022

RAVACAN chooses OneSchema over Flatfile and Dromo

Sol Chen
Sol is the Chief of Staff at OneSchema.
Launch CSV import in minutes
Companies like Ramp, Toast, Scale AI, and Vanta trust OneSchema to provide a delightfully guided spreadsheet import experience for their customers.

Background

RAVACAN is a collaborative platform used by global sourcing teams to manage orders, inventory, prices, and lead times with suppliers. For sourcing teams, RAVACAN is a major upgrade from spreadsheets and legacy solutions. But, to get value from RAVACAN, customers first need to load Excel or CSV data into the platform. The data is often messy and poorly formatted, so the team had concerns that data import would drive huge onboarding delays.

With CSV import sitting at such a key moment for their customers, RAVACAN wanted to make sure they had the most seamless possible experience and looked to 3rd party vendors specializing in data import. Anne-Sophie Le Bloas, CEO of RAVACAN, had a few key criteria as they evaluated CSV import options:

  1. Customer Experience: The CSV importer needed to have an extremely simple UI so that customers would not abandon onboarding or contact support. The solution needed to be extremely stable and bug-free to give customers a great first impression of RAVACAN.
  2. Launch & maintenance time: As a fast-moving startup, RAVACAN wanted to launch CSV import in days, not months.
  3. Security: Since RAVACAN serves enterprise sourcing teams, data security is paramount. 

Evaluating CSV Import options

Armed with these requirements, Benjamin Beguin, Technical Co-founder at RAVACAN, kicked off a detailed evaluation process. He built out full proofs-of-concept with three CSV import options: OneSchema, Flatfile, and Dromo. 

RAVACAN then did a deeper dive into the comparative differences between OneSchema and Flatfile. “While Flatfile has a great enterprise offering, we preferred the intuitive user experience offered by OneSchema. After spending time implementing both products, it was also clear to our engineering team that OneSchema would be easier to productionize and maintain”.

Customer Experience

When evaluating the customer experience differences between the tools, Benjamin considered carefully which features would make customer onboarding as simple as possible. 

They had a couple of advanced CSV import scenarios they wanted to validate would work well. The first was upload times for very large files. When using Dromo, they found that after 200 rows there were significant resource demands created on the client side, causing the uploads to take far too long. “I really liked that OneSchema leverages an in-memory architecture,” said  Benjamin. “I don’t have to worry about the product scaling to suit our needs, as it performed well as I stress tested it on much larger files that we’re planning to upload”. 

The second was custom columns. “OneSchema’s custom columns feature is far more robust than Flatfile’s. While Flatfile allows customers to create new columns during an import, we couldn’t enforce any data validation on the newly created columns”.

Stability was also a core consideration for RAVACAN. 

“We quickly ruled out Dromo as it felt more like a tool for hobbyist developers, not software teams developing for enterprise,” said Benjamin. “There were some core issues with stability during our POC, so we didn’t have confidence the product would perform well consistently in production”. 

OneSchema allows users to export Excel files that maintain error highlighting

There were a number of other advanced features that swayed Benjamin to prefer OneSchema, the most important being “export errors to Excel”. Benjamin continued, “when our customers are uploading thousands of rows of data, it’s impossible for them to correct errors one row at a time. OneSchema lets the customer export their file to Excel, annotated with error highlighting, making it easy for customers to correct data with issues”. A final differentiator for Benjamin was OneSchema’s robust multiple select dropdown feature, which supports custom delimiters. This feature wasn’t available in any other option he evaluated. 

Launch & maintenance time

Like any fast-growing startup, RAVACAN wanted to launch this critical feature as fast as possible. To meet their launch date, they needed to find a solution that could be production ready in under one month (see: why building CSV import in-house can take years). 

“I was blown away by how fast it was to set up the OneSchema POC”, said Benjamin. With OneSchema’s out-of-the-box validation library, I didn’t have to spend any time writing data validations. I got a working implementation set up in just a couple of hours”.

Since he had implemented Flatfile first, he was expecting to have to write custom validation logic for every column in their data model. “All of the customizations we needed were as easy as flipping a switch in OneSchema’s dashboard, instead of having to write extensive custom code.” 

Maintaining the solution was also top of mind for RAVACAN. “I want our engineers to be focused on other priorities than maintaining CSV import,” said Benjamin. “With all the custom code I had to write in the Flatfile POC, it was just a lot more surface area for our team to maintain”. 

{{blog-content-cta}}

Security

Protecting the security of their customer’s sensitive business data was an absolute priority for RAVACAN.

“In combination with the stability issues, the lack of transparency in security practices and absence of compliance audits was a dealbreaker for us with Dromo” said Bloas. “We wanted to feel confident our vendor had made substantial investments in their security posture”. 

“The OneSchema team was also able to provide detailed answers to all of our security and compliance questions. OneSchema had gone through multiple SOC2 Type II audits and had clearly thought through how to maintain compliance as they scale and launch new features”, added Benjamin (see also: OneSchema’s Best Practices for Getting SOC2 Type II Certified).

Conclusion

After implementing a proof-of-concept for both OneSchema and Flatfile it was clear to the RAVACAN team that OneSchema was the right long-term partner. 

“OneSchema really nailed the CSV import customer experience, and that’s ultimately what’s most important to us”.

Benjamin Beguin, Engineering Manager at Ravacan

"The product is incredibly easy for our customers to use. They’ve taken the huge headache of CSV import off of our hands. We’re so glad to be able to focus our engineering resources on the many, many other features on our long product roadmap".

Read more about why startups are choosing OneSchema over Flatfile here

OneSchema logo

Engineering and product teams use OneSchema to easily build out best-in-class data import capabilities for their customers. Instead of spending months writing data validations and handing CSV parsing edge cases, focus your development resources on your core product development. With minimal engineering investment, improve your customer activation rates and launch better onboarding than your competitors.

Ready to make data imports effortless and efficient? Request a demo of OneSchema here or email us at sales@oneschema.co.

Background

RAVACAN is a collaborative platform used by global sourcing teams to manage orders, inventory, prices, and lead times with suppliers. For sourcing teams, RAVACAN is a major upgrade from spreadsheets and legacy solutions. But, to get value from RAVACAN, customers first need to load Excel or CSV data into the platform. The data is often messy and poorly formatted, so the team had concerns that data import would drive huge onboarding delays.

With CSV import sitting at such a key moment for their customers, RAVACAN wanted to make sure they had the most seamless possible experience and looked to 3rd party vendors specializing in data import. Anne-Sophie Le Bloas, CEO of RAVACAN, had a few key criteria as they evaluated CSV import options:

  1. Customer Experience: The CSV importer needed to have an extremely simple UI so that customers would not abandon onboarding or contact support. The solution needed to be extremely stable and bug-free to give customers a great first impression of RAVACAN.
  2. Launch & maintenance time: As a fast-moving startup, RAVACAN wanted to launch CSV import in days, not months.
  3. Security: Since RAVACAN serves enterprise sourcing teams, data security is paramount. 

Evaluating CSV Import options

Armed with these requirements, Benjamin Beguin, Technical Co-founder at RAVACAN, kicked off a detailed evaluation process. He built out full proofs-of-concept with three CSV import options: OneSchema, Flatfile, and Dromo. 

RAVACAN then did a deeper dive into the comparative differences between OneSchema and Flatfile. “While Flatfile has a great enterprise offering, we preferred the intuitive user experience offered by OneSchema. After spending time implementing both products, it was also clear to our engineering team that OneSchema would be easier to productionize and maintain”.

Customer Experience

When evaluating the customer experience differences between the tools, Benjamin considered carefully which features would make customer onboarding as simple as possible. 

They had a couple of advanced CSV import scenarios they wanted to validate would work well. The first was upload times for very large files. When using Dromo, they found that after 200 rows there were significant resource demands created on the client side, causing the uploads to take far too long. “I really liked that OneSchema leverages an in-memory architecture,” said  Benjamin. “I don’t have to worry about the product scaling to suit our needs, as it performed well as I stress tested it on much larger files that we’re planning to upload”. 

The second was custom columns. “OneSchema’s custom columns feature is far more robust than Flatfile’s. While Flatfile allows customers to create new columns during an import, we couldn’t enforce any data validation on the newly created columns”.

Stability was also a core consideration for RAVACAN. 

“We quickly ruled out Dromo as it felt more like a tool for hobbyist developers, not software teams developing for enterprise,” said Benjamin. “There were some core issues with stability during our POC, so we didn’t have confidence the product would perform well consistently in production”. 

OneSchema allows users to export Excel files that maintain error highlighting

There were a number of other advanced features that swayed Benjamin to prefer OneSchema, the most important being “export errors to Excel”. Benjamin continued, “when our customers are uploading thousands of rows of data, it’s impossible for them to correct errors one row at a time. OneSchema lets the customer export their file to Excel, annotated with error highlighting, making it easy for customers to correct data with issues”. A final differentiator for Benjamin was OneSchema’s robust multiple select dropdown feature, which supports custom delimiters. This feature wasn’t available in any other option he evaluated. 

Launch & maintenance time

Like any fast-growing startup, RAVACAN wanted to launch this critical feature as fast as possible. To meet their launch date, they needed to find a solution that could be production ready in under one month (see: why building CSV import in-house can take years). 

“I was blown away by how fast it was to set up the OneSchema POC”, said Benjamin. With OneSchema’s out-of-the-box validation library, I didn’t have to spend any time writing data validations. I got a working implementation set up in just a couple of hours”.

Since he had implemented Flatfile first, he was expecting to have to write custom validation logic for every column in their data model. “All of the customizations we needed were as easy as flipping a switch in OneSchema’s dashboard, instead of having to write extensive custom code.” 

Maintaining the solution was also top of mind for RAVACAN. “I want our engineers to be focused on other priorities than maintaining CSV import,” said Benjamin. “With all the custom code I had to write in the Flatfile POC, it was just a lot more surface area for our team to maintain”. 

{{blog-content-cta}}

Security

Protecting the security of their customer’s sensitive business data was an absolute priority for RAVACAN.

“In combination with the stability issues, the lack of transparency in security practices and absence of compliance audits was a dealbreaker for us with Dromo” said Bloas. “We wanted to feel confident our vendor had made substantial investments in their security posture”. 

“The OneSchema team was also able to provide detailed answers to all of our security and compliance questions. OneSchema had gone through multiple SOC2 Type II audits and had clearly thought through how to maintain compliance as they scale and launch new features”, added Benjamin (see also: OneSchema’s Best Practices for Getting SOC2 Type II Certified).

Conclusion

After implementing a proof-of-concept for both OneSchema and Flatfile it was clear to the RAVACAN team that OneSchema was the right long-term partner. 

“OneSchema really nailed the CSV import customer experience, and that’s ultimately what’s most important to us”.

Benjamin Beguin, Engineering Manager at Ravacan

"The product is incredibly easy for our customers to use. They’ve taken the huge headache of CSV import off of our hands. We’re so glad to be able to focus our engineering resources on the many, many other features on our long product roadmap".

Read more about why startups are choosing OneSchema over Flatfile here

OneSchema logo

Engineering and product teams use OneSchema to easily build out best-in-class data import capabilities for their customers. Instead of spending months writing data validations and handing CSV parsing edge cases, focus your development resources on your core product development. With minimal engineering investment, improve your customer activation rates and launch better onboarding than your competitors.

Ready to make data imports effortless and efficient? Request a demo of OneSchema here or email us at sales@oneschema.co.