CData Software - Knowledge Base

Recent Articles

• «
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• »

• Replicate BigQuery to Multiple Databases

  Replicate Google BigQuery to disparate databases with a single configuration.

• Automated Continuous Instagram Replication to PostgreSQL

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

• How to use SQLAlchemy ORM to access Google Drive in Python

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

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

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

• Creating Excel-Connected Applications in Unqork

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

• How to use SQLAlchemy ORM to access Jira Service Management in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Atlassian Jira Service Management.

• Connect to Elasticsearch from AWS Glue

  Use CData Connect Cloud to gain access to live Elasticsearch from your AWS Glue jobs.

• Query Exact Online in ColdFusion

  Write standard ColdFusion data access code to connect to Exact Online.

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

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

• How to connect to Instagram from IntelliJ

  Integrate connectivity to Instagram with wizards in IntelliJ.

• Stream Zoho Creator into Apache Kafka Topics

  Access and stream Zoho Creator in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Build Pipelines with Live OneNote in Google Cloud Data Fusion (via CData Connect Cloud)

  Use CData Connect Cloud to connect to OneNote from Google Cloud Data Fusion, enabling the integration of live Microsoft OneNote into the building and management of effective data pipelines.

• Use Dash to Build to Web Apps on SurveyMonkey

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

• Enable the FTP JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with FTP Servers.

• Import Real-Time JDBC-ODBC Bridge in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use JDBC-ODBC Bridge in ColdFusion.

• Automated Continuous Office 365 Replication to Oracle

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

• Analyze Microsoft Exchange in Looker

  Use CData Connect Cloud to connect to Microsoft Exchange from Looker and build custom apps using live Microsoft Exchange.

• Create Reports with Aha in SAP Crystal Reports

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

• Connect to Pipedrive from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time Pipedrive using standard SQL.

• Analyze Azure DevOps in Cognos Analytics

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

• Feed LinkedIn Ads into FineReport

  How to set LinkedIn Ads as a JDBC data source in FineReport.

• How to Connect to Facebook Ads in Using Python: 6 Steps

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

• Use the CData Software JDBC Driver for Active Directory in MicroStrategy Web

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

• How to Use CData Connect to Access Live Google Drive in Power Automate

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

• Automated Continuous BigCommerce Replication to Oracle

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

• Perform Batch Operations with Teradata in Apache NiFi

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

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

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

• Connect to Dynamics 365 in Aqua Data Studio

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

• ETL Greenhouse in Oracle Data Integrator

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

• Import Excel Online into the Power BI Service for Visualizations

  Use CData Connect Cloud to connect to Excel Online and provide access to live Microsoft Excel Online for custom reports in the Power BI Service.

• Operational Reporting on LinkedIn Ads from Spotfire Server

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

• Visualize SAP ByDesign in TIBCO Spotfire through OData

  Integrate SAP Business ByDesign into dashboards in TIBCO Spotfire.

• Manage DB2 in DBArtisan as a JDBC Source

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

• Export Data from SQL Server to Teradata through SSIS

  Easily push SQL Server data to Teradata using the CData SSIS Tasks for Teradata.

• How to Work with Excel Online in ETL Validator JDBC

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

• Automated Continuous SAP HANA XS Advanced Replication to Oracle

  Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to Oracle.

• Import Okta into FileMaker Pro

  Create reports that integrate Okta in Filemaker Pro.

• Connect to Live QuickBooks Online in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to QuickBooks Online in CData Connect Cloud and connect to your QuickBooks Online from PostgreSQL.

• Connect to Unbounce from a Connection Pool in JBoss

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

• How to Visualize Cloudant Data in Python with pandas

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

• Build NetSuite-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live NetSuite CRM & ERP.

• Connect to OneNote in HULFT Integrate

  Connect to OneNote as a JDBC data source in HULFT Integrate

• Publish Crystal Reports on Zendesk

  Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Zendesk.

• Create Apps from SAP HANA in Qlik Sense Cloud

  Use CData Connect Cloud to connect to SAP HANA and build apps from live SAP HANA in Qlik Sense Cloud.

• How to Access Workday Using Entity Framework

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

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

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

• Using AngularJS to Build Dynamic Web Pages with Monday.com

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

• A PostgreSQL Interface for Confluence

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

• How to Connect to & Open Procore in Microsoft Excel

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

• Access Microsoft Project from MySQL in Amazon QuickSight

  Connect to Microsoft Project and build visualizations of Microsoft Project using a MySQL Connection in Amazon QuickSight.

• Working with IBM Informix in LINQPad

  Execute LINQ queries to IBM Informix in LINQPad.

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

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

• Write a Simple Go Application to work with SAS xpt on Linux

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

• Access Live MailChimp in Excel for the Web (Excel 365/Online)

  Connect to MailChimp from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

• Integrate with DB2 using Apache Camel2

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

• Integrate with live Bing Search Results in Jitterbit

  Use CData Connect Cloud to connect to and integrate live Bing Search in Jitterbit.

• Use Dash to Build to Web Apps on Redshift

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

• Import Sage Intacct into the Power BI Service for Visualizations

  Use CData Connect Cloud to connect to Sage Intacct and provide access to live Sage Intacct for custom reports in the Power BI Service.

• Using the CData Software ODBC Driver for Databricks in PyCharm

  Connect to Databricks as an ODBC data source in PyCharm using the CData Software ODBC Driver for Databricks.

• Automated Continuous Sage 50 UK Replication to Snowflake

  Use CData Sync for automated, continuous, customizable Sage 50 UK replication to Snowflake.

• Access Sage 200 from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Sage 200 from HeidiSQL.

• Create Sugar CRM Reports on JasperReports Server

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

• Connect to and Query SharePoint Excel Services in QlikView over ODBC

  Create data visualizations with SharePoint Excel Services in QlikView.

• Connect to Epicor Kinetic as a Linked Server

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

• Create SSAS Tabular Models from Parquet

  How to build a SQL Server Analysis Service Tabular Model from Apache Parquet using CData drivers.

• Build Act CRM-Connected Apps in Bubble

  Use CData Connect Cloud to create an OData feed for Act CRM and create custom apps in Bubble.

• Connect to Shopify in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for Shopify in Airbyte.

• How to pipe PayPal to CSV in PowerShell

  Use standard PowerShell cmdlets to access PayPal tables.

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

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

• Build Automated Workflows with Live Jira in Workato

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

• Establish a Live Connection with Microsoft Project using Tableau Bridge

  The CData ODBC Driver for Microsoft Project enables you to integrate live Microsoft Project into Tableau Cloud dashboards using the Tableau Bridge.

• How to connect to PayPal from IntelliJ

  Integrate connectivity to PayPal with wizards in IntelliJ.

• Connect to Epicor Kinetic from PowerBuilder

  This article demonstrates how to access Epicor Kinetic from PowerBuilder using the Epicor Kinetic JDBC Driver.

• Automated Continuous Xero Replication to IBM DB2

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

• Integrate Microsoft Exchange with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Microsoft Exchange with External Services.

• Access Live API in Google Sheets

  Use CData Connect Cloud to gain access to live API from your Google Sheets.

• Stream Bullhorn CRM into Apache Kafka Topics

  Access and stream Bullhorn CRM in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Replicate Clio from PowerShell

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

• Connect to Microsoft Exchange in JRuby

  Create a simple JRuby app with access to live Microsoft Exchange.

• Validate Wave Financial with QuerySurge

  Access and validate Wave Financial in QuerySurge using the CData JDBC Driver.

• Operational Reporting on MariaDB from Spotfire Server

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

• Access REST as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access REST from your Oracle system.

• Build Dashboards with Shippo in DBxtra

  Create dynamic dashboards and perform analytics based on Shippo in DBxtra.

• Visualize SQL Server in TIBCO Spotfire through ODBC

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

• Query WordPress as a SQL Server Database in Node.js

  Execute SQL Server queries against WordPress from Node.js.

• Write a Simple Go Application to work with Blackbaud FE NXT on Linux

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

• LINQ to Authorize.Net

  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 Authorize.Net Data Provider.

• A PostgreSQL Interface for Marketo

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

• Configure the CData JDBC Driver for Amazon Marketplace in a Connection Pool in Tomcat

  Connect to Amazon Marketplace from a connection pool in Tomcat.

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

• SharePoint Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on SharePoint facts in real time.

• Natively Connect to Twitter Ads in PHP

  The CData ODBC driver for Twitter Ads enables you to create PHP applications with connectivity to Twitter Ads. Leverage the native support for ODBC in PHP.

• Build a Simple VCL Application for SAP SuccessFactors

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

• How to Work with SAP HANA XS Advanced in ETL Validator JDBC

  Connect to SAP HANA XS Advanced from ETL Validator jobs using the CData Software JDBC Driver.

• How to integrate Kafka with Apache Airflow

  Access and process Apache Kafka in Apache Airflow using the CData JDBC Driver.

• Replicate SendGrid to Multiple Databases

  Replicate SendGrid to disparate databases with a single configuration.

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

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

• Create Dynamic Elasticsearch Grids Using the Infragistics XamDataGrid

  Learn how you can connect Elasticsearch to Infragistics XamDataGrid to build dynamic grids.

• Automated Continuous Printify Replication to Oracle

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

• Connect to WordPress from a Connection Pool in JBoss

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

• «
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• »