Easily create APIs from existing enterprise data. Connect CData API Server to any RDBMS, NoSQL database, or custom app, and API Server instantly generates flexible, comprehensive, and fully documented APIs.
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.
AWS Marketplace now accepts line of credit payments through the PNC Vendor Finance program. This program is available to select AWS customers in the US, excluding NV, NC, ND, TN, & VT.
Try this product free for 7 days according to the free trial terms set by the vendor. Usage-based pricing is in effect for usage beyond the free trial terms. Your free trial gets automatically converted to a paid subscription when the trial ends, but may be canceled any time before that.
Pricing is based on actual usage, with charges varying according to how much you consume. Subscriptions have no end date and may be canceled any time. Alternatively, you can pay upfront for a contract, which typically covers your anticipated usage for the contract duration. Any usage beyond contract will incur additional usage-based costs.
Additional AWS infrastructure costs may apply. Use the AWS Pricing Calculator to estimate your infrastructure costs.
You pay by the hour based on the Amazon EC2 instance type you run. Each dimension maps to a specific instance size across the t2, t3, t3a, m4, m5, m5d, c5d, and r5d families. Pricing scales with the compute, memory, and storage capacity of the instance you pick. Smaller instances like t2.small or t3.small suit lighter workloads, while larger ones like m4.16xlarge or m5.4xlarge handle heavier demand. You are billed only for the hours each instance runs, with no upfront commitment.
Top-of-mind questions for buyers
What does one hourly instance charge actually cover, and what runs on it?
Each hour covers the API Server software running on one Amazon EC2 instance of the size you pick. The software lets you build and publish REST, OData, and JSON APIs from connected databases. The instance family and size set the compute, memory, and storage behind your APIs.
Am I charged when my EC2 instance is stopped or paused?
The software charge meters running hours only. A fully stopped instance does not accrue the hourly software fee. You may still owe underlying AWS fees, such as storage for the instance, while it sits stopped. Billing resumes when you start the instance again.
How do I choose between the smaller and larger instance types offered?
Pick based on API traffic and database workload. Smaller types like t2.small or t3.small fit light request volumes. Larger types like m4.16xlarge or m5.4xlarge handle more concurrent API calls and bigger data sets. All run the same software; the instance size only changes the compute, memory, and storage.
www.cdata.com
Helpful?
Vendor refund policy
We do not currently support refunds, but you can cancel at any time.
How can we make this page better?
Tell us how we can improve this page, or report an issue with this product.
Give us feedbackReport a problem with this product or seller
Legal
Vendor terms and conditions
Upon subscribing to this product, you must acknowledge and agree to the terms and conditions outlined in the vendor's End User License Agreement (EULA).
Content disclaimer
Vendors are responsible for their product descriptions and other product content. AWS does not warrant that vendors' product descriptions or other product content are accurate, complete, reliable, current, or error-free.
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.
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.
Supports connection to various data sources including RDBMS (SQL Server, MySQL, DB2), NoSQL databases (Mongo, Cassandra), flat files, and custom applications.
RESTful API Generation
Automatically generates flexible and fully documented RESTful APIs from connected data sources through point-and-click configuration without requiring custom development.
Multiple Data Format Support
Exposes data through multiple formats and protocols including OData, REST, JSON, SOAP, and CSV/TSV.
API Security and Management
Includes API management features for security, monitoring, logging, rate limiting, and embedded SSH Reverse Tunneling for secure cross-firewall access.
Data Caching and Query Optimization
Provides local data caching capabilities and query offloading functionality to reduce load on source systems and improve performance.
Data Source Connectivity
Supports integration with 250+ data sources and 50+ destinations including applications, data warehouses, data lakes, and dashboarding tools
Data Integration Patterns
Supports ETL, ELT, reverse ETL, and database replication patterns for bidirectional data movement between sources and destinations
No-Code Integration Platform
Enables data pipeline configuration and deployment through visual interface without requiring code development
AWS Data Warehouse Support
Fully supports AWS data warehouse and storage services including Redshift, S3, Aurora, and RDS
Security and Compliance Certifications
SOC 2 Type II certified and compliant with ISO 27001 and major global data privacy regulations
Codeless Visual Development Interface
Drag and drop visual UI enabling users to build data integrations without coding, with pre-built templates and integration wizards for accelerated development
Parallel Data Integration Architecture
Highly scalable parallel data integration architecture supporting both ETL and ELT patterns with pushdown optimization for maximum throughput and performance into Amazon Redshift
Multi-Source Connectivity
Native connectors supporting hundreds of applications and data sources across on-premises and cloud environments including AWS services (Redshift, S3, RDS, Aurora) and enterprise applications (Salesforce, Workday, Oracle, SAP, ServiceNow)
FedRAMP Compliance
FedRAMP authorization including Integration Base, Data Integration, and tiered connectors (Tier B, C, D) for government cloud deployments
Data Integration and Synchronization
Capabilities for data warehousing, data lake initiatives, and task flow orchestration with support for scheduling and automation of data synchronization across multiple sources and destinations
Automated data testing has transformed our APIs and now accelerates CI CD pipelines
Reviewed on Aug 03, 2026
Review from a verified AWS customer
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.
Which deployment model are you using for this solution?
On-premises
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Amazon Web Services (AWS)
Rounak S.
my experience is amazing
Reviewed on May 19, 2024
Review provided by G2
What do you like best about the product?
it helped me accessing data easily and easy to use and customer support is amazing, i use it frequently for every small project, ease of integration and implementation
What do you dislike about the product?
website can be made more informative and all good
What problems is the product solving and how is that benefiting you?
CData API Server helps users connect and integrate data from different sources, which can improve data accessibility, streamline workflows, and increase operational efficiency
Desireddy R.
Fresher
Reviewed on Mar 09, 2024
Review provided by G2
What do you like best about the product?
Including Cloud sources GCP, AWS, and Azure
What do you dislike about the product?
A tool that allows you to build, manage, and deploy REST APIs
What problems is the product solving and how is that benefiting you?
Automatic integration process like mass imports/exports/updates, data cleaning, and de-duplication.
Computer Networking
It was a nice experience using it and it is easy to use for everyone
Reviewed on Feb 25, 2024
Review provided by G2
What do you like best about the product?
The everything in the CData API server is good and nothing is bad
What do you dislike about the product?
Sometimes it becomes glitchy and It is very disappointing
What problems is the product solving and how is that benefiting you?
It's solving my colleagues' problem and they are creating APIs easily that makes them burden free
Facilities Services
Unveiling the Power of CDATA: A Comprehensive Review
Reviewed on Nov 22, 2023
Review provided by G2
What do you like best about the product?
The flexibility it offers in connecting various data sources seamlessly and the ease of creating APIs from disparate data formats are some of its standout features. This allows for efficient data integration and management across different platforms.
What do you dislike about the product?
From what I've seen, some users have found the learning curve a bit steep initially, especially if they're not familiar with working extensively with APIs or managing data connections. Additionally, while it's powerful, configuring complex setups can sometimes require meticulous attention to detail.
What problems is the product solving and how is that benefiting you?
CData API Server addresses the challenge of integrating diverse data sources, enabling easier access and interaction with disparate data formats through a unified API. This benefits users by streamlining data management, reducing complexity in application development, and facilitating smoother data workflows across platforms.