Discover how a bimodal integration strategy can address the major data management challenges facing your organization today.
Get the Report →CData Software - Knowledge Base
Recent Articles
-
Automate MarkLogic Integration Tasks from PowerShell
Are you in search of a quick and easy way to access MarkLogic from PowerShell? This article demonstrates how to utilize the MarkLogic Cmdlets for tasks like connecting to MarkLogic, automating operations, downloading data, and more.
-
Connect to ADP through External Services in Salesforce
Use CData Connect Cloud to securely provide OData feeds of ADP to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create ADP objects that you can access from apps and the dashboard.
-
How to import Snapchat Ads into Apache Solr
Use the CData Software JDBC Driver for Snapchat Ads in Data Import Handler and create an automated import of Snapchat Ads to Apache Solr Enterprise Search platform.
-
Visualize Live RSS Feeds in the Power BI Service
Use CData Software Connect Server to create a virtual SQL Server database for RSS Feeds and create custom reports in the Power BI Service.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Xero
Provide connectivity to Xero Accounting through an SAP BusinessObjects universe.
-
Natively Connect to Jira Assets in PHP
Create PHP applications on Linux/UNIX machines with connectivity to Jira Assets. Leverage the native support for ODBC in PHP.
-
Query Azure Data Lake Storage as a SQL Server Database in Node.js
Execute SQL Server queries against Azure Data Lake Storage from Node.js.
-
DataBind Controls to Impala in Delphi
DataBind to Apache Impala in Delphi with standard data access components and controls.
-
Import Dynamics NAV into the Power BI Service for Visualizations
Use CData Software Connect Server to create an OData feed for Dynamics NAV and create custom reports in the Power BI Service.
-
Connect to Power BI XMLA in RapidMiner
Integrate Power BI XMLA with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to BambooHR in RazorSQL
Connect to BambooHR from wizards and query BambooHR from the GUI in the RazorSQL database management tool.
-
Automated Continuous LDAP Replication to SingleStore
Use CData Sync for automated, continuous, customizable LDAP replication to SingleStore.
-
Publish Reports with Basecamp in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Basecamp.
-
Use the CData ODBC Driver for SQL Analysis Services in Microsoft Power Query
You can use the CData SQL Analysis Services ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SQL Analysis Services into Microsoft Power Query.
-
Creating Google Ad Manager-Connected Applications in Unqork
You can use CData Connect to feed Google Ad Manager to Unqork and build custom business apps.
-
How to connect to JSON Services with Squirrel SQL client
Connect to JSON and execute queries in the Squirrel SQL Client.
-
Import Act CRM Using Azure Data Factory
Use CData Connect Cloud to connect to Act CRM from Azure Data Factory and import live Act CRM.
-
Import Neo4J into Microsoft Power Query
The CData Software Connect Server offers standards-based Web service endpoints that allow a variety of applications to access Neo4J. In this article, you will use the OData format to import Neo4J into Microsoft Power Query.
-
Facebook Ads Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Facebook Ads through CData Connect Cloud using different applications and tools.
-
Visualize Live Microsoft Exchange in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Microsoft Exchange.
-
Import SAP Netweaver Gateway into the Power BI Service for Visualizations
Use CData Software Connect Server to create an OData feed for SAP Netweaver Gateway and create custom reports in the Power BI Service.
-
Connect to eBay Analytics in Ruby
Connect to eBay Analytics in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create a Data Access Object for Veeva using JDBI
A brief overview of creating a SQL Object API for Veeva Vault in JDBI.
-
ETL CSV in Oracle Data Integrator
This article shows how to transfer CSV/TSV Files into a data warehouse using Oracle Data Integrator.
-
Import and Visualize Cvent in Power View
Create data visualizations based on Cvent in Excel.
-
Build Google Ads-Connected Dashboards Using Zoho Analytics
Use CData Connect Cloud to connect to Google Ads from Zoho Analytics and import live Google Ads.
-
How to Connect to & Open Act-On in Microsoft Excel
This article uses the CData ODBC driver for Act-On to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Bridge Airtable Connectivity with Apache NiFi
Access and process Airtable in Apache NiFi using the CData JDBC Driver.
-
Manage Smartsheet in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Smartsheet.
-
Use the CData ODBC Driver for Airtable in SAS JMP
You can use the CData ODBC Driver to integrate Airtable into the statistical analysis tools available in SAS JMP. This article shows how to use Airtable in the Graph Builder and Query Builder.
-
Replicate Highrise from PowerShell
Write a quick PowerShell script to query Highrise CRM. Use connectivity to the live data to replicate Highrise CRM to SQL Server.
-
Build Excel Online Visualizations in Tableau Cloud
Use CData Connect Cloud to connect to live Microsoft Excel Online and build visualizations in Tableau Cloud.
-
Create Zuora-Connected Enterprise Applications in OutSystems
Use CData Connect Cloud to connect to Zuora from OutSystems and build custom enterprise apps using live Zuora.
-
Use Biml to Build SSIS Tasks to Replicate RSS Feeds to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate RSS Feeds to SQL Server.
-
Design BIRT Reports on HBase
Provide current Apache HBase to your embedded analytics.
-
Connect to LinkedIn as a Linked Server
Use the SQL Gateway and the ODBC Driver to set up a linked server for LinkedIn.
-
Connect to Cloudant in Google Apps Script
Use the ODBC Driver for Cloudant and the SQL Gateway to access IBM Cloudant from Google Apps Script.
-
How to connect Amazon QuickSight to GraphQL
Create a connection to GraphQL in CData Connect Cloud and insert GraphQL into Amazon QuickSight SPICE to build interactive dashboards.
-
Automated Continuous Paylocity Replication to Vertica
Use CData Sync for automated, continuous, customizable Paylocity replication to Vertica.
-
Build Paylocity-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Paylocity.
-
Use the CData ODBC Driver for FTP from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for FTP to connect to FTP Servers from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring FTP Servers in Excel.
-
Connect to Workday in HULFT Integrate
Connect to Workday as a JDBC data source in HULFT Integrate
-
Bidirectional Access to Unbounce from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Unbounce in Filemaker Pro for Mac or Windows.
-
Integrate Live Veeva into Amazon SageMaker Canvas with RDS
Use CData Connect Cloud to connect to Veeva from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Veeva Vault.
-
How to create Microsoft Project federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Microsoft Project in MySQL .
-
Query Kintone as a SQL Server Database in Node.js
Execute SQL Server queries against Kintone from Node.js.
-
Visualize Live LDAP Objects in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live LDAP.
-
Connect to Live Bullhorn CRM in MicroStrategy through CData Connect Cloud
Create a live connection to Bullhorn CRM in CData Connect Cloud and connect to your Bullhorn CRM from MicroStrategy.
-
Replicate SAP Business One for Use in Salesforce Connect
Replicate SAP Business One to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Azure DevOps in Jaspersoft Studio
Execute SQL to remote Azure DevOps in Jaspersoft Studio.
-
DataBind Controls to Excel in Delphi
DataBind to Microsoft Excel in Delphi with standard data access components and controls.
-
Access Sybase in PHP through Connect Server
Connect to Sybase through the standard SQL Server libraries in PHP.
-
Analyze DB2 in R
Use standard R functions and the development environment of your choice to analyze IBM DB2 with the CData JDBC Driver for DB2.
-
Automated Continuous Google Search Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Google Search replication to Google BigQuery.
-
Connect to Azure Synapse through External Services in Salesforce
Use CData Connect Cloud to securely provide OData feeds of Azure Synapse to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Azure Synapse objects that you can access from apps and the dashboard.
-
Build MarkLogic Visualizations in Tableau Cloud
Use CData Software Connect Server to create a virtual SQL Server Database for MarkLogic and build visualizations in Tableau Cloud.
-
Deploy the ADO.NET Provider for Kintone on an SSRS Report Server
Connect to Kintone from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Using the CData Software ODBC Driver for Avalara AvaTax in PyCharm
Connect to Avalara AvaTax as an ODBC data source in PyCharm using the CData Software ODBC Driver for Avalara AvaTax.
-
Use the CData Software ODBC Driver for Greenplum in MicroStrategy Web
Connect to Pivotal GreenPlum in MicroStrategy Web using the CData Software ODBC Driver for Greenplum.
-
Connect to Real-Time Microsoft Exchange Data in Power Apps Using Dataflows to Build Custom Applications
-