CData Software - Knowledge Base

Recent Articles

• «
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• »

• Automated Continuous Excel Replication to Amazon Redshift

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

• Use the CData Software JDBC Driver for Azure DevOps in MicroStrategy Web

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

• Load Dropbox to a Database Using Embulk

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

• Stream Highrise into Apache Kafka Topics

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

• Create Reports with Twitter Ads in SAP Crystal Reports

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

• Connect to Salesforce in HULFT Integrate

  Connect to Salesforce as a JDBC data source in HULFT Integrate

• Load Xero to a Database Using Embulk

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

• Load Airtable to a Database Using Embulk

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

• Connect to HDFS in RapidMiner

  Integrate Apache HDFS with standard components and data source configuration wizards in RapidMiner Studio.

• Write a Simple Go Application to work with Email on Linux

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

• Perform Batch Operations with SAP Business One in Apache NiFi

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

• Build a Simple VCL Application for SurveyMonkey

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

• Connect to SurveyMonkey from Filemaker Pro (Mac)

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

• Automated ActiveCampaign Replication to Teradata

  Use CData Sync to Customize and automate ActiveCampaign replication to Teradata.

• Build Zoho Inventory-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Zoho Inventory.

• Query ShipStation in ColdFusion

  Write standard ColdFusion data access code to connect to ShipStation.

• Klipfolio Reporting and Star Schemas in OBIEE

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

• How to load Sage Intacct data into Elasticsearch via Logstash

  Introducing a simple method to load Sage Intacct data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

• Import Act-On into the Power BI Service for Visualizations

  Use CData Connect Cloud to connect to Act-On and provide access to live Act-On for custom reports in the Power BI Service.

• Back Up Oracle SCM to SQL Server through SSIS

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

• Integrate SAS Data Sets in the Pentaho Report Designer

  Publish reports based on SAS Data Sets in the Pentaho BI tool.

• Connect to FHIR in DBeaver

  Use the CData ODBC Driver to connect to FHIR in DBeaver.

• How to Import Cloudant into SQL Server using SSIS

  Easily back up IBM Cloudant to SQL Server using the SSIS components for Cloudant.

• Connect to Amazon Marketplace as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live Amazon Marketplace.

• Connect to Slack in JRuby

  Create a simple JRuby app with access to live Slack.

• Connect to Oracle in RazorSQL

  Connect to Oracle from wizards and query Oracle Database from the GUI in the RazorSQL database management tool.

• Visualize Salesloft in Sisense

  Create an ElastiCube in Sisense app with access to Salesloft.

• Feed Oracle Service Cloud into FineReport

  How to set Oracle Service Cloud as a JDBC data source in FineReport.

• How to connect to Google Cloud Storage from IntelliJ

  Integrate connectivity to Google Cloud Storage with wizards in IntelliJ.

• Create Reports with Authorize.Net in SAP Crystal Reports

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

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

  Connect to Cvent 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 Azure Table-Connected Apps in Choreo

  Use CData Connect Cloud to connect to Azure Table from Choreo and build custom apps using live Azure Table Storage.

• Analyze Sybase IQ in SAP Analytics Cloud

  Use the CData Connect Server to create an OData API on top of Sybase IQ and visualize Sybase IQ in SAP Analytics Cloud.

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

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

• Create Reports with SAS xpt in SAP Crystal Reports

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

• Automated Continuous Clio Replication to SingleStore

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

• Build an OLAP Cube in SSAS from MySQL

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

• Automate Adobe Commerce Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access Adobe Commerce from PowerShell? This article demonstrates how to utilize the Adobe Commerce Cmdlets for tasks like connecting to Adobe Commerce, automating operations, downloading data, and more.

• Operational Reporting on Zuora from Spotfire Server

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

• How to load Microsoft Dataverse data into Elasticsearch via Logstash

  Introducing a simple method to load Microsoft Dataverse data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

• Use JayDeBeApi to access Zoho Creator in Python

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

• Use the CData Software JDBC Driver for Dynamics NAV in MicroStrategy

  Connect to Microsoft Dynamics NAV in MicroStrategy Developer using the CData Software JDBC Driver for Dynamics NAV.

• Create a Data Access Object for Coinbase using JDBI

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

• DataBind Controls to Jira Assets in Delphi

  DataBind to Jira Assets in Delphi with standard data access components and controls.

• Import Real-Time PostgreSQL in ColdFusion to Build Applications

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

• Automated Continuous Vertica Replication to Apache Cassandra

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

• How to publish and share SQL Server dashboards with Tableau Server

  The CData ODBC driver for SQL Server enables you integrate Microsoft SQL Server into Tableau dashboards.

• Automate Facebook Ads Replication to Couchbase

  Use CData Sync to Customize and automate Facebook Ads replication to Couchbase.

• Access Bing Ads 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 Bing Ads.

• Automated Continuous Dynamics 365 Business Central Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to PostgreSQL.

• Connect to Printify in the Denodo Platform

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

• Automate QuickBooks Replication to Couchbase

  Use CData Sync to Customize and automate QuickBooks Desktop replication to Couchbase.

• How to Build Dynamic React Apps with Exact Online

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

• Create Apps from eBay Analytics in Qlik Sense Cloud

  Use the CData Connect Server to create an OData API for eBay Analytics and build apps from live eBay Analytics in Qlik Sense Cloud.

• Connect to LinkedIn Ads from a Connection Pool in WebLogic

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

• Connect to Harvest in RapidMiner

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

• Edit and Search External BigCommerce Objects in Salesforce Connect

  Use CData Connect Cloud to securely provide OData feeds of BigCommerce to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create BigCommerce objects that you can access from apps and the dashboard.

• Analyze Presto in Infragistics Reveal

  Use CData Connect Cloud to create on OData API on top of Presto and visualize live Presto in Infragistics Reveal.

• Analyze Dynamics 365 with Power Pivot

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

• How to connect to SingleStore in DBVisualizer

  Integrate SingleStore with visual data analysis tools and data connection wizards in DBVisualizer

• Create a Data Access Object for Couchbase using JDBI

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

• Query Exact Online as a SQL Server Database in Node.js

  Execute SQL Server queries against Exact Online from Node.js.

• Visualize HubSpot in TIBCO Spotfire through OData

  Integrate HubSpot into dashboards in TIBCO Spotfire.

• Integrate Stripe into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Stripe and integrate live Stripe into your Power Automate tasks.

• Connect to Azure Active Directory from a Connection Pool in Jetty

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

• How to connect to Google Data Catalog with Squirrel SQL client

  Connect to Google Data Catalog and execute queries in the Squirrel SQL Client.

• How to work with DB2 in Apache Spark using SQL

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

• Access Typeform from MySQL in PHP

  Connect to Typeform through the standard MySQL libraries in PHP.

• DataBind Controls to Twitter in Delphi

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

• Import Real-Time Act CRM in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Act CRM in ColdFusion.

• Configure the CData JDBC Driver for Oracle Sales in a Connection Pool in Tomcat

  Connect to Oracle Sales from a connection pool in Tomcat.

• Connect to Zoom in Jaspersoft Studio

  Execute SQL to remote Zoom in Jaspersoft Studio.

• Connect to Kintone in DBArtisan

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

• How to connect to Avro from Google Apps Script

  Use CData Software Connect Server to access Apache Avro in Google Apps Script.

• Using the CData Software ODBC Driver for Google Directory in PyCharm

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

• Visualize Quickbase in Tableau

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

• Build AlloyDB-Connected Dashboards Using Zoho Analytics

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

• Connect to Outreach.io from Blazor Apps

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

• Work with Cvent in FoxPro

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

• Automated Continuous Dynamics NAV Replication to PostgreSQL

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

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

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

• Connect to Facebook Ads as an External Data Source using PolyBase

  Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live Facebook Ads.

• Automated Continuous Trello Replication to Snowflake

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

• Automated Continuous Microsoft Planner Replication to IBM DB2

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

• Use the CData SSIS Components to Insert New or Update Existing Google Drive Records from SQL Server

  Easily push SQL Server data to Google Drive using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Google Drive or update existing records with data from a SQL Server database.

• Import and Visualize Power BI XMLA in Power View

  Create data visualizations based on Power BI XMLA in Excel.

• Build an OLAP Cube in SSAS from Klaviyo

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

• Working with Neo4J in LINQPad

  Execute LINQ queries to Neo4J in LINQPad.

• Automated Continuous Zuora Replication to SingleStore

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

• How to Query Greenplum in MySQL Workbench

  Execute MySQL queries against live Pivotal GreenPlum from MySQL Workbench.

• Design BIRT Reports on Pinterest

  Provide current Pinterest to your embedded analytics.

• Publish SAP HANA-Connected Dashboards in Tableau Server

  Use CData JDBC drivers and Tableau Server to visualize live SAP HANA.

• Automated Continuous Amazon Marketplace Replication to Oracle

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

• Connect to ActiveCampaign as an External Data Source using PolyBase

  Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live ActiveCampaign.

• Query MongoDB in DataGrip

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

• Prepare, Blend, and Analyze Slack in Alteryx Designer

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

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

  Provide connectivity to Azure DevOps through an SAP BusinessObjects universe.

• Query Sage 300 as a MySQL Database in Node.js

  Execute MySQL queries against Sage 300 from Node.js.

• Design BIRT Reports on SAP Hybris C4C

  Provide current SAP Hybris C4C to your embedded analytics.

• Prepare, Blend, and Analyze Zuora in Alteryx Designer

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

• «
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• »