Listing Thumbnail

    CData API Server (Enterprise)

     Info
    Deployed on AWS
    Free Trial
    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.
    4.1

    Overview

    Play 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

    Delivery method

    Delivery option
    64-bit (x86) Amazon Machine Image (AMI)

    Latest version

    Operating system
    Ubuntu 20.04

    Deployed on AWS
    New

    Introducing multi-product solutions

    You can now purchase comprehensive solutions tailored to use cases and industries.

    Multi-product solutions

    Features and programs

    Financing for AWS Marketplace purchases

    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.
    Financing for AWS Marketplace purchases

    Pricing

    Free trial

    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.

    CData API Server (Enterprise)

     Info
    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.

    Usage costs (31)

     Info
    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?

    Tell us how we can improve this page, or report an issue with this product.
    Tell us how we can improve this page, or report an issue with this product.

    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.

    Usage information

     Info

    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

    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.

    Product comparison

     Info
    Updated weekly

    Accolades

     Info
    Top
    50
    In ELT/ETL
    Top
    50
    In Data Warehouses, ELT/ETL

    Customer reviews

     Info
    Sentiment is AI generated from actual customer reviews on AWS and G2
    Reviews
    Functionality
    Ease of use
    Customer service
    Cost effectiveness
    17 reviews
    Insufficient data
    Positive reviews
    Mixed reviews
    Negative reviews

    Overview

     Info
    AI generated from product descriptions
    Multi-Source Data Connectivity
    Supports connection to multiple 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
    No-code data integration interface enabling data pipeline configuration and deployment without requiring custom code development
    AWS Data Warehouse Support
    Native integration with 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 for building data integrations without requiring coding, with pre-built templates and integration wizards to accelerate development
    Parallel Data Integration Architecture
    Highly scalable parallel data integration architecture with ETL and ELT pushdown optimization patterns 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 with Integration Base, Data Integration service, and tiered connectors (Tier B, C, D) supporting regulated government cloud deployments
    Data Integration and Synchronization
    Capabilities for developing, running, and scheduling data integration flows, synchronization tasks, and data warehousing and data lake initiatives

    Contract

     Info
    Standard contract
    No
    No

    Customer reviews

    Ratings and reviews

     Info
    4.1
    18 ratings
    5 star
    4 star
    3 star
    2 star
    1 star
    55%
    17%
    28%
    0%
    0%
    1 AWS reviews
    |
    17 external reviews
    External reviews are from G2 .
    Vinay Lal

    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 esay to use and customer support is amazing , i use it frequently for every samll projects , easy of integration and implementation
    What do you dislike about the product?
    website can be made for 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 built,manage and deply 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 collegues 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.
    View all reviews