CData Software - Knowledge Base

Recent Articles

• «
• 208
• 209
• 210
• 211
• 212
• 213
• 214
• 215
• 216
• 217
• »

• Query Calendly through ODBC in Node.js

  Use node-odbc to execute SQL queries against Calendly from Node.js.

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

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

• Back Up Amazon S3 to SQL Server through SSIS

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

• Stream Oracle Eloqua into Apache Kafka Topics

  Access and stream Oracle Eloqua in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Analyze Adobe Analytics in Looker

  Use CData Connect Cloud to connect to Adobe Analytics from Looker and build custom apps using live Adobe Analytics.

• How to Use a Microsoft Access Database to Update Presto in Real Time

  Update Presto data by creating a linked table in Microsoft Access with the CData Presto ODBC Driver.

• A PostgreSQL Interface for Quickbase

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

• Build Automated Workflows with Live Google Campaign Manager 360 in Workato

  Use CData Connect Cloud to connect to live Google Campaign Manager 360 and build automated workflows in Workato.

• Visualize Live Microsoft Planner of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live Microsoft Planner using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• Visualize Pinterest in Tableau

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

• Create a Data Access Object for Azure DevOps using JDBI

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

• Automate Teradata Replication to SAP HANA

  Use CData Sync to customize and automate Teradata replication to SAP HANA.

• Load Active Directory to a Database Using Embulk

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

• How to Visualize Dropbox Data in Python with pandas

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

• How to Access Google Calendar Using Entity Framework

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

• A PostgreSQL Interface for Amazon Athena

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

• Connect to Oracle from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live Oracle Database from Filemaker Pro on Mac.

• Build Twitter Ads-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to Twitter Ads from Zoho Analytics and import live Twitter Ads.

• Automated Continuous LinkedIn Ads Replication to Vertica

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

• Provide OData Services of EventBrite from a WCF Application

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

• Create Informatica Mappings From/To a JDBC Data Source for Authorize.Net

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

• Access Airtable in PHP through Connect Server

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

• Provide OData Services of Airtable from a WCF Application

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

• Build YouTube Analytics-Connected Apps in Choreo

  Use CData Connect Cloud to connect to YouTube Analytics from Choreo and build custom apps using live YouTube Analytics.

• Connect to Adobe Commerce from Crystal Reports

  Use CData Connect Cloud to connect to and report on live Adobe Commerce from Crystal Reports.

• How to create Twilio federated tables in MySQL

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

• How to connect and process SQL Server from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live SQL Server

• Import Real-Time Epicor Kinetic in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Epicor Kinetic in ColdFusion.

• Analyze SendGrid in Cognos Analytics

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

• A PostgreSQL Interface for LDAP Objects

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

• Connect to eBay in RunMyProcess through Connect Cloud

  Use CData Connect Cloud to create on OData API for eBay and connect to eBay in Akorbi Digital RunMyProcess.

• How to import Oracle into Apache Solr

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

• Export Data from SQL Server to Azure Active Directory through SSIS

  Easily push SQL Server data to Azure Active Directory using the CData SSIS Tasks for Azure Active Directory.

• Automated Continuous Oracle Eloqua Replication to SingleStore

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

• Import Cloudant into FileMaker Pro

  Create reports that integrate IBM Cloudant in Filemaker Pro.

• Integrate with HubSpot in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live HubSpot in SnapLogic.

• Connect to Google Spanner in Airbyte ELT Pipelines

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

• Stream Salesforce into Apache Kafka Topics

  Access and stream Salesforce & Force.com in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Creating MarkLogic-Connected Applications in Unqork

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

• Choosing the Best Method to Connect Google Campaign Manager 360 to SQL Server: 5 Options Explained

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

• Connect to DB2 in RapidMiner

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

• Automated Continuous IBM Informix Replication to SQL Server

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

• Automated Continuous DB2 Replication to Amazon S3

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

• Automated Continuous SAP Hybris C4C Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to IBM DB2.

• Bridge Oracle Eloqua Connectivity with Apache NiFi

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

• Design BIRT Reports on Cassandra

  Provide current Apache Cassandra to your embedded analytics.

• Connect to IBM Informix in Aqua Data Studio

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

• Connect to Square from a Connection Pool in WebLogic

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

• Integrate Live Impala into Custom Business Apps Built in Power Apps

  Use CData Connect Cloud to connect to Apache Impala and integrate live Apache Impala into apps built in Microsoft Power Apps.

• Establish a Live Connection with SFTP using Tableau Bridge

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

• Automated Continuous FHIR Replication to Databricks

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

• Import Real-Time MySQL in ColdFusion to Build Applications

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

• Add SurveyMonkey to Informatica Enterprise Data Catalog

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

• How to Access Blackbaud FE NXT Using Entity Framework

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

• Import Real-Time Twitter in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Twitter in ColdFusion.

• Connect to Oracle Sales from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live Oracle Sales from Filemaker Pro on Mac.

• Publish Crystal Reports on Databricks

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

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

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

• Access Veeva in PHP through Connect Server

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

• Connect to SAP Netweaver Gateway in DBArtisan

  Use wizards in DBArtisan to configure SAP Netweaver Gateway as a data source.

• Publish Salesforce Marketing-Connected Dashboards in Tableau Server

  Use CData JDBC drivers and Tableau Server to visualize live Salesforce Marketing Cloud.

• Connect to SAP SuccessFactors from PowerBuilder

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

• LINQ to SharePoint Excel Services

  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 SharePoint Excel Services Data Provider.

• How to connect PolyBase to Microsoft Planner

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

• Build an OLAP Cube in SSAS from Todoist

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

• Create Data Visualizations Based On Zendesk in Mode

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

• Publish Microsoft Planner-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Microsoft Planner.

• Publish Reports with Avalara AvaTax in SAP Crystal Reports

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

• Zoho Inventory Reporting in OBIEE with the Zoho Inventory JDBC Driver

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

• Query, Visualize, and Share live GraphQL in Redash

  Use CData Connect Cloud to connect to live GraphQL in Redash for querying, visualizing, and sharing.

• Use CData Connect Cloud to Access Oracle SCM in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live Oracle SCM in the Power Pivot business intelligence tool.

• Bidirectional Access to Veeva from FileMaker Pro

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

• Automated Continuous Marketo Replication to SQLite

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

• Create Data Visualizations in Cognos BI with Typeform

  Access Typeform as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

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

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

• Working with Kafka in LINQPad

  Execute LINQ queries to Apache Kafka in LINQPad.

• Build Zoho CRM-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to Zoho CRM from Zoho Analytics and import live Zoho CRM.

• Access Snowflake from MySQL in PHP

  Connect to Snowflake through the standard MySQL libraries in PHP.

• Using the CData Software ODBC Driver for Xero in PyCharm

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

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

  Provide connectivity to RSS Feeds through an SAP BusinessObjects universe.

• Automate SAP Ariba Procurement Replication to Azure Data Lake

  Use CData Sync to customize and automate SAP Ariba Procurement replication to Azure Data Lake.

• Connect to and Visualize Live Google Sheets in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Sheets.

• Query Azure Active Directory as a SQL Server Database in Node.js

  Execute SQL Server queries against Azure Active Directory from Node.js.

• Create Snowflake-Connected Visualizations in Klipfolio

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

• Connect to Pinterest in CloverDX (formerly CloverETL)

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

• Import Real-Time MarkLogic in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use MarkLogic in ColdFusion.

• Automated Continuous ShipStation Replication to Oracle

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

• Design BIRT Reports on SQL Analysis Services

  Provide current SQL Analysis Services to your embedded analytics.

• Analyze Google Search Results in Looker

  Use CData Connect Cloud to connect to Google Search Results from Looker and build custom apps using live Google Search.

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

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

• Replicate HDFS to Multiple Databases

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

• Visualize Live RSS Feeds of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live RSS Feeds using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• Enable the IBM Informix JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with IBM Informix.

• Integrate Salesforce Pardot in Your Informatica Cloud Instance

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

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

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

• Access Live Avalara AvaTax in AWS Lambda (with IntelliJ IDEA)

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

• Automated Continuous Excel Replication to SQLite

  Use CData Sync for automated, continuous, customizable Excel replication to SQLite.

• Stream FHIR into Apache Kafka Topics

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

• Create Dynamic Impala Grids Using the Infragistics XamDataGrid

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

• Automated Continuous Cassandra Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable Cassandra replication to Google BigQuery.

• «
• 208
• 209
• 210
• 211
• 212
• 213
• 214
• 215
• 216
• 217
• »