CData Software - Knowledge Base
Recent Articles
-
Automate Amazon DynamoDB Replication to Azure Data Lake
Use CData Sync to customize and automate Amazon DynamoDB replication to Azure Data Lake.
-
Connect to Aha in Ruby
Connect to Aha! in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
CSV: Unable to Retrieve Columns for Table "csv"
In this entry you will find the resolution for the error: unable to retrieve columns for table "csv".
-
Create Vault CRM-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Vault CRM from OutSystems and build custom enterprise apps using live Veeva Vault & Vault CRM.
-
Build Visualizations of PayPal in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of PayPal in Birst.
-
Publish Crystal Reports on ShipStation
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ShipStation.
-
Publish SFTP-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SFTP.
-
Deploy the ADO.NET Provider for IBM Cloud Object Storage on an SSRS Report Server
Connect to IBM Cloud Object Storage 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.
-
Establish a Live Connection with SAP Ariba Procurement using Tableau Bridge
The CData ODBC Driver for SAP Ariba Procurement enables you to integrate live SAP Ariba Procurement into Tableau Cloud dashboards using the Tableau Bridge.
-
Building Dynamic Web Pages with Google Sheets Using AngularJS
Create single-page applications with live connectivity to Google Sheets using the CData API Server.
-
Access Parquet from MySQL in PHP
Connect to Parquet through the standard MySQL libraries in PHP.
-
Build Spark-Connected Apps in Choreo
Use CData Connect AI to connect to Spark from Choreo and build custom apps using live Apache Spark SQL.
-
How to connect to SAP Business One from IntelliJ
Integrate connectivity to SAP Business One with wizards in IntelliJ.
-
Use the CData Software JDBC Driver for Wave Financial in MicroStrategy Web
Connect to Wave Financial in MicroStrategy Web using the CData Software JDBC Driver for Wave Financial.
-
Build Azure Data Lake Storage-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Azure Data Lake Storage.
-
How to Connect to & Open ShipStation in Microsoft Excel
This article uses the CData ODBC driver for ShipStation to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Replicate Marketo in Heroku for Use in Salesforce Connect
Replicate Marketo to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automated Continuous MarkLogic Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable MarkLogic replication to Google Cloud SQL.
-
Connect to and Query Sage 300 in QlikView over ODBC
Create data visualizations with Sage 300 in QlikView.
-
Use Biml to Build SSIS Tasks to Replicate Bitbucket to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Bitbucket to SQL Server.
-
Create Apps from Google Spanner in Qlik Sense Cloud
Use CData Connect AI to connect to Google Spanner and build apps from live Google Spanner in Qlik Sense Cloud.
-
ETL SQL Server in Oracle Data Integrator
This article shows how to transfer Microsoft SQL Server into a data warehouse using Oracle Data Integrator.
-
Explore Geographical Relationships in Office 365 with Power Map
Create data visualizations with Microsoft Office 365 in Power Map.
-
Analyze Microsoft Exchange in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Microsoft Exchange and visualize Microsoft Exchange in SAP Analytics Cloud.
-
Connect to Microsoft Dataverse from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Microsoft Dataverse (CDS), and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
ETL Snapchat Ads in Oracle Data Integrator
This article shows how to transfer Snapchat Ads into a data warehouse using Oracle Data Integrator.
-
Connect to Impala from PowerBuilder via ADO.NET
This article demonstrates how to access Apache Impala from Appeon PowerBuilder using the CData ADO.NET Provider for Impala.
-
Snowflake Reporting in OBIEE with the Snowflake JDBC Driver
Deploy the Snowflake JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Design BIRT Reports on JDBC-ODBC Bridge
Provide current JDBC-ODBC Bridge to your embedded analytics.
-
Prepare, Blend, and Analyze Salesforce Marketing in Alteryx Designer (ODBC)
Build workflows to access live Salesforce Marketing Cloud for self-service data analytics.
-
Create Salesforce-Connected Business Apps in AppSheet
Connect to Salesforce via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Salesforce & Force.com.
-
A PostgreSQL Interface for ActiveCampaign (MySQL Remoting via JDBC)
Use the Remoting features of the ActiveCampaign JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to eBay Analytics from a Connection Pool in WebLogic
Use the CData JDBC Driver for eBay Analytics to connect to eBay Analytics from Web applications running on WebLogic.
-
Manage REST in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for REST.
-
How to Connect the Power BI Service to SAP SuccessFactors: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Use Biml to Build SSIS Tasks to Replicate eBay to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate eBay to SQL Server.
-
Integrate ActiveCampaign in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ActiveCampaign from Informatica Cloud.
-
Work with Act-On in FoxPro
Load Act-On into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use the CData API Server to Access Oracle in Microsoft PowerPivot
Use the CData API Server to connect to live Oracle Database in the Power Pivot business intelligence tool.
-
How to Connect DBeaver to ConstantContact via a JDBC Driver
Manage ConstantContact with visual tools in DBeaver like the query browser.
-
Video: Connecting to Google BigQuery Data from Microsoft Excel
This video shows how to use the CData ODBC Driver for Google BigQuery to connect to Google BigQuery. You will create a DSN and then use the Data Connection Wizard in Excel to retrieve BigQuery data.
-
Connect to SuiteCRM from a Connection Pool in WebLogic
Use the CData JDBC Driver for SuiteCRM to connect to SuiteCRM from Web applications running on WebLogic.
-
Integrate Wave Financial in Pentaho Data Integration
Build ETL pipelines based on Wave Financial in the Pentaho Data Integration tool.
-
Analyze Hive with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Hive from Power Pivot. You will use the Table Import Wizard to load Apache Hive. You can visually build the import query or use any SQL supported by the driver.
-
Getting Started with the CData Power BI Connector for Salesforce Marketing
-