CData Software - Knowledge Base

Recent Articles

• «
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• 51
• 52
• »

• DataBind Wijmo Grid to Dynamics 365

  Provide real-time Microsoft Dynamics 365 to interactive controls.

• Access Azure Active Directory 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 Azure Active Directory.

• Connect to IBM Informix in RapidMiner

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

• Integrate with GraphQL using Apache Camel2

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

• How to connect Amazon QuickSight to Raisers Edge NXT

  Create a connection to Raisers Edge NXT in CData Connect Cloud and insert Raisers Edge NXT into Amazon QuickSight SPICE to build interactive dashboards.

• Automated Continuous MarkLogic Replication to Vertica

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

• Use JayDeBeApi to access Email in Python

  Use standard Python scripting and the development environment of your choice to access live Email.

• Work with Basecamp in FoxPro

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

• Build QuickBooks Online-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live QuickBooks Online.

• Connect to Stripe in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Access Live ConstantContact in AWS Lambda

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

• Automate OData Services Replication to Azure Data Lake

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

• How to integrate Metabase with LinkedIn Ads

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

• DataBind Wijmo Grid to Todoist

  Provide real-time Todoist to interactive controls.

• Build Dashboards with Couchbase in Dundas BI

  Create dynamic dashboards and perform analytics based on Couchbase in Dundas BI.

• Replicate ClickUp from PowerShell

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

• Create a Data Access Object for EnterpriseDB using JDBI

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

• Create Apps from Oracle Sales in Qlik Sense Cloud

  Use CData Connect Cloud to connect to Oracle Sales and build apps from live Oracle Sales in Qlik Sense Cloud.

• Automated Continuous Amazon S3 Replication to Databricks

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

• Access Live Cassandra in AWS Lambda (with IntelliJ IDEA)

  Connect to live Apache Cassandra in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• Import Real-Time Cloudant in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use IBM Cloudant in ColdFusion.

• Visualize Zuora in TIBCO Spotfire through ODBC

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

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

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

• Automated Continuous Parquet Replication to Amazon S3

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

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

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

• How to Query Microsoft Teams in MySQL Workbench

  Execute MySQL queries against live Microsoft Teams from MySQL Workbench.

• Automate ActiveCampaign Replication to Azure Synapse

  Use CData Sync to customize and automate ActiveCampaign replication to Azure Synapse.

• How to Build Dynamic React Apps with Avro

  Use the CData Connect and React to Build Dynamic Web Apps with Live Avro .

• Automated Continuous SharePoint Replication to Apache Kafka

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

• Prepare, Blend, and Analyze Xero in Alteryx Designer

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

• Connect to BigQuery from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live Google BigQuery from Filemaker Pro on Mac.

• Publish Reports with Marketo in SAP Crystal Reports

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

• Import Real-Time Zendesk in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Zendesk in ColdFusion.

• Prepare, Blend, and Analyze Adobe Commerce in Alteryx Designer

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

• Connect to Impala in DBeaver

  Use the CData ODBC Driver to connect to Apache Impala in DBeaver.

• Connect to Blackbaud FE NXT in as an External Source in Dremio

  Use the CData JDBC Driver to connect to Blackbaud FE NXT as an External Source in Dremio.

• Build Automated Workflows with Live HCL Domino in Workato

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

• Connect to Drift from a Connection Pool in JBoss

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

• Publish BigCommerce-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live BigCommerce.

• PowerShell Scripting to Replicate Oracle Service Cloud to MySQL

  Write a simple PowerShell script to replicate Oracle Service Cloud to a MySQL database.

• Integrate with live Google Ads in Jitterbit

  Use CData Connect Cloud to connect to and integrate live Google Ads in Jitterbit.

• Create Azure Analysis Services-Connected Enterprise Applications in OutSystems

  Use CData Connect Cloud to connect to Azure Analysis Services from OutSystems and build custom enterprise apps using live Azure Analysis Services.

• A PostgreSQL Interface for SAS xpt

  Use the Remoting features of the SAS xpt ODBC Driver to create a PostgreSQL entry-point for data access.

• Use Dash to Build to Web Apps on Sybase IQ

  Create Python applications that use pandas and Dash to build Sybase IQ-connected web apps.

• Automated Continuous TaxJar Replication to PostgreSQL

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

• Analyze IBM Cloud Data Engine with Power Pivot

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

• Automated Continuous Twitter Ads Replication to Snowflake

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

• How to create an RPA flow for SingleStore in UiPath Studio

  Use the SingleStore ODBC Driver to create workflows that access real-time SingleStore without any coding.

• Integrate Live Microsoft OneDrive into Custom Business Apps Built in Power Apps

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

• Access Live Microsoft Planner in AWS Lambda (with IntelliJ IDEA)

  Connect to live Microsoft Planner in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• Visualize Live Blackbaud FE NXT in Power BI (via CData Connect Cloud)

  Use the CData Power BI Connector and CData Connect Cloud to integrate live Blackbaud FE NXT into custom reports in Power BI.

• Connect to Azure Table in CloverDX (formerly CloverETL)

  Transfer Azure Table Storage using the visual workflow in the CloverDX data integration tool.

• Bidirectional Access to Slack from FileMaker Pro

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

• Query Dynamics 365 as a SQL Server Database in Node.js

  Execute SQL Server queries against Microsoft Dynamics 365 from Node.js.

• Analyze eBay in SAP Analytics Cloud

  Use CData Connect Cloud to create an OData API on top of eBay and visualize eBay in SAP Analytics Cloud.

• Load Sage Cloud Accounting to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Sage Business Cloud Accounting to a database.

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

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

• Build Semantic Layer Views for Klaviyo in APOS Live Data Gateway

  Use the CData Connector for Klaviyo in APOS Live Data Gateway to build Semantic Layer Views for Klaviyo.

• How to Access Live Odoo in Power Automate Desktop via ODBC

  The CData ODBC Driver for Odoo enables you to integrate Odoo ERP into workflows built using Microsoft Power Automate Desktop.

• Feed Gmail into FineReport

  How to set Gmail as a JDBC data source in FineReport.

• Analyze ActiveCampaign in Cognos Analytics

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

• Create Instagram-Connected Visualizations in Klipfolio

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

• How to Import Parquet into SQL Server using SSIS

  Easily back up Apache Parquet to SQL Server using the SSIS components for Parquet.

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

  Use CData Power BI Connectors to visualize Microsoft Access in Power BI.

• Automated Continuous Sage Cloud Accounting Replication to MySQL

  Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to MySQL.

• Create Data Visualizations Based On Cosmos DB in Mode

  Use CData Connect Cloud to connect to Cosmos DB from Mode and build visualizations using live

• How to use SQLAlchemy ORM to access HubDB in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of HubDB.

• Extract, Transform, and Load CSV in Informatica PowerCenter

  Create a simple Workflow for CSV/TSV Files in Informatica PowerCenter.

• Integrate Databricks in the Pentaho Report Designer

  Publish reports based on Databricks in the Pentaho BI tool.

• Connect to Odoo from a Connection Pool in JBoss

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

• Provide OData Services of SharePoint from a WCF Application

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

• Access Snowflake in PHP through Connect Server

  Connect to Snowflake through the standard SQL Server libraries in PHP.

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

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

• Natively Connect to Azure Synapse in PHP

  Create PHP applications on Linux/UNIX machines with connectivity to Azure Synapse. Leverage the native support for ODBC in PHP.

• Create SAS Data Sets-Connected Business Apps in AppSheet

  Use CData Software Connect Server to connect to SAS Data Sets from AppSheet and build custom business apps using live SAS Data Sets.

• Connect to Greenhouse from a Connection Pool in WebLogic

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

• Connect to Dynamics 365 Business Central in Aqua Data Studio

  Access Dynamics 365 Business Central from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Automated Continuous Authorize.Net Replication to Local Delimited Files

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

• Integrate Adobe Commerce in the Pentaho Report Designer

  Publish reports based on Adobe Commerce in the Pentaho BI tool.

• Integrate with Oracle Eloqua using Apache Camel2

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

• How to Visualize Certinia Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Certinia in Python.

• Access Gmail 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 Gmail.

• Analyze PostgreSQL in R

  Create data visualizations and use high-performance statistical functions to analyze PostgreSQL in Microsoft R Open.

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

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

• Automate Microsoft Teams Replication to Couchbase

  Use CData Sync to Customize and automate Microsoft Teams replication to Couchbase.

• Connect to Snowflake in the Denodo Platform

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

• Automated Continuous Marketo Replication to SQL Server

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

• Integrate EventBrite in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Eventbrite from Informatica Cloud.

• Automated Continuous Tally Replication to Snowflake

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

• Import Azure DevOps into FileMaker Pro

  Create reports that integrate Azure DevOps in Filemaker Pro.

• Connect to Databricks from PowerBuilder

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

• Author and Share Power BI Reports on Real-Time Hive

  Use the CData ODBC Driver for Hive to visualize Apache Hive in Power BI Desktop and then upload to the Power BI service.

• Build an OLAP Cube in SSAS from Dropbox

  Establish a connection to Dropbox data from SQL Server Analysis Services, and use the Dropbox Data Provider to build OLAP cubes for use in analytics and reporting.

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

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

• Connect to and Query Google Contacts in QlikView over ODBC

  Create data visualizations with Google Contacts in QlikView.

• Import Real-Time Microsoft Teams in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Microsoft Teams in ColdFusion.

• Build an OLAP Cube in SSAS from ADP

  Establish a connection to ADP data from SQL Server Analysis Services, and use the ADP Data Provider to build OLAP cubes for use in analytics and reporting.

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

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

• Build Apps with Live PostgreSQL Using the Low-Code Development Platform of Mendix

• «
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• 51
• 52
• »