CData Software - Knowledge Base

Recent Articles

• «
• 123
• 124
• 125
• 126
• 127
• 128
• 129
• 130
• 131
• 132
• »

• Connect to Salesforce from a Connection Pool in JBoss

  Integrate Salesforce & Force.com into Java servlets: Use the Management Console in JBoss to install the Salesforce JDBC Driver.

• Automated Continuous SAS xpt Replication to Local Delimited Files

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

• How to Access Wave Financial Using Entity Framework

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

• Natively Connect to AlloyDB in PHP

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

• Integrate with live Sage Cloud Accounting in Jitterbit

  Use CData Connect Cloud to connect to and integrate live Sage Business Cloud Accounting in Jitterbit.

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

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

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

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

• Creating eBay-Connected Applications in Unqork

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

• Build Semantic Layer Views for YouTube Analytics in APOS Live Data Gateway

  Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for YouTube Analytics.

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

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

• DataBind Wijmo Grid to Azure DevOps

  Provide real-time Azure DevOps to interactive controls.

• Automate Google Ad Manager Replication to Azure Synapse

  Use CData Sync to customize and automate Google Ad Manager replication to Azure Synapse.

• Automate Drip Replication to SAP HANA

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

• Use JayDeBeApi to access SingleStore in Python

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

• Load ActiveCampaign to a Database Using Embulk

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

• Create Informatica Mappings From/To a JDBC Data Source for Oracle Service Cloud

  Create Oracle Service Cloud data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• A PostgreSQL Interface for SAP Hybris C4C

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

• How to connect Amazon QuickSight to Quickbase

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

• Build an OLAP Cube in SSAS from SAS xpt

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

• How to connect to Power BI XMLA from MS Excel on Mac OS X

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

• Analyze Instagram in Cognos Analytics

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

• Publish Zenefits-Connected Dashboards in Tableau Server

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

• Automated Continuous FHIR Replication to Local Delimited Files

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

• Perform Batch Operations with Salesloft in Apache NiFi

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

• Connect to Microsoft Planner from HeidiSQL

  Use CData Connect Cloud to connect to and query live Microsoft Planner from HeidiSQL.

• Model, Search, and Visualize Live Stripe in ThoughtSpot

  Use CData Connect Cloud to connect to live Stripe for modeling, searching, and visualizing.

• Connect to Greenplum from Crystal Reports

  Use CData Connect Cloud to connect to and report on live Pivotal GreenPlum from Crystal Reports.

• Connect to SAP ByDesign in CloverDX (formerly CloverETL)

  Transfer SAP Business ByDesign using the visual workflow in the CloverDX data integration tool.

• Automated Continuous Google Campaign Manager 360 Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to Apache Kafka.

• How to Work with Google Ads in ETL Validator JDBC

  Connect to Google Ads from ETL Validator jobs using the CData Software JDBC Driver.

• How to use SQLAlchemy ORM to access Oracle Sales in Python

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

• Perform Batch Operations with SingleStore in Apache NiFi

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

• Natively Connect to Amazon S3 in PHP

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

• Create Datasets from ShipStation in Domo Workbench and Build Visualizations of ShipStation in Domo

  Use the CData Software ODBC Driver for ShipStation to create datasets from ShipStation in Domo Workbench and then build visualizations in the Domo service.

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

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

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

  Create an ODBC connection to BigQuery in Informatica and browse and transfer Google BigQuery.

• Connect to Hive in JRuby

  Create a simple JRuby app with access to live Apache Hive.

• How to Connect DBeaver to SharePoint via a JDBC Driver

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

• Use CData Connect Cloud to Access ActiveCampaign in Microsoft Power Pivot

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

• A PostgreSQL Interface for Oracle

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

• Connect to Google Sheets through External Services in Salesforce

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

• How to Connect the Power BI Service to Google Cloud Storage: Complete Guide

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

• Build Dashboards with MailChimp in DBxtra

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

• Query SuiteCRM in ColdFusion

  Write standard ColdFusion data access code to connect to SuiteCRM.

• Automated Continuous Confluence Replication to IBM DB2

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

• Query Microsoft OneDrive in DataGrip

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

• Connect to Cassandra in RunMyProcess through Connect Cloud

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

• Stream Shopify into Apache Kafka Topics

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

• Connect to Azure Analysis Services from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live Azure Analysis Services from Filemaker Pro on Mac.

• Connect to Hive in HULFT Integrate

  Connect to Hive as a JDBC data source in HULFT Integrate

• How to connect to Reckon Accounts Hosted from Spring Boot

  Connect to Reckon Accounts Hosted in a Spring Boot Application using CData JDBC Reckon Accounts Hosted Driver

• Salesloft Reporting and Star Schemas in OBIEE

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

• Use the CData ODBC Driver for Harvest in SAS JMP

  You can use the CData ODBC Driver to integrate Harvest into the statistical analysis tools available in SAS JMP. This article shows how to use Harvest in the Graph Builder and Query Builder.

• Establish a Live Connection with SAP Ariba Source using Tableau Bridge

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

• Access Live LinkedIn in Excel 365 Online (Excel for the web)

  Connect to LinkedIn from Excel 365 Online (Excel for the web) with CData Connect Cloud.

• Automated Continuous Excel Replication to SingleStore

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

• Load Dynamics CRM to a Database Using Embulk

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

• Connect to SAS xpt as a Linked Server

  Use the SQL Gateway and the ODBC Driver to set up a linked server for SAS XPORT.

• Connect to Epicor Kinetic from AWS Glue

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

• Publish Harvest-Connected Dashboards in Tableau Server

  Use CData JDBC drivers and Tableau Server to visualize live Harvest.

• Create GitHub Dataflows on PowerBI.com

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

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

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

• Publish Reports with GraphQL in SAP Crystal Reports

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

• Access Zoho Creator from MySQL in PHP

  Connect to Zoho Creator through the standard MySQL libraries in PHP.

• Create Oracle Service Cloud-Connected Nintex Workflows

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

• Excel Spreadsheet Automation with the QUERY Formula

  Pull data, automate spreadsheets, and more with the QUERY formula.

• Build WooCommerce-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to WooCommerce and build web apps with connectivity to live WooCommerce.

• Connect to Google Spanner from a Connection Pool in JBoss

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

• Connect to SAP Concur as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live SAP Concur.

• How to connect and process Zoho Creator from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Zoho Creator

• Use Dash to Build to Web Apps on Cassandra

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

• Aha Reporting in OBIEE with the Aha JDBC Driver

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

• Automated Continuous Office 365 Replication to Microsoft Access

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

• How to connect to LinkedIn Ads with Squirrel SQL client

  Connect to LinkedIn Ads and execute queries in the Squirrel SQL Client.

• Export Data from SQL Server to Highrise through SSIS

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

• How to integrate Metabase with Cloudant

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

• Visualize Live HubDB of Power BI Report Builder in Power BI Service

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

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

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

• Connect to and Visualize Live Odoo in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Odoo ERP.

• Connect to BambooHR in HULFT Integrate

  Connect to BambooHR as a JDBC data source in HULFT Integrate

• Connect to Sugar CRM from a Connection Pool in WebLogic

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

• How to Import Google Campaign Manager 360 into SQL Server using SSIS

  Easily back up Google Campaign Manager 360 to SQL Server using the SSIS components for Google Campaign Manager 360.

• Automated Continuous Klipfolio Replication to MySQL

  Use CData Sync for automated, continuous, customizable Klipfolio replication to MySQL.

• How to create an RPA flow for Excel Online in UiPath Studio

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

• Export Data from SQL Server to Dynamics GP through SSIS

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

• Create Unbounce Reports on JasperReports Server

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

• Create Reckon-Connected Visualizations in Klipfolio

  Use CData Software Connect Server to connect to Reckon from Klipfolio and build custom visualizations using live Reckon.

• How to Connect to Google Campaign Manager 360 in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Google Campaign Manager 360. Leverage the pyodbc module for ODBC in Python.

• Visualize SAS Data Sets in TIBCO Spotfire through OData

  Integrate SAS Data Sets into dashboards in TIBCO Spotfire.

• Automated BigQuery Replication to Teradata

  Use CData Sync to Customize and automate Google BigQuery replication to Teradata.

• How to Access Kintone Using Entity Framework

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

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

  Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for FHIR.

• Automated Continuous HubSpot Replication to Apache Cassandra

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

• Connect to Jira from PowerBuilder

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

• How to integrate Zendesk with Apache Airflow

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

• Connect to SQL Analysis Services in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Connect to HubSpot in DBArtisan

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

• Using the CData Software ODBC Driver for PostgreSQL in PyCharm

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

• Automated Continuous Microsoft Project Replication to SQLite

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

• Connect to REST as a Linked Server

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

• «
• 123
• 124
• 125
• 126
• 127
• 128
• 129
• 130
• 131
• 132
• »