CData Software - Knowledge Base

Recent Articles

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• »

• Visualize Sage 50 UK in Sisense

  Create an ElastiCube in Sisense app with access to Sage 50 UK.

• Publish Reports with Square in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Square.

• Integrate with Azure Analysis Services in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live Azure Analysis Services in SnapLogic.

• Build MVC Applications with Connectivity to Microsoft Project

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Microsoft Project from an ASP.NET MVC application.

• Import and Visualize Oracle Eloqua in Power View

  Create data visualizations based on Oracle Eloqua in Excel.

• Feed Outreach.io into FineReport

  How to set Outreach.io as a JDBC data source in FineReport.

• Connect to Facebook from PowerBuilder

  This article demonstrates how to access Facebook from PowerBuilder using the Facebook JDBC Driver.

• How to Access Azure Data Catalog Using Entity Framework

  This article shows how to access Azure Data Catalog using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• Replicate SAP SuccessFactors to Multiple Databases

  Replicate SAP SuccessFactors to disparate databases with a point-and-click configuration.

• How to Connect DBeaver to NetSuite via a JDBC Driver

  Manage NetSuite CRM & ERP with visual tools in DBeaver like the query browser.

• Connect to Microsoft Exchange in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Create Informatica Mappings From/To a JDBC Data Source for Square

  Create Square data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Integrate with live Microsoft Dataverse in Jitterbit

  Use CData Connect Cloud to connect to and integrate live Microsoft Dataverse (CDS) in Jitterbit.

• Analyze Snowflake in Cognos Analytics

  Use CData Connect Cloud to connect to Snowflake from Cognos Analytics and analyze live Snowflake.

• Configure the CData JDBC Driver for Azure Data Lake Storage in a Connection Pool in Tomcat

  Connect to Azure Data Lake Storage from a connection pool in Tomcat.

• How to create an RPA flow for TigerGraph in UiPath Studio

  Use the TigerGraph ODBC Driver to create workflows that access real-time TigerGraph without any coding.

• Create Informatica Mappings From/To an ODBC Data Source for MongoDB

  Create an ODBC connection to MongoDB in Informatica and browse and transfer MongoDB.

• Connect to SAP Hybris C4C in DBeaver

  Use the CData ODBC Driver to connect to SAP Hybris C4C in DBeaver.

• Import PayPal into the Power BI Service for Visualizations

  Use CData Connect Cloud to connect to PayPal and provide access to live PayPal for custom reports in the Power BI Service.

• Use the CData Software JDBC Driver for Salesforce Pardot in MicroStrategy

  Connect to Salesforce Pardot in MicroStrategy Developer using the CData Software JDBC Driver for Salesforce Pardot.

• Connect to Cloudant through External Services in Salesforce

  Use CData Connect Cloud to securely provide OData feeds of IBM Cloudant to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Cloudant objects that you can access from apps and the dashboard.

• Build Presto-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to Presto from Zoho Analytics and import live Presto.

• Visualize Live GraphQL of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live GraphQL using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• Connect to Cloudant from a Connection Pool in Jetty

  The Cloudant JDBC Driver supports connection pooling: This article shows how to connect faster to IBM Cloudant from Web apps in Jetty.

• Use JayDeBeApi to access LinkedIn Ads in Python

  Use standard Python scripting and the development environment of your choice to access live LinkedIn Ads.

• Microsoft Teams Reporting in OBIEE with the Microsoft Teams JDBC Driver

  Deploy the Microsoft Teams JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Stream Stripe into Apache Kafka Topics

  Access and stream Stripe in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Import and Visualize SAP in Power View

  Create data visualizations based on SAP ERP/NetWeaver in Excel.

• Automate Email Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access Email from PowerShell? This article demonstrates how to utilize the Email Cmdlets for tasks like connecting to Email, automating operations, downloading data, and more.

• Amazon Athena Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Amazon Athena facts in real time.

• Creating Monday.com-Connected Applications in Unqork

  You can use CData Connect Cloud to feed Monday.com to Unqork and build custom business apps.

• Visualize BigCommerce in TIBCO Spotfire through ODBC

  The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load BigCommerce into TIBCO Spotfire.

• Using AngularJS to Build Dynamic Web Pages with SFTP

  Use the CData Connect Server to create SFTP OData feeds and build single-page applications with live SFTP.

• Connect to Cassandra through External Services in Salesforce

  Use CData Connect Cloud to securely provide OData feeds of Apache Cassandra to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Cassandra objects that you can access from apps and the dashboard.

• Connect to Box from PowerBuilder

  This article demonstrates how to use the CData ODBC Driver for Box to connect to Box and execute queries in PowerBuilder.

• Design BIRT Reports on Quickbase

  Provide current Quickbase to your embedded analytics.

• Explore Geographical Relationships in Greenplum with Power Map

  Create data visualizations with Pivotal GreenPlum in Power Map.

• How to Connect the Power BI Service to HarperDB: Complete Guide

  Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.

• Access Live SAP ByDesign in TIBCO Data Virtualization

  Use the CData Software TIBCO DV Adapter for SAP ByDesign to create a SAP Business ByDesign source in TIBCO Data Virtualization Studio and gain access to live SAP Business ByDesign from your TDV Server.

• Use the CData Software JDBC Driver for Phoenix in MicroStrategy Web

  Connect to Apache Phoenix in MicroStrategy Web using the CData Software JDBC Driver for Phoenix.

• Replicate Redshift to Multiple Databases

  Replicate Amazon Redshift to disparate databases with a single configuration.

• View Reports on Real-Time TigerGraph in Power BI Report Server

  Use the CData ODBC Driver for TigerGraph to visualize TigerGraph in Power BI Desktop and then publish them to Power BI Report Server.

• Publish SAP SuccessFactors-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live SAP SuccessFactors.

• Automated Continuous Salesforce Pardot Replication to SingleStore

  Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to SingleStore.

• Use the CData SSIS Components to Insert New or Update Existing Microsoft Project Records from SQL Server

  Easily push SQL Server data to Microsoft Project using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Microsoft Project or update existing records with data from a SQL Server database.

• How to Use a Microsoft Access Database to Update Hive in Real Time

  Update Hive data by creating a linked table in Microsoft Access with the CData Hive ODBC Driver.

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for ShipStation

  Provide connectivity to ShipStation through an SAP BusinessObjects universe.

• Query ShipStation through ODBC in Node.js

  Use node-odbc to execute SQL queries against ShipStation from Node.js.

• Integrate with Jira Service Management in JReport Designer

  Create charts and reports based on Atlassian Jira Service Management in JReport Designer.

• Connect to Zoho Creator from Crystal Reports

  Use CData Connect Cloud to connect to and report on live Zoho Creator from Crystal Reports.

• How to connect to CockroachDB from IntelliJ

  Integrate connectivity to CockroachDB with wizards in IntelliJ.

• Validate Splunk with QuerySurge

  Access and validate Splunk in QuerySurge using the CData JDBC Driver.

• How to pipe Snowflake to CSV in PowerShell

  Use standard PowerShell cmdlets to access Snowflake tables.

• Automated Continuous Drift Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable Drift replication to Apache Cassandra.

• Connect to and Query Monday.com in QlikView over ODBC

  Create data visualizations with Monday.com in QlikView.

• Integrate Real-Time Access to Amazon Athena in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Amazon Athena in real time.

• Natively Connect to Veeva in PHP

  The CData ODBC driver for Veeva enables you to create PHP applications with connectivity to Veeva Vault. Leverage the native support for ODBC in PHP.

• Query Salesloft as a SQL Server in Node.js

  Execute SQL Server queries against Salesloft from Node.js.

• Query Sage 200 as a SQL Server Database in Node.js

  Execute SQL Server queries against Sage 200 from Node.js.

• How to publish and share Smartsheet dashboards with Tableau Server

  The CData ODBC driver for Smartsheet enables you integrate Smartsheet into Tableau dashboards.

• Connect to SAP ByDesign from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live SAP Business ByDesign from Filemaker Pro on Mac.

• Connect to Box in DBArtisan

  Use wizards in DBArtisan to configure Box as a data source.

• DataBind Wijmo Grid to SAP

  Provide real-time SAP ERP/NetWeaver to interactive controls.

• How to import Clio into Apache Solr

  Use the CData Software JDBC Driver for Clio in Data Import Handler and create an automated import of Clio to Apache Solr Enterprise Search platform.

• Create Dynamics GP Dashboards in Bold BI

  Use CData Software Connect Server to create a virtual SQL Server Database for Microsoft Dynamics GP to build custom dashboards in Bold BI.

• Integrate Greenplum in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Pivotal GreenPlum from Informatica Cloud.

• Replicate SharePoint Excel Services to Multiple Databases

  Replicate SharePoint Excel Services to disparate databases with a point-and-click configuration.

• How to use SQLAlchemy ORM to access EnterpriseDB in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of EnterpriseDB.

• Visualize Avro in TIBCO Spotfire through OData

  Integrate Apache Avro into dashboards in TIBCO Spotfire.

• Import SAP Hybris C4C into FileMaker Pro

  Create reports that integrate SAP Hybris C4C in Filemaker Pro.

• Use the CData ODBC Driver for Confluence in SAS JMP

  You can use the CData ODBC Driver to integrate Atlassian Confluence into the statistical analysis tools available in SAS JMP. This article shows how to use Atlassian Confluence in the Graph Builder and Query Builder.

• How to connect PolyBase to QuickBooks Online

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live QuickBooks Online.

• Provide OData Services of SAP ByDesign from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for SAP Business ByDesign by developing a WCF Service Application.

• Replicate Multiple Printful Accounts

  Replicate multiple Printful accounts to one or many databases.

• Create SAS Data Sets Dashboards in Bold BI

  Use CData Software Connect Server to create a virtual SQL Server Database for SAS Data Sets to build custom dashboards in Bold BI.

• Build Kintone-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Kintone.

• Automated Continuous Google Spanner Replication to Azure SQL

  Use CData Sync for automated, continuous, customizable Google Spanner replication to Azure SQL.

• Connect to Redis in HULFT Integrate

  Connect to Redis as a JDBC data source in HULFT Integrate

• Automate IBM Cloud Object Storage Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access IBM Cloud Object Storage from PowerShell? This article demonstrates how to utilize the IBM Cloud Object Storage Cmdlets for tasks like connecting to IBM Cloud Object Storage, automating operations, downloading data, and more.

• How to Build Dynamic React Apps with Jira

  Use the CData Connect and React to Build Dynamic Web Apps with Live Jira .

• How to Work with Sybase in ETL Validator JDBC

  Connect to Sybase from ETL Validator jobs using the CData Software JDBC Driver.

• Bridge Dynamics 365 Connectivity with Apache NiFi

  Access and process Microsoft Dynamics 365 in Apache NiFi using the CData JDBC Driver.

• Connect to and Query WordPress in QlikView over ODBC

  Create data visualizations with WordPress in QlikView.

• Access Cvent from MySQL in PHP

  Connect to Cvent through the standard MySQL libraries in PHP.

• Connect to Databricks from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Databricks to connect to Databricks from Web applications running on WebLogic.

• Use the CData ODBC Driver for Typeform from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC Driver for Typeform to connect to Typeform from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Typeform in Excel.

• Author and Share Power BI Reports on Real-Time EventBrite

  Use the CData ODBC Driver for EventBrite to visualize Eventbrite in Power BI Desktop and then upload to the Power BI service.

• Import Real-Time Zoho Books in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Zoho Books in ColdFusion.

• Access Live Impala in Coginiti Pro

  Connect to and query live Apache Impala from the GUI in the Coginiti Pro: SQL Analytics Tool.

• How to Access OneNote Using Entity Framework

  This article shows how to access Microsoft OneNote using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• Automate Sybase Replication to Couchbase

  Use CData Sync to Customize and automate Sybase replication to Couchbase.

• Build MVC Applications with Connectivity to Spark

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Spark from an ASP.NET MVC application.

• Publish Amazon S3-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Amazon S3.

• Create SAP Fieldglass Dashboards in Bold BI

  Use CData Software Connect Server to create a virtual SQL Server Database for SAP Fieldglass to build custom dashboards in Bold BI.

• Process & Analyze IBM Cloud Object Storage in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live IBM Cloud Object Storage .

• Visualize Todoist in TIBCO Spotfire through OData

  Integrate Todoist into dashboards in TIBCO Spotfire.

• How to Connect to Elasticsearch in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Elasticsearch. Leverage the pyodbc module for ODBC in Python.

• How to publish and share Shippo dashboards with Tableau Server

  The CData ODBC driver for Shippo enables you integrate Shippo into Tableau dashboards.

• Automated Salesloft Replication to Teradata

  Use CData Sync to Customize and automate Salesloft replication to Teradata.

• Load Azure Analysis Services to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Azure Analysis Services to a database.

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• »