CData Software - Knowledge Base

Recent Articles

• «
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• »

• Connect to Act CRM in Aqua Data Studio

  Access Act CRM from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Connect to Oracle Eloqua in Google Apps Script

  Use the ODBC Driver for Oracle Eloqua and the SQL Gateway to access Oracle Eloqua from Google Apps Script.

• Create SSAS Tabular Models from MongoDB

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

• Back Up Outreach.io to SQL Server through SSIS

  Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Outreach.io. In this article, we will employ an SSIS workflow to populate a database with Outreach.io data.

• Publish Crystal Reports on SAP Ariba Procurement

  Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SAP Ariba Procurement.

• How to Create Power BI Visual Reports with Real-Time Smartsheet

  Use CData Power BI Connectors to visualize Smartsheet in Power BI.

• Natively Connect to Zoho Books in PHP

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

• Connect to Sage 300 in Ruby

  Connect to Sage 300 in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Connect to YouTube Analytics in RunMyProcess through Connect Cloud

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

• Use the CData Software ODBC Driver for CSV in SAS for Real-Time Reporting and Analytics

  Connect to real-time CSV/TSV Files in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for CSV.

• Connect to Microsoft Project in Google Apps Script

  Use CData Connect Cloud to access Microsoft Project in Google Apps Script.

• Integrate Sybase into Automated Tasks with Power Automate

  Use CData Software Connect Server to create a virtual SQL Server database for Sybase and integrate live Sybase into your Power Automate (Microsoft Flow) tasks.

• Connect to ActiveCampaign in DBeaver

  Use the CData ODBC Driver to connect to ActiveCampaign in DBeaver.

• Connect to Cassandra from AWS Glue

  Use CData Connect Cloud to gain access to live Apache Cassandra from your AWS Glue jobs.

• Import MySQL Using Azure Data Factory

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

• Establish a Live Connection with Asana using Tableau Bridge

  The CData ODBC Driver for Asana enables you to integrate live Asana into Tableau Cloud dashboards using the Tableau Bridge.

• Working with Sybase IQ in LINQPad

  Execute LINQ queries to Sybase IQ in LINQPad.

• How to import SingleStore into Apache Solr

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

• Create Wave Financial Dashboards in Bold BI

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

• Connect to Google Calendar from PowerBuilder

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

• Build Amazon Marketplace-Connected Apps in Mendix

  Use CData Connect Cloud to create an OData feed for Amazon Marketplace and create custom apps in Mendix.

• Enable the HCL Domino JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with HCL Domino.

• Connect to Couchbase in Google Apps Script

  Use the ODBC Driver for Couchbase and the SQL Gateway to access Couchbase from Google Apps Script.

• Create Slack-Connected Business Apps in AppSheet

  Connect to Slack via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Slack.

• How to Visualize SAP ByDesign Data in Python with pandas

  Use pandas and other modules to analyze and visualize live SAP Business ByDesign in Python.

• Build Visualizations of Cosmos DB in Birst

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

• Create XML-Connected Nintex Workflows

  Use CData Software Connect Server to connect to XML from Nintex Workflow Cloud and build custom workflows using live XML Files.

• Automated Continuous Bing Search Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable Bing Search replication to IBM DB2.

• Load Microsoft Exchange to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft Exchange to a database.

• Connect to TigerGraph from PowerBuilder

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

• Load MYOB AccountRight to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load MYOB AccountRight to a database.

• Automated Continuous Reckon Replication to Snowflake

  Use CData Sync for automated, continuous, customizable Reckon replication to Snowflake.

• Connect to Active Directory in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for Active Directory in Airbyte.

• How to use SQLAlchemy ORM to access Certinia in Python

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

• Visualize eBay Analytics in TIBCO Spotfire through ODBC

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

• Replicate Redis to Multiple Databases

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

• How to import Bing Ads into Apache Solr

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

• Integrate with Cosmos DB in JReport Designer

  Create charts and reports based on Azure Cosmos DB in JReport Designer.

• Visualize Printful in TIBCO Spotfire through ADO.NET

  Integrate Printful into dashboards in TIBCO Spotfire.

• Replicate Active Directory to Multiple Databases

  Replicate Active Directory to disparate databases with a single configuration.

• A PostgreSQL Interface for Sybase

  Use the Remoting features of the Sybase JDBC Driver to create a PostgreSQL entry-point for data access.

• Integrate with Live OData Services in MuleSoft (via CData Connect Cloud)

  Use CData Connect Cloud to connect to OData from the MuleSoft Anypoint Platform to integrate live OData into custom reports and dashboards.

• Create Exact Online-Connected Enterprise Applications in OutSystems

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

• Import SAP BusinessObjects BI into the Power BI Service for Visualizations

  Use CData Software Connect Server to create an OData feed for SAP BusinessObjects BI and create custom reports in the Power BI Service.

• Create Data Visualizations Based On Zuora in Mode

  Use CData Connect Cloud to connect to Zuora from Mode and build visualizations using live

• How to Connect to & Open HCL Domino in Microsoft Excel

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

• Integrate Live FTP into Custom Business Apps Built in Power Apps

  Use CData Software Connect Server to create a virtual SQL Server Database for FTP Servers and integrate live FTP Servers into apps built in Microsoft Power Apps.

• Use the CData ODBC Driver for MailChimp in SAS JMP

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

• How to Connect the Power BI Service to SAP HANA: Complete Guide

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

• Query eBay as a SQL Server Database in Node.js

  Execute SQL Server queries against eBay from Node.js.

• Use JayDeBeApi to access Typeform in Python

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

• Connect to Veeva in SpagoBI

  Create reports featuring live Veeva Vault in SpagoBI Studio. Host Veeva reports on SpagoBI Server.

• Automated Continuous Sybase IQ Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable Sybase IQ replication to Amazon Redshift.

• Connect to Google Directory from a Connection Pool in JBoss

  Integrate Google Directory into Java servlets: Use the Management Console in JBoss to install the Google Directory JDBC Driver.

• How to connect PolyBase to Greenplum

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

• Use JayDeBeApi to access Act CRM in Python

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

• How to connect to Dropbox from IntelliJ

  Integrate connectivity to Dropbox with wizards in IntelliJ.

• Connect to ActiveCampaign from HeidiSQL

  Use CData Connect Cloud to connect to and query live ActiveCampaign from HeidiSQL.

• Author and Share Power BI Reports on Real-Time Azure Analysis Services

  Use the CData ODBC Driver for Azure Analysis Services to visualize Azure Analysis Services in Power BI Desktop and then upload to the Power BI service.

• Replicate Dynamics GP for Use in Salesforce Connect

  Replicate Microsoft Dynamics GP to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Build a Simple VCL Application for HubSpot

  How to build a simple VCL Application to view HubSpot in RAD Studio using the CData ODBC Driver for HubSpot.

• Analyze Zendesk in Looker

  Use CData Connect Cloud to connect to Zendesk from Looker and build custom apps using live Zendesk.

• Query, Visualize, and Share live Salesforce Pardot in Redash

  Use CData Connect Cloud to connect to live Salesforce Pardot in Redash for querying, visualizing, and sharing.

• How to Connect to & Open MYOB AccountRight in Microsoft Excel

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

• Connect to Instagram as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live Instagram.

• Visualize CSV in Tableau Desktop (through CData Connect)

  Create a virtual SQL Server database for CSV/TSV Files in CData Software Connect (or Connect Server) and build visualizations from live CSV/TSV Files in Tableau Desktop.

• Connect to Avro in as an External Source in Dremio

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

• How to use SQLAlchemy ORM to access DocuSign in Python

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

• Working with OData Services in LINQPad

  Execute LINQ queries to OData in LINQPad.

• Automated Continuous Tableau CRM Analytics Replication to MongoDB

  Use CData Sync for automated, continuous, customizable Tableau CRM Analytics replication to MongoDB.

• Access MongoDB in Mule Applications Using the CData JDBC Driver

  Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for MongoDB.

• Automate EnterpriseDB Replication to Azure Data Lake

  Use CData Sync to customize and automate EnterpriseDB replication to Azure Data Lake.

• Connect to Oracle in JRuby

  Create a simple JRuby app with access to live Oracle Database.

• Using the CData Software ODBC Driver for Microsoft Dataverse in PyCharm

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

• Build Dynamics 365-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Microsoft Dynamics 365.

• Use the CData Software ODBC Driver for CSV in MicroStrategy

  Connect to CSV/TSV Files in MicroStrategy Developer using the CData Software ODBC Driver for CSV.

• Connect to Databricks from a Connection Pool in Jetty

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

• Automate Databricks Replication to Azure Data Lake

  Use CData Sync to customize and automate Databricks replication to Azure Data Lake.

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

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

• Build Pipelines with Live SharePoint in Google Cloud Data Fusion (via CData Connect Cloud)

  Use CData Connect Cloud to connect to SharePoint from Google Cloud Data Fusion, enabling the integration of live Microsoft SharePoint into the building and management of effective data pipelines.

• Integrate with live Azure DevOps in Jitterbit

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

• Stream Amazon Athena into Apache Kafka Topics

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

• Connect to Basecamp from PowerBuilder

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

• Publish QuickBooks Online-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live QuickBooks Online.

• Build an OLAP Cube in SSAS from Sage Intacct

  Establish a connection to Sage Intacct data from SQL Server Analysis Services, and use the Sage Intacct Data Provider to build OLAP cubes for use in analytics and reporting.

• Connect to Pinterest from a Connection Pool in WebLogic

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

• Visualize Oracle Sales in TIBCO Spotfire through ADO.NET

  Integrate Oracle Sales into dashboards in TIBCO Spotfire.

• PowerShell Scripting to Replicate Impala to MySQL

  Write a simple PowerShell script to replicate Apache Impala to a MySQL database.

• Access Live Email in AWS Lambda

  Connect to live Email in AWS Lambda using the CData JDBC Driver.

• Back Up Sybase to SQL Server through SSIS

  Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Sybase. In this article, we will employ an SSIS workflow to populate a database with Sybase data.

• Build OData-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live OData.

• Connect to SAP Business One from a Connection Pool in Jetty

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

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

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

• How to connect PolyBase to Power BI XMLA

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Power BI XMLA.

• How to connect to SurveyMonkey from IntelliJ

  Integrate connectivity to SurveyMonkey with wizards in IntelliJ.

• Automated MySQL Replication to Teradata

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

• Connect to MYOB AccountRight in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for MYOB AccountRight in Airbyte.

• Connect to ShipStation in Google Apps Script

  Use the ODBC Driver for ShipStation and the SQL Gateway to access ShipStation from Google Apps Script.

• Connect to and Query ClickUp in QlikView over ODBC

  Create data visualizations with ClickUp in QlikView.

• Automated Continuous Dynamics 365 Replication to Apache Cassandra

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

• «
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• »