CData Software - Knowledge Base

Recent Articles

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

• Extract, Transform, and Load Act-On in Informatica PowerCenter

  Create a simple Workflow for Act-On in Informatica PowerCenter.

• Creating Dynamics NAV-Connected Applications in Unqork

  You can use CData Connect to feed Microsoft Dynamics NAV to Unqork and build custom business apps.

• Feed Shippo into FineReport

  How to set Shippo as a JDBC data source in FineReport.

• Analyze Live Google Contacts in SAS Viya

  Use CData Connect Cloud to connect to Google Contacts from SAS Viya and deploy self-service analytics using live Google Contacts.

• Integrate with live Twitter in Jitterbit

  Use CData Connect Cloud to connect to and integrate live Twitter in Jitterbit.

• Integrate Amazon S3 into Power Automate Desktop using CData Connect

  CData Connect for Amazon S3 enables you to integrate Amazon S3 into workflows built using Microsoft Power Automate Desktop.

• Visualize Google Cloud Storage from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Google Cloud Storage.

• Build Dashboards with Instagram in Dundas BI

  Create dynamic dashboards and perform analytics based on Instagram in Dundas BI.

• Viewing Odoo in RAD Studio Data Explorer

  How to view Odoo ERP in RAD Studio Data Explorer using the CData ODBC Driver for Odoo.

• How to Connect to & Open NetSuite in Microsoft Excel

  This article uses the CData ODBC driver for NetSuite to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• Connect to Dynamics CRM in DBeaver

  Use the CData ODBC Driver to connect to Microsoft Dynamics CRM in DBeaver.

• Connect to Unbounce from PowerBuilder

  This article demonstrates how to access Unbounce from Appeon PowerBuilder using the CData ADO.NET Provider for Unbounce.

• Use CData Connect Cloud to Access Splunk in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live Splunk in the Power Pivot business intelligence tool.

• Visualize Power BI XMLA in TIBCO Spotfire through ODBC

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

• Rapidly Develop TaxJar-Driven Apps with Active Query Builder

  Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.

• How to use SQLAlchemy ORM to access QuickBooks Online in Python

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

• Automated Continuous CSV Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable CSV replication to Apache Kafka.

• Use JayDeBeApi to access CouchDB in Python

  Use standard Python scripting and the development environment of your choice to access live Apache CouchDB.

• Using the CData Software ODBC Driver for Jira in PyCharm

  Connect to Jira as an ODBC data source in PyCharm using the CData Software ODBC Driver for Jira.

• Automated Microsoft Dataverse Replication to Teradata

  Use CData Sync to Customize and automate Microsoft Dataverse (CDS) replication to Teradata.

• Automated Continuous CockroachDB Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable CockroachDB replication to Google Cloud SQL.

• Automated BigCommerce Replication to Teradata

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

• Connect to Excel Online in Jaspersoft Studio

  Execute SQL to remote Microsoft Excel Online in Jaspersoft Studio.

• How to connect and process Microsoft Exchange from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Microsoft Exchange

• Import SAP ByDesign into the Power BI Service for Visualizations

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

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

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

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

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

• Connect to Sugar CRM in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for Sugar CRM in Airbyte.

• Design BIRT Reports on WordPress

  Provide current WordPress to your embedded analytics.

• Create Reports with Google Campaign Manager 360 in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Google Campaign Manager 360.

• Automated SurveyMonkey Replication to Teradata

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

• Access IBM Cloud Data Engine in PHP through Connect Server

  Connect to IBM Cloud Data Engine through the standard SQL Server libraries in PHP.

• How to Work with LinkedIn in AWS Glue Jobs Using JDBC

  Connect to LinkedIn from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Import and Visualize Amazon S3 in Power View

  Create data visualizations based on Amazon S3 in Excel.

• How to publish and share Google Contacts dashboards with Tableau Server

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

• Create a Data Access Object for Cvent using JDBI

  A brief overview of creating a SQL Object API for Cvent in JDBI.

• Prepare, Blend, and Analyze Clio in Alteryx Designer

  Build workflows to access live Clio for self-service data analytics.

• Create SSAS Tabular Models from Sybase IQ

  How to build a SQL Server Analysis Service Tabular Model from Sybase IQ using CData drivers.

• Analyze Microsoft Dataverse in Looker

  Use CData Connect Cloud to connect to Microsoft Dataverse from Looker and build custom apps using live Microsoft Dataverse (CDS).

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

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

• Use JayDeBeApi to access Drift in Python

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

• Build Visualizations of Azure Data Catalog in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Azure Data Catalog in Birst.

• Connect to Oracle Financials Cloud in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Oracle Financials Cloud in the Denodo Virtual DataPort Administrator.

• Access SharePoint as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Microsoft SharePoint from your Oracle system.

• Connect to Live Printful in MicroStrategy through CData Software Connect Server

  Create a virtual database for Printful in CData Software Connect Server and connect to it from MicroStrategy.

• Create Asana-Connected Enterprise Applications in OutSystems

  Use CData Connect Cloud to connect to Asana from OutSystems and build custom enterprise apps using live Asana.

• How to integrate SAP BusinessObjects BI with Apache Airflow

  Access and process SAP BusinessObjects BI in Apache Airflow using the CData JDBC Driver.

• Stream Aha into Apache Kafka Topics

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

• Integrate OData Services in the Pentaho Report Designer

  Publish reports based on OData in the Pentaho BI tool.

• PowerShell Scripting to Replicate Aha to MySQL

  Write a simple PowerShell script to replicate Aha! to a MySQL database.

• Automated Continuous Sybase IQ Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable Sybase IQ replication to Google BigQuery.

• Automated Klipfolio Replication to Teradata

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

• How to create Visio diagrams from Greenplum

  Automatically update Pivotal GreenPlum with the changes you make to Visio master shapes.

• How to Access Excel Online Using Entity Framework

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

• How to connect PolyBase to Dynamics 365

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Microsoft Dynamics 365.

• How to Connect the Power BI Service to Dynamics CRM: Complete Guide

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

• How to Build Dynamic React Apps with Avalara AvaTax

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

• Use the CData Software ODBC Driver for HarperDB in MicroStrategy Desktop

  Connect to HarperDB in MicroStrategy Desktop using the CData Software ODBC Driver for HarperDB.

• Connect to MYOB AccountRight in RunMyProcess through Connect Cloud

  Use CData Connect Cloud to create on OData API for MYOB AccountRight and connect to MYOB AccountRight in Akorbi Digital RunMyProcess.

• Enable the Cloudant JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with IBM Cloudant.

• Connect to Salesforce from a Connection Pool in JBoss

  Integrate Salesforce & Force.com into Java servlets: Use the Management Console in JBoss to install the Salesforce JDBC Driver.

• How to connect to JDBC-ODBC Bridge from IntelliJ

  Integrate connectivity to JDBC-ODBC Bridge with wizards in IntelliJ.

• Connect to SAP Fieldglass from a Connection Pool in Jetty

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

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

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

• Replicate Parquet to Multiple Databases

  Replicate Apache Parquet to disparate databases with a point-and-click configuration.

• Visualize Live Adobe Analytics in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Adobe Analytics.

• Connect to Google Calendar in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Google Calendar in the Denodo Virtual DataPort Administrator.

• Replicate Multiple Oracle Service Cloud Accounts

  Replicate multiple Oracle Service Cloud accounts to one or many databases.

• Publish LDAP-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live LDAP.

• Visualize Live HCL Domino of Power BI Report Builder in Power BI Service

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

• Use the CData ODBC Driver for Spark in Microsoft Power Query

  You can use the CData Spark ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Apache Spark SQL into Microsoft Power Query.

• How to Visualize Oracle Service Cloud Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Oracle Service Cloud in Python.

• How to Connect to & Open Clio in Microsoft Excel

  This article uses the CData ODBC driver for Clio to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• A PostgreSQL Interface for Sage Cloud Accounting

  Use the Remoting features of the Sage Cloud Accounting ODBC Driver to create a PostgreSQL entry-point for data access.

• How to connect to CouchDB from Spring Boot

  Connect to CouchDB in a Spring Boot Application using CData JDBC CouchDB Driver

• Use the CData Software JDBC Driver for Act-On in MicroStrategy

  Connect to Act-On in MicroStrategy Developer using the CData Software JDBC Driver for Act-On.

• Import Shippo into Microsoft Power Query

  The CData Software Connect Server offers standards-based Web service endpoints that allow a variety of applications to access Shippo. In this article, you will use the OData format to import Shippo into Microsoft Power Query.

• Analyze Dynamics 365 in Looker

  Use CData Connect Cloud to connect to Dynamics 365 from Looker and build custom apps using live Microsoft Dynamics 365.

• Import Salesforce Pardot Using Azure Data Factory

  Use CData Connect Cloud to connect to Salesforce Pardot from Azure Data Factory and import live Salesforce Pardot.

• Export Data from SQL Server to Exact Online through SSIS

  Easily push SQL Server data to Exact Online using the CData SSIS Tasks for Exact Online.

• Process & Analyze Highrise in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Highrise .

• How to Connect DBeaver to Google Spanner via a JDBC Driver

  Manage Google Spanner with visual tools in DBeaver like the query browser.

• Spark Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Apache Spark SQL through CData Connect Cloud using different applications and tools.

• How to work with Asana in Apache Spark using SQL

  Access and process Asana in Apache Spark using the CData Software JDBC Driver.

• Create Datasets from DB2 in Domo Workbench and Build Visualizations of DB2 in Domo

  Use the CData Software ODBC Driver for DB2 to create datasets from IBM DB2 in Domo Workbench and then build visualizations in the Domo service.

• Automate Dynamics NAV Replication to Azure Synapse

  Use CData Sync to customize and automate Microsoft Dynamics NAV replication to Azure Synapse.

• A PostgreSQL Interface for TigerGraph

  Use the SQL Gateway and TigerGraph ODBC Driver to create a PostgreSQL entry-point for data access.

• Perform Batch Operations with SendGrid in Apache NiFi

  Connect to SendGrid and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Automated Continuous Cosmos DB Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable Cosmos DB replication to Google Cloud SQL.

• Use CData Connect Cloud to Access Smartsheet in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live Smartsheet in the Power Pivot business intelligence tool.

• Analyze Live Blackbaud FE NXT in SAS Viya

  Use CData Connect Cloud to connect to Blackbaud FE NXT from SAS Viya and deploy self-service analytics using live Blackbaud FE NXT.

• How to create Visio diagrams from HubDB

  Automatically update HubDB with the changes you make to Visio master shapes.

• Stream Klipfolio into Apache Kafka Topics

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

• How to Access Live Invoiced in Power Automate Desktop via ODBC

  The CData ODBC Driver for Invoiced enables you to integrate Invoiced into workflows built using Microsoft Power Automate Desktop.

• SQL Analysis Services Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on SQL Analysis Services facts in real time.

• Replicate Google Contacts from PowerShell

  Write a quick PowerShell script to query Google Contacts. Use connectivity to the live data to replicate Google Contacts to SQL Server.

• Import Google Cloud Storage into FileMaker Pro

  Create reports that integrate Google Cloud Storage in Filemaker Pro.

• Connect to Power BI XMLA in Ruby

  Connect to Power BI XMLA in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• How to connect PolyBase to Adobe Commerce

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

• Connect to Coinbase in as an External Source in Dremio

  Use the CData JDBC Driver to connect to Coinbase as an External Source in Dremio.

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