CData Software - Knowledge Base

Recent Articles

• «
• 166
• 167
• 168
• 169
• 170
• 171
• 172
• 173
• 174
• 175
• »

• Configure the CData JDBC Driver for Dynamics 365 in a Connection Pool in Tomcat

  Connect to Microsoft Dynamics 365 from a connection pool in Tomcat.

• Connect to Pipedrive in CloverDX (formerly CloverETL)

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

• Import and Visualize Greenhouse in Power View

  Create data visualizations based on Greenhouse in Excel.

• Automate Oracle HCM Cloud Replication to Azure Synapse

  Use CData Sync to customize and automate Oracle HCM Cloud replication to Azure Synapse.

• Automate Salesforce Replication to Azure Data Lake

  Use CData Sync to customize and automate Salesforce & Force.com replication to Azure Data Lake.

• Connect to Zoho Books in RapidMiner

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

• Connect to LinkedIn Ads in NetBeans

  Connect to LinkedIn Ads in NetBeans with the data source configuration wizard.

• Edit and Search External Dynamics CRM Objects in Salesforce Connect

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

• Build a Singer.io Tap for Snowflake using CData Python Connector

  Integrate Singer.io with Snowflake using CData to access live Snowflake data, streamline ETL workflows, and optimize performance.

• Automated Twilio Replication to Teradata

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

• Validate Spark with QuerySurge

  Access and validate Apache Spark SQL in QuerySurge using the CData JDBC Driver.

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

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

• Visualize Live Spark in the Power BI Service

  Use CData Connect Cloud to connect to live Apache Spark SQL and create custom reports in the Power BI Service through the On-Premises Gateway.

• Connect to Azure Table from Excel & GoogleSheets!

  Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Azure Table Storage, and over 250 other data sources, right inside your Excel and Google spreadsheets!

• Connect to and Query Zoho Inventory in QlikView over ODBC

  Create data visualizations with Zoho Inventory in QlikView.

• Manage Redis in DBArtisan as a JDBC Source

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

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

  Connect to LinkedIn Ads 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.

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

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

• Build Dashboards with NetSuite in DBxtra

  Create dynamic dashboards and perform analytics based on NetSuite CRM & ERP in DBxtra.

• How to create Azure DevOps federated tables in MySQL

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

• Create Greenhouse Reports on JasperReports Server

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

• Natively Connect to Freshdesk in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to Freshdesk. Leverage the native support for ODBC in PHP.

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

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

• Creating SFTP-Connected Applications in Unqork

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

• Integrate Freshdesk in the Pentaho Report Designer

  Publish reports based on Freshdesk in the Pentaho BI tool.

• Connect to Salesforce Pardot in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Connect to SQL Server through External Services in Salesforce

  Use CData Connect Cloud to securely connect Salesforce External Services with SQL Server using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

• Automated Continuous CockroachDB Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable CockroachDB replication to OneLake in Microsoft Fabric.

• Create Reports with Dynamics 365 in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Microsoft Dynamics 365.

• Create Dynamics 365-Connected Applications in Appsmith

  Connect to Dynamics 365 via CData Connect Cloud in Appsmith and create custom business applications with real-time access to Microsoft Dynamics 365.

• Create Apps from Printful in Qlik Sense Cloud

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

• Build MVC Applications with Connectivity to QuickBooks Time

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access QuickBooks Time from an ASP.NET MVC application.

• Create Cassandra-Connected Enterprise Applications in OutSystems

  Use CData Connect Cloud to connect to Cassandra from OutSystems and build custom enterprise apps using live Apache Cassandra.

• Import and Visualize SuiteCRM in Power View

  Create data visualizations based on SuiteCRM in Excel.

• Create Informatica Mappings From/To a JDBC Data Source for Sage 300

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

• Analyze BigQuery in SAP Analytics Cloud

  Use CData Connect Cloud to create an OData API on top of Google BigQuery and visualize Google BigQuery in SAP Analytics Cloud.

• How to connect and process MarkLogic from Azure Databricks

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

• How to import Confluence into Apache Solr

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

• Import Real-Time xBase via JDBC in ColdFusion to Build Applications

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

• Automate Paylocity Replication to Couchbase

  Use CData Sync to Customize and automate Paylocity replication to Couchbase.

• Use the CData Software ODBC Driver for Typeform in MicroStrategy Web

  Connect to Typeform in MicroStrategy Web using the CData Software ODBC Driver for Typeform.

• Analyze Amazon S3 in R via ODBC

  Create data visualizations and use high-performance statistical functions to analyze Amazon S3 in Microsoft R Open.

• Replicate ConstantContact to Multiple Databases via the CData Sync CLI

  Replicate ConstantContact to disparate databases with a single configuration.

• Notice for all Marketo Driver Users Regarding December 2024 Release

  This article serves as a notice to all users regarding the CData Software Marketo connectivity solutions update from December 2024.

• Query Bitbucket as a MySQL Database in Node.js

  Execute MySQL queries against Bitbucket from Node.js.

• Analyze Salesforce in Cognos Analytics

  Use CData Connect Cloud to connect to Salesforce from Cognos Analytics and analyze live Salesforce & Force.com.

• LINQ to QuickBooks Online

  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 QuickBooks Online Data Provider.

• Create a Data Access Object for SQL Server using JDBI

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

• Create SAP Ariba Source-Connected Visualizations in Klipfolio

  Use CData Connect Cloud to connect to SAP Ariba Source from Klipfolio and build custom visualizations using live SAP Ariba Source.

• Excel Spreadsheet Automation on SAP ByDesign with the QUERY Formula

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

• Import and Visualize SAP ByDesign in Power View

  Create data visualizations based on SAP Business ByDesign in Excel.

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

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

• ETL HubDB in Oracle Data Integrator

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

• Access Azure Data Lake Storage from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Azure Data Lake Storage from HeidiSQL.

• Automate Avro Replication to Azure Synapse

  Use CData Sync to customize and automate Apache Avro replication to Azure Synapse.

• Access SendGrid in PHP through Connect Server

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

• How to connect to QuickBooks with Squirrel SQL client

  Connect to QuickBooks Desktop and execute queries in the Squirrel SQL Client.

• How to Access Typeform Using Entity Framework

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

• Connect to and Query SAP ByDesign in QlikView over ODBC

  Create data visualizations with SAP Business ByDesign in QlikView.

• How to Create Power BI Visual Reports with Real-Time Redshift

  Use CData Power BI Connectors to visualize Amazon Redshift in Power BI.

• Automate LDAP Objects Replication to Azure Data Lake

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

• Import Azure DevOps into the Power BI Service for Visualizations

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

• Integrate Real-Time Access to IBM Informix in SAPUI5 MVC Apps

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

• Connect to REST in Google Apps Script via SQL Gateway

  Use the ODBC Driver for REST and the SQL Gateway to access REST from Google Apps Script.

• How to Access MySQL Using Entity Framework

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

• Create Zoho Books-Connected Enterprise Applications in OutSystems

  Use CData Connect Cloud to connect to Zoho Books from OutSystems and build custom enterprise apps using live Zoho Books.

• Connect to Oracle Financials Cloud in Google Apps Script via SQL Gateway

  Use the ODBC Driver for Oracle Financials Cloud and the SQL Gateway to access Oracle Financials Cloud from Google Apps Script.

• Easily Integrate SQL Server in Lazarus Pascal IDE

  Learn how to easily integrate live Microsoft SQL Server in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• Connect to Google Data Catalog in the Denodo Platform

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

• How to Work with Facebook in AWS Glue Jobs Using JDBC

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

• Edit and Search External Square Objects in Salesforce Connect

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

• Integrate Google Spanner with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Google Spanner with External Services.

• Author and Share Power BI Reports on Real-Time MongoDB

  Use the CData ODBC Driver for MongoDB to visualize MongoDB in Power BI Desktop and then upload to the Power BI service.

• Enable the LinkedIn JDBC Driver in KNIME

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

• Build MVC Applications with Connectivity to Invoiced

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Invoiced from an ASP.NET MVC application.

• Automated Continuous SAP HANA XS Advanced Replication to MongoDB

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

• Connect to SAP Ariba Source from PowerBuilder via ADO.NET

  This article demonstrates how to access SAP Ariba Source from Appeon PowerBuilder using the CData ADO.NET Provider for SAP Ariba Source.

• DataBind Controls to SAP ByDesign in C++Builder

  DataBind to SAP Business ByDesign in C++Builder with standard components and controls.

• Automate Harvest Replication to Azure Data Lake

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

• Use the CData ODBC Driver for SAP Ariba Source from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC Driver for SAP Ariba Source to connect to SAP Ariba Source from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SAP Ariba Source in Excel.

• Connect to Splunk in NetBeans

  Connect to Splunk in NetBeans with the data source configuration wizard.

• Query XML in MySQL Workbench

  Create a virtual MySQL database for XML Files in CData Software Connect (or Connect Server) and work with live XML Files in MySQL Workbench.

• Query Oracle Service Cloud in DataGrip

  Create a Data Source for Oracle Service Cloud in DataGrip and use SQL to query live Oracle Service Cloud.

• Replicate Multiple DB2 Accounts via the CData Sync CLI

  Replicate multiple DB2 accounts to one or many databases.

• How to connect and process Neo4J from Azure Databricks

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

• Create a Data Access Object for Google Ads using JDBI

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

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

  Provide connectivity to Zendesk through an SAP BusinessObjects universe.

• Provide OData Services of Quickbase from a WCF Application

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

• Automated Continuous Amazon S3 Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable Amazon S3 replication to Google Cloud SQL.

• How to connect to Salesloft with Squirrel SQL client

  Connect to Salesloft and execute queries in the Squirrel SQL Client.

• How to Work with YouTube Analytics in AWS Glue Jobs Using JDBC

  Connect to YouTube Analytics from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Analyze Aha in SAP Analytics Cloud

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

• How to create Cassandra federated tables in MySQL

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

• Connect to SAP Ariba Procurement from AWS Glue

  Use CData Connect Cloud to gain access to live SAP Ariba Procurement from your AWS Glue jobs.

• Prepare, Blend, and Analyze Bing Search Results in Alteryx Designer (Connect Cloud)

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

• Connect to SharePoint Excel Services in RapidMiner

  Integrate SharePoint Excel Services with standard components and data source configuration wizards in RapidMiner Studio.

• Integrate with Microsoft Exchange using Apache Camel2

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

• Query, Visualize, and Share live Zoho CRM in Redash

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

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

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

• Access Live Yahoo! Ads in Excel 365 Online (Excel for the web)

  Connect to Yahoo! Ads from Excel 365 Online (Excel for the web) with CData Connect Cloud.

• «
• 166
• 167
• 168
• 169
• 170
• 171
• 172
• 173
• 174
• 175
• »