CData Software - Knowledge Base

Recent Articles

• «
• 78
• 79
• 80
• 81
• 82
• 83
• 84
• 85
• 86
• 87
• »

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

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

• Connect to OData from Asprova with CData Software ODBC Driver for OData

  This article shows how to connect faster to OData data from Asprova.

• Publish XML-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live XML Files.

• Write a Simple Go Application to work with Zoom on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Zoom.

• Connect to Dropbox in RapidMiner

  Integrate Dropbox with standard components and data source configuration wizards in RapidMiner Studio.

• Connect to Klaviyo from Asprova with CData Software ODBC Driver for Klaviyo

  This article shows how to connect faster to Klaviyo data from Asprova.

• Automated Continuous Smartsheet Replication to Local Delimited Files

  Use CData Sync for automated, continuous, customizable Smartsheet replication to delimited files (CSV/TSV).

• How to Connect DBeaver to ServiceNow via a JDBC Driver

  Manage ServiceNow with visual tools in DBeaver like the query browser.

• Automated Continuous QuickBooks Replication to Snowflake

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

• Visualize Bullhorn CRM in Tableau

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

• Build Charts with SAS Data Sets in Clear Analytics

  Create dynamic charts and perform analytics based on SAS Data Sets in Clear Analytics.

• Load Elasticsearch to a Database Using Embulk

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

• Create Unbounce-Connected Visualizations in Klipfolio

  Use CData Software Connect Server to connect to Unbounce from Klipfolio and build custom visualizations using live Unbounce.

• Analyze Google Drive in SAP Analytics Cloud

  Use the CData Connect Server to create an OData API on top of Google Drive and visualize Google Drive in SAP Analytics Cloud.

• Build Snowflake Visualizations in Tableau Desktop

  Use CData Connect Cloud to connect to live Snowflake and build visualizations in Tableau.

• Analyze Power BI XMLA in Infragistics Reveal

  Use CData Connect Cloud to create on OData API on top of Power BI XMLA and visualize live Power BI XMLA in Infragistics Reveal.

• DataBind Controls to Act-On in C++Builder

  DataBind to Act-On in C++Builder with standard components and controls.

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

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

• How to load Salesforce Marketing data into Elasticsearch via Logstash

  Introducing a simple method to load Salesforce Marketing data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

• Automated Continuous Snapchat Ads Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable Snapchat Ads replication to Microsoft Access.

• Import Typeform into FileMaker Pro

  Create reports that integrate Typeform in Filemaker Pro.

• Use the CData Software ODBC Driver for Zoho Projects in MicroStrategy Desktop

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

• Work with Reckon in FoxPro

  Load Reckon into a FoxPro database. This article includes full code and a walk-through of the process.

• Bidirectional Access to Dynamics CRM from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate Microsoft Dynamics CRM in Filemaker Pro for Mac or Windows.

• Design BIRT Reports on AlloyDB

  Provide current Google AlloyDB to your embedded analytics.

• Integrate Dynamics 365 Business Central into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Dynamics 365 Business Central and integrate live Dynamics 365 Business Central into your Power Automate tasks.

• Use the CData Software JDBC Driver for Reckon in MicroStrategy

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

• How to connect to Sage Intacct in DBVisualizer

  Integrate Sage Intacct with visual data analysis tools and data connection wizards in DBVisualizer

• Query HubDB as a MySQL Database in Node.js

  Execute MySQL queries against HubDB from Node.js.

• Integrate with Raisers Edge NXT in JReport Designer

  Create charts and reports based on Raisers Edge NXT in JReport Designer.

• Build IBM Informix Visualizations in Tableau Desktop

  Use CData Connect Cloud to connect to live IBM Informix and build visualizations in Tableau.

• Write a Simple Go Application to work with Harvest on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Harvest.

• Connect to and Visualize Live Clio in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Clio.

• How to connect to Microsoft Exchange from MS Excel on Mac OS X

  Create a Data Source Name in iODBC with the CData ODBC Driver for Microsoft Exchange and work with Microsoft Exchange in Microsoft Excel on Mac OS X.

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

  Create an ODBC connection to Access in Informatica and browse and transfer Microsoft Access.

• Build Gmail Visualizations in Tableau Cloud

  Use CData Connect Cloud to connect to live Gmail and build visualizations in Tableau Cloud.

• Connect to MongoDB through External Services in Salesforce

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

• How to Access Quickbase Using Entity Framework

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

• Manage Google Sheets in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Google Sheets.

• How to connect to Spark from MS Excel on Mac OS X

  Create a Data Source Name in iODBC with the CData ODBC Driver for Spark and work with Apache Spark SQL in Microsoft Excel on Mac OS X.

• Connect to Azure Table in Aqua Data Studio

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

• Build Automated Workflows with Live Odoo in Workato

  Use CData Connect Cloud to connect to live Odoo ERP and build automated workflows in Workato.

• Create a Data Access Object for SendGrid using JDBI

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

• Query Cosmos DB in ColdFusion

  Write standard ColdFusion data access code to connect to Azure Cosmos DB.

• Visualize SAP Ariba Procurement in Sisense

  Create an ElastiCube in Sisense app with access to SAP Ariba Procurement.

• Connect to Snapchat Ads from PowerBuilder

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

• How to create Sage 300 federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Sage 300 in MySQL .

• Viewing Databricks in RAD Studio Data Explorer

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

• Create Reports from Smartsheet in Looker Studio

  Use CData Connect Cloud to gain access to live Smartsheet and create custom reports in Looker Studio.

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

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

• Create SFTP Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time SFTP data access from reports, embedded analytics, and more.

• Automated Continuous SAP HANA Replication to MongoDB

  Use CData Sync for automated, continuous, customizable SAP HANA replication to MongoDB.

• Connect to Teradata as a Linked Server

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Teradata.

• Automate Salesloft Integration Tasks from PowerShell

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

• Using AngularJS to Build Dynamic Web Pages with Microsoft Teams

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

• Query Reckon as a MySQL Database in Node.js

  Execute MySQL queries against Reckon from Node.js.

• Integrate JotForm into Automated Tasks with Power Automate

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

• Viewing Zoho Inventory in RAD Studio Data Explorer

  How to view Zoho Inventory in RAD Studio Data Explorer using the CData ODBC Driver for Zoho Inventory.

• Create MYOB AccountRight-Connected Visualizations in Klipfolio

  Use CData Connect Cloud to connect to MYOB AccountRight from Klipfolio and build custom visualizations using live MYOB AccountRight.

• How to create ClickUp federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for ClickUp in MySQL .

• Analyze LDAP Objects with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for LDAP from Power Pivot. You will use the Table Import Wizard to load LDAP. You can visually build the import query or use any SQL supported by the driver.

• Create Spark Dashboards in Bold BI

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

• Access Live SAP HANA XS Advanced in AWS Lambda (with IntelliJ IDEA)

  Connect to live SAP HANA XS Advanced in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• Use CData Connect Cloud to Access Azure DevOps in Microsoft Power Pivot

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

• Query Drift in ColdFusion

  Write standard ColdFusion data access code to connect to Drift.

• How to work with MarkLogic in Apache Spark using SQL

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

• How to Connect to & Open Cvent in Microsoft Excel

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

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

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

• Connect to SingleStore from Asprova with CData Software ODBC Driver for SingleStore

  This article shows how to connect faster to SingleStore data from Asprova.

• Connect to QuickBooks Time from a Connection Pool in JBoss

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

• Connect to SAP SuccessFactors from a Connection Pool in WebLogic

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

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

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

• Creating Invoiced-Connected Applications in Unqork

  You can use CData Connect to feed Invoiced to Unqork and build custom business apps.

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

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

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

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

• How to connect PolyBase to Google Drive

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

• Visualize Live Oracle Service Cloud in Power BI (via CData Connect Cloud)

  Use the CData Power BI Connector and CData Connect Cloud to integrate live Oracle Service Cloud into custom reports in Power BI.

• Connect to Avro from PowerBuilder

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

• Connect to Jira Service Management as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live Atlassian Jira Service Management.

• Bridge CouchDB Connectivity with Apache NiFi

  Access and process Apache CouchDB in Apache NiFi using the CData JDBC Driver.

• Create Reports with Amazon DynamoDB in SAP Crystal Reports

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

• ETL Microsoft Project in Oracle Data Integrator

  This article shows how to transfer Microsoft Project into a data warehouse using Oracle Data Integrator.

• Build MVC Applications with Connectivity to Google Analytics

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

• Automated Continuous Dynamics NAV Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable Dynamics NAV replication to AlloyDB.

• Author and Share Power BI Reports on Real-Time Azure Data Catalog

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

• How to Access Sugar CRM Using Entity Framework

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

• Excel Spreadsheet Automation with the QUERY Formula

  Pull data, automate spreadsheets, and more with the QUERY formula.

• Use Biml to Build SSIS Tasks to Replicate Zenefits to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Zenefits to SQL Server.

• Automated Continuous Reckon Accounts Hosted Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to SQL Server.

• Connect to Power BI XMLA from PowerBuilder

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

• How to load SAP HANA XS Advanced data into Elasticsearch via Logstash

  Introducing a simple method to load SAP HANA XS Advanced data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

• Automated Continuous Wave Financial Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable Wave Financial replication to AlloyDB.

• Automated Continuous Quickbase Replication to SingleStore

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

• Connect to Zoom in the Denodo Platform

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

• How to work with Oracle Eloqua in Apache Spark using SQL

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

• Automated Continuous Instagram Replication to IBM DB2

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

• LINQ to Clio

  LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Clio Data Provider.

• Build a Simple VCL Application for Amazon Marketplace

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

• Visualize Live Zoho Inventory in the Power BI Service

  Use CData Connect Cloud to connect to live Zoho Inventory and create custom reports in the Power BI Service through the On-Premises Gateway.

• Perform Batch Operations with Facebook Ads in Apache NiFi

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

• «
• 78
• 79
• 80
• 81
• 82
• 83
• 84
• 85
• 86
• 87
• »