TrustRadius: an HG Insights company

Actian DataConnect vs. Phocas Business Intelligence

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Actian DataConnect

    Score6 out of 10
    Mid-Size Companies (51-1,000 employees)
    HCL DataConnect (formerly Actian DataConnect) is a hybrid integration solution that enables users to integrate anything, anywhere, anytime. It can be deployed in on-premise, cloud, and/or hybrid environments and offers quick onboarding. With its emphasis data quality, data reuse, adaptability and self-service integration, DataConnect is designed to support rapid onboarding and deliver the fast time to value.N/A

    Phocas Business Intelligence

    Score9.3 out of 10
    N/APhocas helps users discover data and provides results in real time.  It is designed for non-technical users and delivers a simple yet powerful analytical capability that quickly turns data into a chart, graph or map.  It brings up data on local, regional or global sales, inventory, forecasts, prices, profit margins, budgets and more. Phocas, based in the United Kingdom, is a business intelligence firm with offices in…N/A
    Pricing
    Actian DataConnectPhocas Business Intelligence
    Editions & Modules
    No answers on this topic
    No answers on this topic
    Offerings
    Pricing Offerings
    Actian DataConnectPhocas Business Intelligence
    Free Trial
    NoYes
    Free/Freemium Version
    NoNo
    Premium Consulting/Integration Services
    NoYes
    Entry-level Setup FeeOptionalNo setup fee
    Additional Details—Phocas has built its business model on exceeding customer expectations. We’ve operated on a subscription basis from the start and in the words of Phocas Group chairman and co-founder Paul Magee: ‘That puts the onus on us to perform’. And we like that. In fact, our whole company ecosystem is built around that ‘light bulb moment’ when customers achieve a breakthrough by seeing their business through fresh eyes.
    More Pricing Information
    Features
    Actian DataConnectPhocas Business Intelligence
    Data Source Connection
    Comparison of Data Source Connection features of Actian DataConnect and Phocas Business Intelligence
    Feature
    Actian DataConnect
    9.5
    2 Ratings
    13% above category average
    Phocas Business Intelligence
    -
    Ratings
    Connect to traditional data sources9.92 Ratings00 Ratings
    Connecto to Big Data and NoSQL9.01 Ratings00 Ratings
    Data Transformations
    Comparison of Data Transformations features of Actian DataConnect and Phocas Business Intelligence
    Feature
    Actian DataConnect
    9.9
    2 Ratings
    20% above category average
    Phocas Business Intelligence
    -
    Ratings
    Simple transformations10.02 Ratings00 Ratings
    Complex transformations9.92 Ratings00 Ratings
    Data Modeling
    Comparison of Data Modeling features of Actian DataConnect and Phocas Business Intelligence
    Feature
    Actian DataConnect
    9.9
    2 Ratings
    22% above category average
    Phocas Business Intelligence
    -
    Ratings
    Data model creation10.01 Ratings00 Ratings
    Metadata management10.01 Ratings00 Ratings
    Business rules and workflow9.92 Ratings00 Ratings
    Collaboration9.82 Ratings00 Ratings
    Testing and debugging9.92 Ratings00 Ratings
    Data Governance
    Comparison of Data Governance features of Actian DataConnect and Phocas Business Intelligence
    Feature
    Actian DataConnect
    9.5
    1 Ratings
    16% above category average
    Phocas Business Intelligence
    -
    Ratings
    Integration with data quality tools9.01 Ratings00 Ratings
    Integration with MDM tools10.01 Ratings00 Ratings
    BI Standard Reporting
    Comparison of BI Standard Reporting features of Actian DataConnect and Phocas Business Intelligence
    Feature
    Actian DataConnect
    -
    Ratings
    Phocas Business Intelligence
    9.0
    4 Ratings
    10% above category average
    Customizable dashboards00 Ratings9.04 Ratings
    Report Formatting Templates00 Ratings9.04 Ratings
    Ad-hoc Reporting
    Comparison of Ad-hoc Reporting features of Actian DataConnect and Phocas Business Intelligence
    Feature
    Actian DataConnect
    -
    Ratings
    Phocas Business Intelligence
    9.6
    4 Ratings
    18% above category average
    Drill-down analysis00 Ratings10.04 Ratings
    Formatting capabilities00 Ratings9.04 Ratings
    Report sharing and collaboration00 Ratings10.04 Ratings
    Report Output and Scheduling
    Comparison of Report Output and Scheduling features of Actian DataConnect and Phocas Business Intelligence
    Feature
    Actian DataConnect
    -
    Ratings
    Phocas Business Intelligence
    9.3
    4 Ratings
    12% above category average
    Publish to PDF00 Ratings10.04 Ratings
    Report Versioning00 Ratings8.03 Ratings
    Report Delivery Scheduling00 Ratings9.94 Ratings
    Data Discovery and Visualization
    Comparison of Data Discovery and Visualization features of Actian DataConnect and Phocas Business Intelligence
    Feature
    Actian DataConnect
    -
    Ratings
    Phocas Business Intelligence
    8.3
    4 Ratings
    4% above category average
    Pre-built visualization formats (heatmaps, scatter plots etc.)00 Ratings8.04 Ratings
    Location Analytics / Geographic Visualization00 Ratings9.03 Ratings
    Predictive Analytics00 Ratings8.04 Ratings
    Access Control and Security
    Comparison of Access Control and Security features of Actian DataConnect and Phocas Business Intelligence
    Feature
    Actian DataConnect
    -
    Ratings
    Phocas Business Intelligence
    9.9
    4 Ratings
    15% above category average
    Multi-User Support (named login)00 Ratings9.94 Ratings
    Role-Based Security Model00 Ratings9.94 Ratings
    Multiple Access Permission Levels (Create, Read, Delete)00 Ratings9.93 Ratings
    Mobile Capabilities
    Comparison of Mobile Capabilities features of Actian DataConnect and Phocas Business Intelligence
    Feature
    Actian DataConnect
    -
    Ratings
    Phocas Business Intelligence
    9.5
    3 Ratings
    20% above category average
    Responsive Design for Web Access00 Ratings9.03 Ratings
    Dashboard / Report / Visualization Interactivity on Mobile00 Ratings10.03 Ratings
    Best Alternatives
    Actian DataConnectPhocas Business Intelligence
    Small Businesses
    Skyvia
    Score10 out of 10
    Cyfe
    Score4 out of 10
    Medium-sized Companies
    IBM InfoSphere Information Server
    Score10 out of 10
    Qlik Cloud Analytics (Qlik Sense)
    Score8.1 out of 10
    Enterprises
    SolarWinds Task Factory
    Score8.3 out of 10
    Jaspersoft Community Edition
    Score7 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    Actian DataConnectPhocas Business Intelligence
    Likelihood to Recommend
    8.9
    (2 ratings)
    8.1
    (4 ratings)
    Usability
    -
    (0 ratings)
    9.0
    (1 ratings)
    Support Rating
    -
    (0 ratings)
    9.0
    (1 ratings)
    Data Sharing and Collaboration
    -
    (0 ratings)
    8.0
    (3 ratings)
    Data Sources
    -
    (0 ratings)
    10.0
    (3 ratings)
    User Testimonials
    Actian DataConnectPhocas Business Intelligence
    Likelihood to Recommend
    HCLSoftware
    The choice to use Actian DataConnect really comes down to pricing and the type of integration project you are performing, specifically with the requirements, whether you want the integration to be on-premise or in the cloud, can you install agents on your servers etc. For integration tools it runs head to head with its competitors.
    Incentivized
    Read full review
    Phocas
    If you would like your data in one place with easy access, this is the software for you. You can have data from multiple systems and bring it into one view so that you have a quick and easily visible dashboard for the data you wish to see.
    Incentivized
    Read full review
    Pros
    HCLSoftware
    • Map multiple source and destination tables - what would be done in many steps in SSIS can be done in one or two "maps" in Data Integrator.
    • Platform independent, cloud based, no client software.
    • Conversion of data types, write flat files - this helps us with integrating systems.
    • Fairly straightforward to use if the user has ETL experience.
    Incentivized
    Read full review
    Phocas
    • Custom reports are simple to create.
    • The ability to manage users and their dashboards is solid.
    • Easy to navigate web interface makes the software accessible from anywhere.
    Incentivized
    Read full review
    Cons
    HCLSoftware
    • Integration Manager needs better scheduling improvements. Like dependencies, and not running a process again if the prior run is still running.
    • New connector development does not seem a priority.
    Incentivized
    Read full review
    Phocas
    • Phocas needs to make it easier to connect to different types of databases.
    • The data in Phocas needs to be updated faster in some cases.
    • It needs to provide functions to create better charts and graphs.
    Incentivized
    Read full review
    Usability
    HCLSoftware
    No answers on this topic
    Phocas
    It is a very user-friendly product and is easy to understand. You can get your data from just a quick click and the dashboard loads. You can take the data and drill down easy to find what you are looking for.
    Incentivized
    Read full review
    Support Rating
    HCLSoftware
    No answers on this topic
    Phocas
    Support is responsive. You log a call and they will respond quickly and resolve your issues. We have only had great experiences with the support team.
    Incentivized
    Read full review
    Alternatives Considered
    HCLSoftware
    Data Integrator was initially a part of a package deal for us with our new Student Information System. It was chosen prior to my arrival at the institution. Since I discovered we have SQL Server licenses, we have decided to use SSIS instead since I have a background in the MSBI stack and SSIS appears to be more straightforward (process flow philosophy vs "map" philosophy.)
    Incentivized
    Read full review
    Phocas
    Phocas is easy to use for end users and can be used on desktops, laptops, and phones.
    Incentivized
    Read full review
    Return on Investment
    HCLSoftware
    • Our customer likes the consistent reliable integrations we have built so we [got] a definite return on investment.
    • Problems are fairly easy to handle and rework.
    Incentivized
    Read full review
    Phocas
    • It has given our business a view on data
    • We can access it from anywhere
    • You can have multiple dashboards for different information
    Incentivized
    Read full review
    ScreenShots

    Actian DataConnect Screenshots

    Screenshot of DataConnect is a hybrid integration solution used to design, deploy, and manage integrations on premise, in the cloud or in hybrid environments with no limits on data types or volumes.Screenshot of Actian DataConnect is a versatile hybrid integration platform that supports a wide range of use cases in every industry.Screenshot of DataConnect helps service delivery teams (e.g. SaaS ProServ team, Systems Integrator) rapidly  onboard and maintain application integrations across their customer base.Screenshot of DataConnect helps organizations onboard master data from their customers as part of the customer onboarding and maintenance process.Screenshot of DataConnect helps an enterprise or service provider exchange EDI data with their supply chain, customer network, or partner network.Screenshot of Actian DataConnect

    Phocas Business Intelligence Screenshots

    Screenshot of Phocas Dashboard on iPadScreenshot of Phocas Dashboard on Laptop