CData Software - Knowledge Base

Recent Articles

• «
• 176
• 177
• 178
• 179
• 180
• 181
• 182
• 183
• 184
• 185
• »

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

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

• Replicate SQL Analysis Services from PowerShell

  Write a quick PowerShell script to query SQL Analysis Services. Use connectivity to the live data to replicate SQL Analysis Services to SQL Server.

• Automated Continuous Dynamics 365 Replication to Snowflake

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

• Use the CData ODBC Driver for IBM Cloud Object Storage from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC Driver for IBM Cloud Object Storage to connect to IBM Cloud Object Storage from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring IBM Cloud Object Storage in Excel.

• Create Reports from Zoho CRM in Looker Studio

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

• Creating Gmail-Connected Applications in Unqork

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

• Access Live Azure DevOps in AWS Lambda

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

• Add Kafka to Informatica Enterprise Data Catalog

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

• Import GitHub Using Azure Data Factory

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

• Create Sage Cloud Accounting-Connected Enterprise Applications in OutSystems

  Use CData Connect Cloud to connect to Sage Cloud Accounting from OutSystems and build custom enterprise apps using live Sage Business Cloud Accounting.

• Connect to Quickbase in SpagoBI

  Create reports featuring live Quickbase in SpagoBI Studio. Host Quickbase reports on SpagoBI Server.

• Build a Simple VCL Application for Amazon Athena

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

• Building Dynamic React Apps with Database Data

  Use Connect Server and React to Build Dynamic Web Apps with Live Database Data.

• Visualize JotForm in TIBCO Spotfire through ADO.NET

  Integrate JotForm into dashboards in TIBCO Spotfire.

• Create Snapchat Ads-Connected Applications in Appsmith

  Connect to Snapchat Ads via CData Connect Cloud in Appsmith and create custom business applications with real-time access to Snapchat Ads.

• Access Live SurveyMonkey in TIBCO Data Virtualization

  Use the CData Software TIBCO DV Adapter for SurveyMonkey to create a SurveyMonkey source in TIBCO Data Virtualization Studio and gain access to live SurveyMonkey from your TDV Server.

• Import Real-Time YouTube Analytics via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use YouTube Analytics in ColdFusion.

• Use the CData Software JDBC Driver for CouchDB in MicroStrategy Web

  Connect to Apache CouchDB in MicroStrategy Web using the CData Software JDBC Driver for CouchDB.

• Automated Continuous Google Spanner Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Google Spanner replication to OneLake in Microsoft Fabric.

• Connect to and Visualize Live Freshdesk in Tableau Prep

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

• Import Tableau CRM Analytics Using Azure Data Factory

  Use CData Connect Cloud to connect to Tableau CRM Analytics from Azure Data Factory and import live Tableau CRM Analytics.

• Automated Continuous Power BI XMLA Replication to SQLite

  Use CData Sync for automated, continuous, customizable Power BI XMLA replication to SQLite.

• Automated Continuous Exact Online Replication to Vertica

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

• Migrating data from Presto to Databricks using CData SSIS Components.

  Easily push Presto to Databricks using the CData SSIS Tasks for Presto and Databricks.

• How to Connect DBeaver to Oracle Sales via a JDBC Driver

  Manage Oracle Sales with visual tools in DBeaver like the query browser.

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

  Connect to real-time Apache Cassandra in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Cassandra.

• Use the CData Software JDBC Driver for SendGrid in MicroStrategy

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

• How to Connect to Phoenix in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Apache Phoenix. Leverage the pyodbc module for ODBC in Python.

• Access Live Avro in Coginiti Pro

  Connect to and query live Apache Avro from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Query Active Directory in DataGrip

  Create a Data Source for Active Directory in DataGrip and use SQL to query live Active Directory.

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

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

• Connect to and Query Twilio in QlikView over ODBC

  Create data visualizations with Twilio in QlikView.

• Replicate Reckon to Multiple Databases

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

• Automated Continuous WooCommerce Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable WooCommerce replication to Google Cloud SQL.

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

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

• Replicate Vertica in Heroku for Use in Salesforce Connect

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

• Query SAP Netweaver Gateway through ODBC in Node.js

  Use node-odbc to execute SQL queries against SAP Netweaver Gateway from Node.js.

• How to update MYOB AccountRight from Excel

  This article explains how to transfer data from Excel to MYOB AccountRight using the Excel Add-In for MYOB AccountRight.

• Visualize DocuSign in Tableau

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

• Automated Continuous Oracle Service Cloud Replication to Oracle

  Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to Oracle.

• Create Vault CRM-Connected Dashboards in Grafana

  Connect to Vault CRM via CData Connect Cloud in Grafana and create custom business dashboards with real-time access to Veeva Vault & Vault CRM.

• Automate Bullhorn CRM Replication to Azure Synapse

  Use CData Sync to customize and automate Bullhorn CRM replication to Azure Synapse.

• Connect to Invoiced from PowerBuilder via ODBC

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

• Object-Relational Mapping (ORM) with Snapchat Ads Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Snapchat Ads into a Java-based ORM framework, Hibernate.

• Build a Simple VCL Application for Wave Financial

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

• Access Live Smartsheet in SAS JMP via ODBC

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

• Trigger Sage 50 UK IFTTT Flows in Azure App Service

  This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.

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

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

• Deploy the ADO.NET Provider for Amazon DynamoDB on an SSRS Report Server

  Connect to Amazon DynamoDB 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.

• Build Oracle Financials Cloud Visualizations in Tableau Cloud

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

• Automated Continuous OneNote Replication to IBM DB2

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

• Connect to Workday in DBArtisan

  Use wizards in DBArtisan to configure Workday as a data source.

• Automated Continuous Hive Replication to Amazon Redshift

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

• Automated Continuous Calendly Replication to SQL Server

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

• Connect to Amazon DynamoDB from Excel & GoogleSheets!

  Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Amazon DynamoDB, and over 250 other data sources, right inside your Excel and Google spreadsheets!

• Integrate SendGrid into Power Automate Desktop using CData Connect

  CData Connect for SendGrid enables you to integrate SendGrid into workflows built using Microsoft Power Automate Desktop.

• DataBind Controls to Google Analytics in Delphi

  DataBind to Google Analytics in Delphi with standard data access components and controls.

• Automated Continuous Microsoft Teams Replication to MySQL

  Use CData Sync for automated, continuous, customizable Microsoft Teams replication to MySQL.

• Automated Continuous Pipedrive Replication to SingleStore

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

• Integrate with TaxJar using Apache Camel2

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

• Connect to Act-On in RapidMiner

  Integrate Act-On with standard components and data source configuration wizards in RapidMiner Studio.

• How to Connect to & Open Google Ad Manager in Microsoft Excel

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

• Use the CData Software JDBC Driver for Microsoft Dataverse in MicroStrategy Web

  Connect to Microsoft Dataverse (CDS) in MicroStrategy Web using the CData Software JDBC Driver for Microsoft Dataverse.

• Automated Continuous TaxJar Replication to Oracle

  Use CData Sync for automated, continuous, customizable TaxJar replication to Oracle.

• Use the CData Software JDBC Driver for QuickBooks Online in MicroStrategy Web

  Connect to QuickBooks Online in MicroStrategy Web using the CData Software JDBC Driver for QuickBooks Online.

• Excel Spreadsheet Automation on Oracle SCM with the QUERY Formula

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

• Consume ShipStation OData Feeds in PowerBuilder

  This article demonstrates how to consume ShipStation as OData feeds from PowerBuilder using the API Server.

• How to import eBay into Apache Solr

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

• Use the CData Software JDBC Driver for LinkedIn in MicroStrategy Web

  Connect to LinkedIn in MicroStrategy Web using the CData Software JDBC Driver for LinkedIn.

• Use JayDeBeApi to access Dynamics NAV in Python

  Use standard Python scripting and the development environment of your choice to access live Microsoft Dynamics NAV.

• Design BIRT Reports on Procore

  Provide current Procore to your embedded analytics.

• Migrating data from Dynamics CRM to Snowflake using CData SSIS Components.

  Easily push Microsoft Dynamics CRM to Snowflake using the CData SSIS Tasks for Dynamics CRM and Snowflake.

• DataBind MarkLogic to the DevExpress Data Grid

  Use the CData Software ADO.NET Provider for MarkLogic with the DevExpress Windows Forms and Web controls to provide MarkLogic to a chart.

• Rapidly Develop Azure Analysis Services-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.

• Consume MariaDB OData Feeds in PowerBuilder

  This article demonstrates how to consume MariaDB as OData feeds from PowerBuilder using the API Server.

• Automate Procore Replication to Couchbase

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

• Add WooCommerce to Informatica Enterprise Data Catalog

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

• Connect to Neo4J from a Connection Pool in Jetty

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

• Back Up Amazon DynamoDB to SQL Server through SSIS

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

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for Invoiced

  Provide connectivity to Invoiced through an SAP BusinessObjects universe.

• Replicate Confluence in Heroku for Use in Salesforce Connect

  Replicate Atlassian Confluence to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Write a Simple Go Application to work with SQL Server on Linux

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

• Process & Analyze Aha in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Aha .

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

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

• Create Redis-Connected Applications in Appsmith

  Connect to Redis via CData Connect Cloud in Appsmith and create custom business applications with real-time access to Redis.

• Use the CData Software JDBC Driver for DocuSign in MicroStrategy Web

  Connect to DocuSign in MicroStrategy Web using the CData Software JDBC Driver for DocuSign.

• Work with Acumatica in FoxPro

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

• Access Live Instagram in AWS Lambda

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

• Connect to BigQuery in RapidMiner

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

• Query Zendesk in DataGrip

  Create a Data Source for Zendesk in DataGrip and use SQL to query live Zendesk.

• Connect to Active Directory from Crystal Reports

  Use CData Connect Cloud to connect to and report on live Active Directory from Crystal Reports.

• Bind Live Authorize.Net Data in Wijmo FlexGrid with CData API Server

  With CData API Server, easily create OData endpoints for live Authorize.Net data

• Operational Reporting on Couchbase from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Couchbase.

• Connect to Azure Data Catalog from a Connection Pool in JBoss

  Integrate Azure Data Catalog into Java servlets: Use the Management Console in JBoss to install the Azure Data Catalog JDBC Driver.

• Connect to ClickUp from PowerBuilder via ODBC

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

• How to connect to Excel Online from IntelliJ

  Integrate connectivity to Microsoft Excel Online with wizards in IntelliJ.

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

  Use CData Power BI Connectors to visualize SAP ERP/NetWeaver in Power BI.

• View Reports on Real-Time Google Ad Manager in Power BI Report Server

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

• Automated Continuous Office 365 Replication to IBM DB2

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

• Automate HBase Replication to SAP HANA

  Use CData Sync to customize and automate Apache HBase replication to SAP HANA.

• «
• 176
• 177
• 178
• 179
• 180
• 181
• 182
• 183
• 184
• 185
• »