CData Software - Knowledge Base

Recent Articles

• «
• 240
• 241
• 242
• 243
• 244
• 245
• 246
• 247
• 248
• 249
• »

• Work with Salesforce Pardot in FoxPro

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

• Export Data from SQL Server to JSON through SSIS

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

• How to work with Calendly in Apache Spark using SQL

  Access and process Calendly in Apache Spark using the CData Software JDBC Driver.

• Host the API Server on Azure

  Host the CData API Server in Microsoft Windows Azure to create always-on OData entrypoints for your data.

• How to Build Dynamic React Apps with MySQL

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

• Access YouTube Analytics in PHP through Connect Server

  Connect to YouTube Analytics through the standard SQL Server libraries in PHP.

• How to Work with SAP BusinessObjects BI in ETL Validator JDBC

  Connect to SAP BusinessObjects BI from ETL Validator jobs using the CData Software JDBC Driver.

• Connect to Gmail from Filemaker Pro (Mac)

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

• Create Dynamic REST Grids Using the Infragistics XamDataGrid

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

• Build an OLAP Cube in SSAS from Exact Online

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

• Automated Continuous Adobe Commerce Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable Adobe Commerce replication to Apache Cassandra.

• Visualize Live Google Directory in Power BI (via CData Connect Cloud)

  Use the CData Power BI Connector and CData Connect Cloud to integrate live Google Directory into custom reports in Power BI.

• Integrate Live Sybase IQ into Custom Business Apps Built in Power Apps

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

• Import Exact Online Using Azure Data Factory

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

• Integrate with GitHub in JReport Designer

  Create charts and reports based on GitHub in JReport Designer.

• Automated Continuous Smartsheet Replication to Microsoft Access

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

• Import Real-Time HCL Domino in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use HCL Domino in ColdFusion.

• Process & Analyze Zendesk in Databricks (AWS)

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

• Connect to QuickBooks Online in RazorSQL

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

• Publish TigerGraph-Connected Dashboards in Tableau Server

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

• How to connect to Bing Ads from Spring Boot

  Connect to Bing Ads in a Spring Boot Application using CData JDBC Bing Ads Driver

• Load Azure Synapse to a Database Using Embulk

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

• Enable the Google Calendar JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Google Calendar.

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

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

• Design BIRT Reports on Bullhorn CRM

  Provide current Bullhorn CRM to your embedded analytics.

• How to Connect DBeaver to Dynamics GP via a JDBC Driver

  Manage Microsoft Dynamics GP with visual tools in DBeaver like the query browser.

• Import SAP HANA Using Azure Data Factory

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

• How to Connect to & Open Adobe Commerce in Microsoft Excel

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

• A PostgreSQL Interface for Unbounce

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

• Connect to Acumatica from a Connection Pool in WebLogic

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

• How to connect to Basecamp from IntelliJ

  Integrate connectivity to Basecamp with wizards in IntelliJ.

• How to work with Azure Data Catalog in Apache Spark using SQL

  Access and process Azure Data Catalog in Apache Spark using the CData Software JDBC Driver.

• Visualize Azure Active Directory in Tableau

  The CData ODBC driver for Azure Active Directory enables you integrate Azure Active Directory into Tableau dashboards.

• Connect to and Query Sage 200 in QlikView over ODBC

  Create data visualizations with Sage 200 in QlikView.

• Connect to Zuora in JRuby

  Create a simple JRuby app with access to live Zuora.

• Create Stripe Dashboards in Bold BI

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

• Create Google Sheets-Connected Nintex Workflows

  Use CData Connect Cloud to connect to Google Sheets from Nintex Workflow Cloud and build custom workflows using live Google Sheets.

• Create Couchbase Dataflows on PowerBI.com

  Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.

• How to Work with Raisers Edge NXT in AWS Glue Jobs Using JDBC

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

• Enable the Power BI XMLA JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Power BI XMLA.

• Access Live Google Analytics in AWS Lambda

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

• Create Odoo-Connected Visualizations in Klipfolio

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

• Integrate Real-Time Access to Veeva in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Veeva Vault in real time.

• Automate Jira Replication to Azure Synapse

  Use CData Sync to customize and automate Atlassian Jira replication to Azure Synapse.

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

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

• Connect to PayPal in Ruby

  Connect to PayPal in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Query Klipfolio in ColdFusion

  Write standard ColdFusion data access code to connect to Klipfolio.

• Write a Simple Go Application to work with Amazon Marketplace on Linux

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

• Analyze Microsoft Project with Power Pivot

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

• Operational Reporting on Oracle Service Cloud from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Oracle Service Cloud.

• Prepare, Blend, and Analyze Google Data Catalog in Alteryx Designer

  Build workflows to access live Google Data Catalog for self-service data analytics.

• Create Twilio-Connected Visualizations in Klipfolio

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

• Access Live Zendesk in Excel (Desktop)

  Use CData Connect Cloud to gain access to live Zendesk from your Excel spreadsheets.

• Build Instagram-Connected Web Apps with Axios and CData Connect Cloud

  Use CData Connect Cloud to connect to live Instagram and build Instagram-connected web apps with Axios.

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

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

• Automated Continuous Certinia Replication to Google BigQuery

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

• Automate Basecamp Replication to Azure Data Lake

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

• Create a Data Access Object for Blackbaud FE NXT using JDBI

  A brief overview of creating a SQL Object API for Blackbaud FE NXT in JDBI.

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

• «
• 240
• 241
• 242
• 243
• 244
• 245
• 246
• 247
• 248
• 249
• »