CData Software - Knowledge Base

Recent Articles

• «
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• »

• Automated Continuous Coinbase Replication to Microsoft Access

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

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

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

• Access Oracle Eloqua from MySQL in Amazon QuickSight

  Connect to Oracle Eloqua and build visualizations of Oracle Eloqua using a MySQL Connection in Amazon QuickSight.

• Automate EnterpriseDB Replication to Couchbase

  Use CData Sync to Customize and automate EnterpriseDB replication to Couchbase.

• Integrate Snapchat Ads into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Snapchat Ads and integrate live Snapchat Ads into your Power Automate tasks.

• Automated Continuous Unbounce Replication to MongoDB

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

• Publish Drip-Connected Dashboards in Tableau Server

  Use CData JDBC drivers and Tableau Server to visualize live Drip.

• How to Query Live Presto Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Presto data in natural language using Python.

• Query Klaviyo as a SQL Server in Node.js

  Execute SQL Server queries against Klaviyo from Node.js.

• Access Live Azure Analysis Services in Excel (Desktop)

  Use CData Connect Cloud to gain access to live Azure Analysis Services from your Excel spreadsheets.

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

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

• Publish Reports with Sage Intacct in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Sage Intacct.

• Work with SQL Server in FoxPro

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

• Analyze Zuora in Cognos Analytics

  Use CData Connect Cloud to connect to Zuora from Cognos Analytics and analyze live Zuora.

• Build Automated Workflows with Live CockroachDB in Workato

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

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

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

• Integrate Live Google Data Catalog into Custom Business Apps Built in Power Apps

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

• Create Blackbaud FE NXT Dashboards in Bold BI

  Use CData Software Connect Server to create a virtual SQL Server Database for Blackbaud FE NXT to build custom dashboards in Bold BI.

• Create ShipStation Dashboards in Bold BI

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

• Analyze Epicor Kinetic with Power Pivot

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

• Automated Continuous Epicor Kinetic Replication to IBM DB2

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

• How to Connect the Power BI Service to Clio: Complete Guide

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

• Automated Continuous BambooHR Replication to Vertica

  Use CData Sync for automated, continuous, customizable BambooHR replication to Vertica.

• Automate TaxJar Replication to Azure Data Lake

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

• Connect to Sybase IQ in CloverDX (formerly CloverETL)

  Transfer Sybase IQ using the visual workflow in the CloverDX data integration tool.

• Provide OData Services of Twitter Ads from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for Twitter Ads by developing a WCF Service Application.

• How to integrate Metabase with Sage 200

  Use CData Connect Cloud to connect to live Sage 200 and create an interactive dashboard in Metabase from Sage 200.

• Visualize Live MySQL in the Power BI Service

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

• Connect to Kintone in RazorSQL

  Connect to Kintone from wizards and query Kintone from the GUI in the RazorSQL database management tool.

• Connect to Oracle Financials Cloud in HULFT Integrate

  Connect to Oracle Financials Cloud as a JDBC data source in HULFT Integrate

• DataBind Wijmo Grid to Shopify

  Provide real-time Shopify to interactive controls.

• Use the CData ODBC Driver for DocuSign in SAS JMP

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

• Connect to JotForm in CloverDX (formerly CloverETL)

  Transfer JotForm using the visual workflow in the CloverDX data integration tool.

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Google Spanner

  Provide connectivity to Google Spanner through an SAP BusinessObjects universe.

• Visualize Bitbucket in TIBCO Spotfire through ODBC

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

• Working with QuickBooks Time in LINQPad

  Execute LINQ queries to QuickBooks Time in LINQPad.

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

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

• Create SQL Analysis Services-Connected Visualizations in Klipfolio

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

• Automated Continuous XML Replication to SQL Server

  Use CData Sync for automated, continuous, customizable XML replication to SQL Server.

• Prepare, Blend, and Analyze MongoDB in Alteryx Designer

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

• Query HDFS as a MySQL Database in Node.js

  Execute MySQL queries against Apache HDFS from Node.js.

• A PostgreSQL Interface for Twilio

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

• How to Work with GraphQL in ETL Validator JDBC

  Connect to GraphQL from ETL Validator jobs using the CData Software JDBC Driver.

• Connect to Greenhouse in RapidMiner

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

• Connect to PostgreSQL in Google Apps Script

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

• How to create Visio diagrams from NetSuite

  Automatically update NetSuite CRM & ERP with the changes you make to Visio master shapes.

• Model Sugar CRM Using Azure Analysis Services

  Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Sugar CRM, enabling the direct import of real-time Sugar CRM.

• Replicate Bing Search Results for Use in Salesforce Connect

  Replicate Bing Search to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• How to connect PolyBase to Oracle Service Cloud

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Oracle Service Cloud.

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

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

• Connect to Sage Cloud Accounting from PowerBuilder

  This article demonstrates how to use the CData ODBC Driver for Sage Cloud Accounting to connect to Sage Business Cloud Accounting and execute queries in PowerBuilder.

• How to connect to Procore from IntelliJ

  Integrate connectivity to Procore with wizards in IntelliJ.

• How to Build an ETL App for PostgreSQL in Python with CData

  Create ETL applications and real-time data pipelines for PostgreSQL in Python with petl.

• Access Monday.com 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 Monday.com.

• Import Freshdesk Using Azure Data Factory

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

• Automated Continuous HDFS Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable HDFS replication to Amazon S3.

• Instagram Reporting in OBIEE with the Instagram JDBC Driver

  Deploy the Instagram JDBC driver on OBIEE to provide real-time reporting across the enterprise.

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

  Create an ODBC connection to Cloudant in Informatica and browse and transfer IBM Cloudant.

• Choosing the Best Method to Connect XML to SQL Server: 5 Options Explained

  Discover multiple ways to connect and use XML Files from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

• DataBind Wijmo Grid to SurveyMonkey

  Provide real-time SurveyMonkey to interactive controls.

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Impala

  Provide connectivity to Apache Impala through an SAP BusinessObjects universe.

• Access Live CockroachDB in Excel 365 Online (Excel for the web)

  Connect to CockroachDB from Excel 365 Online (Excel for the web) with CData Connect Cloud.

• Add Avro to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for Avro with the Informatica Enterprise Data Catalog to classify and organize data.

• Rapidly Develop Tableau CRM Analytics-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.

• Integrate with Greenplum using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Pivotal GreenPlum to a JSON file on disk.

• How to pipe IBM Cloud Data Engine to CSV in PowerShell

  Use standard PowerShell cmdlets to access IBM Cloud Data Engine tables.

• Automated Continuous SurveyMonkey Replication to Databricks

  Use CData Sync for automated, continuous, customizable SurveyMonkey replication to Databricks.

• How to Connect to & Open BigCommerce in Microsoft Excel

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

• Automated Continuous Shippo Replication to Apache Kafka

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

• How to integrate Metabase with Google Calendar

  Use CData Connect Cloud to connect to live Google Calendar and create an interactive dashboard in Metabase from Google Calendar.

• Work with Live Active Directory in Power Query

  Use CData Connect Cloud to connect to Active Directory and work with live Active Directory in Microsoft Power Query.

• DataBind Charts to Snapchat Ads

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Snapchat Ads from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

• A PostgreSQL Interface for REST

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

• Create Reports from Marketo in Looker Studio

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

• Connect to Real-Time TigerGraph Data in Power Apps Using Dataflows to Build Custom Applications

• «
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• »