Overview

Product video
Build a RESTful APIs from your data with a few clicks.
The API Server is a lightweight application that allows users to create and expose data APIs from any data source, without the need for custom development. Through simple point-and-click configuration, user can create and configure access from popular clients like Microsoft Power BI, Salesforce Lightning Connect, SharePoint External Lists, Excel, PowerPivot, and more.
Use CData API Server to:
- Integrate with popular applications like Power BI, Salesforce Lightning Connect, Microsoft SharePoint.
- Automate integration processes like mass imports / exports / updates, data cleansing & de-duplication.
- Cache data locally and offload queries to reduce load and increase performance.
- Expose internal resources securely across the firewall via embedded SSH Reverse Tunneling.
Whether your focus is on facilitating internal operations, partner integrations, or public data access, APIs are the key to increasing business agility and unlocking the true innovation potential of your data. The API Server is the tool you need to publish enterprise-ready REST APIs in minutes - no custom development required.
Highlights
- APIs from Any Database - Supports popular databases like SQL Server, MySQL, DB2, Mongo, Cassandra, Flat Files, etc.
- Open Data Access - Expose entry-points for popular formats like OData, REST, JSON, SOAP, CSV/TSV, etc
- API Management -Includes critical API management features for security, monitoring, logging, rate limiting, etc.
Details
Introducing multi-product solutions
You can now purchase comprehensive solutions tailored to use cases and industries.
Features and programs
Financing for AWS Marketplace purchases
Pricing
Free trial
Dimension | Cost/hour |
|---|---|
m5d.xlarge Recommended | $1.427 |
t3.2xlarge | $0.77 |
t2.2xlarge | $0.77 |
m5d.4xlarge | $2.854 |
t2.medium | $0.61 |
t3.medium | $0.61 |
m5d.2xlarge | $2.141 |
t3a.medium | $0.61 |
t3a.xlarge | $0.77 |
t3a.large | $0.61 |
Vendor refund policy
We do not currently support refunds, but you can cancel at any time.
How can we make this page better?
Legal
Vendor terms and conditions
Content disclaimer
Delivery details
64-bit (x86) Amazon Machine Image (AMI)
Amazon Machine Image (AMI)
An AMI is a virtual image that provides the information required to launch an instance. Amazon EC2 (Elastic Compute Cloud) instances are virtual servers on which you can run your applications and workloads, offering varying combinations of CPU, memory, storage, and networking resources. You can launch as many instances from as many different AMIs as you need.
Version release notes
n/a
Additional details
Usage instructions
Running the CData API Server in EC2 is easy. Simply launch a new API Server AMI from EC2, and configure the EC2 instance type, instance details, volume, tags, and security group. The last step of the process will prompt you to create a new key-pair, or select an existing one.
Once the instance has been launched, it will be listed in your EC2 running instances. You can then access the API Server through your browser at the URL: https://instance_public_DNS
In order to log-in, the default username is "admin", and the password is the instance's randomly generated Instance-ID, which you can find from the EC2 Management Console. After agreeing to the Terms and Conditions, you will be able to create connections and configure your APIs. For advanced configurations, refer to the documentation or contact support@cdata.com .
Resources
Vendor resources
Support
Vendor support
We provide standard technical support via email. We do our best to answer the messages quickly, so you can get your job done. Support is prioritized in favor of people who have purchased the premium support package and the product in question. support@cdata.com
AWS infrastructure support
AWS Support is a one-on-one, fast-response support channel that is staffed 24x7x365 with experienced and technical support engineers. The service helps customers of all sizes and technical abilities to successfully utilize the products and features provided by Amazon Web Services.

Standard contract
Customer reviews
Automated data testing has transformed our APIs and now accelerates CI CD pipelines
What is our primary use case?
My main use case for CData API Server is to ensure high-velocity test execution, seamless API governance, and reliable data pipelines across multi-tenant environments. CData API Server is helping us bridge the gap between heterogeneous databases such as SQL Server, Oracle, PostgreSQL, and other servers. It is automating our testing and QA frameworks, which is our basic use case. Additionally, it automatically generates secure and production-grade REST APIs over our diverse back-end databases without writing custom code.
CData API Server assists in test automation and virtualization, powering our automated regression test suites, mock servicing layers, and test data management TDM pipelines. It also feeds real-time synthetic test data directly into our CI/CD pipelines, which we use with Jenkins and test execution tools.
What is most valuable?
My favorite features of CData API Server include the automated Swagger Open API documentation, which automatically generates live OpenAPI specs, allowing our QA automation engineers to import the endpoints directly into Postman, SoapUI, or custom framework scripts instantly. Another standout feature is its highly scalable and low-overhead solution that handles high throughput payload and demands during stress testing without any bottleneck or memory leaks. I also love the instant REST API generation, which allows us to plug into any enterprise data source and instantly expose a fully documented REST endpoint, saving us hundreds of development hours and providing us with a good return on investment.
CData API Server's robust automated Swagger Open API documentation and instant REST endpoint generation are important for our organization because they allow our engineers to import endpoints directly into Postman or custom frameworks instantly, saving a significant amount of manual work and enabling direct testing from Postman, which ultimately saves a lot of time and resources.
What needs improvement?
A small detail that could enhance my experience further is that while the UI is very good, it could be improved slightly, and the learning curve for new users could be made easier.
For how long have I used the solution?
I have been using CData API Server for almost two and a half years.
What do I think about the stability of the solution?
CData API Server is stable, maintaining 100% stability.
What do I think about the scalability of the solution?
CData API Server's scalability is excellent. It is a very scalable platform that allows us to easily scale up and down based on our needs.
How are customer service and support?
Customer support for CData API Server is a ten out of ten. We spoke with them last month regarding updates and faced some challenges after a recent update. They fixed it within minutes, which was great.
How was the initial setup?
The configuration process was easy and was completed within a couple of weeks with the help of CData API Server's team. It was configured smoothly with our engineers and support team.
What about the implementation team?
Integrations of CData API Server with other AWS services are seamless, and it connects easily without requiring extensive work, making it simple to integrate into workflows.
What was our ROI?
CData API Server has positively impacted our organization with significant changes. The top three metrics include an 80% reduction in API development time, eliminating the need for developers to handle code CRUD API points for QA environments, which has cut down delivery cycles from weeks to hours. Additionally, we have seen a 78% acceleration in regression testing and test automation suites across centralized API endpoints effortlessly, lowering the test execution cycle times significantly. We also estimate around $200,000 annually in engineering hours by avoiding custom middleware maintenance and dedicated back-end developer overhead for API wrappers.
What's my experience with pricing, setup cost, and licensing?
My experience with pricing, setup costs, and licensing has always been on point.
Which other solutions did I evaluate?
Before choosing CData API Server, we evaluated other options, including MuleSoft Anypoint Platform and DreamFactory.
What other advice do I have?
CData API Server's ability to generate secure, production-grade REST APIs without custom code has definitely saved a lot of time compared to what we did previously, allowing us to save at least 60% to 70% of time. Team collaboration and motivation are also up.
CData API Server has contributed to team collaboration and motivation by saving a lot of time when it replaced the need for using basic custom code and going back and forth for APIs. This change freed up time for our teams to interact better and understand each other, leading to significant improvements in collaboration both within and across teams.
The teams initially felt some doubt since it cut down developers' work by 80% in API generation. However, it is a tool that helps them be more productive, allowing them to focus on other necessary tasks. This has increased their productivity by at least 50 to 55%, enabling them to work better on debugging and refactoring whenever required, consequently improving code quality.
A specific example of where the team used the extra time for something valuable is evidenced by sprint cycles. Before implementing CData API Server, the development team velocity was around 35 to 38, but after implementation, the sprint velocity increased by at least 10 to 15 points, which is a significant improvement.
My advice to others looking into CData API Server is that they should definitely consider it, as it perfectly meets needs within budget, delivering high quality and bug-free solutions. I would rate this product a ten out of ten.
