CData Software - Knowledge Base
Recent Articles
-
Integrate Oracle SCM into Automated Tasks with Power Automate
Use CData Connect AI to connect to Oracle SCM and integrate live Oracle SCM into your Power Automate tasks.
-
Integrate with Live Dynamics 365 Business Central in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Dynamics 365 Business Central from the MuleSoft Anypoint Platform to integrate live Dynamics 365 Business Central into custom reports and dashboards.
-
How to integrate Metabase with Jira
Use CData Connect AI to connect to live Atlassian Jira and create an interactive dashboard in Metabase from Atlassian Jira.
-
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.
-
Migrating data from SAP to Google BigQuery using CData SSIS Components.
Easily push SAP ERP/NetWeaver to Google BigQuery using the CData SSIS Tasks for SAP and Google BigQuery.
-
Visualize Facebook Ads from Tableau
Use the Tableau Desktop business intelligence tool to connect to Facebook Ads.
-
Automated Continuous DB2 Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable DB2 replication to delimited files (CSV/TSV).
-
Import Impala into the Power BI Service for Visualizations
Use CData Connect AI to connect to Impala and provide access to live Apache Impala for custom reports in the Power BI Service.
-
Automated Continuous Sugar CRM Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Sugar CRM replication to Apache Cassandra.
-
Create Informatica Mappings From/To an ODBC Data Source for Box
Create an ODBC connection to Box in Informatica and browse and transfer Box.
-
Extract, Transform, and Load Xero in Informatica PowerCenter
Create a simple Workflow for Xero Accounting in Informatica PowerCenter.
-
How to Query SFTP in MySQL Workbench
Execute MySQL queries against live SFTP from MySQL Workbench.
-
Create Informatica Mappings From/To a JDBC Data Source for SAS Data Sets
Create SAS Data Sets data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Query LinkedIn Ads in DataGrip
Create a Data Source for LinkedIn Ads in DataGrip and use SQL to query live LinkedIn Ads.
-
Replicate HDFS to Multiple Databases
Replicate Apache HDFS to disparate databases with a point-and-click configuration.
-
Use ChatGPT to Talk to Your Shopify via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Shopify for you.
-
Analyze Certinia in R via JDBC
Use standard R functions and the development environment of your choice to analyze Certinia with the CData JDBC Driver for Certinia.
-
Access Live Facebook in Excel 365 Online (Excel for the web)
Connect to Facebook from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Replicate Amazon Athena to Multiple Databases via the CData Sync CLI
Replicate Amazon Athena to disparate databases with a single configuration.
-
Connecting GenSpark with Reckon via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to enterprise data across 300+ systems without any replication or custom integration required.
-
Use Dash to Build to Web Apps on GitHub
Create Python applications that use pandas and Dash to build GitHub-connected web apps.
-
Bind Live Procore Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Procore data
-
ETL Oracle SCM in Oracle Data Integrator
This article shows how to transfer Oracle SCM into a data warehouse using Oracle Data Integrator.
-
Create Informatica Mappings From/To a JDBC Data Source for Active Directory
Create Active Directory data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Choosing the Best Method to Connect Certinia to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Certinia from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create Data Visualizations Based On Act CRM in Mode
Use CData Connect AI to connect to Act CRM from Mode and build visualizations using live
-
Connect to and Visualize Live Authorize.Net in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Authorize.Net.
-
Connecting GenSpark with YouTube Analytics via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to enterprise data across 300+ systems without any replication or custom integration required.
-
LINQ to Dynamics 365
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 Dynamics 365 Data Provider.
-
How to connect PolyBase to Jira Service Management
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Atlassian Jira Service Management.
-
Operational Reporting on SAS Data Sets from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SAS Data Sets.
-
Integrate Salesforce with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Salesforce with External Services.
-
Automated Amazon DynamoDB Replication to Teradata
Use CData Sync to Customize and automate Amazon DynamoDB replication to Teradata.
-
Create Dynamic Google Campaign Manager 360 Grids Using the Infragistics XamDataGrid
Learn how you can connect Google Campaign Manager 360 to Infragistics XamDataGrid to build dynamic grids.
-
Automate Google Ads Replication to Azure Synapse
Use CData Sync to customize and automate Google Ads replication to Azure Synapse.
-
Create HarperDB Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time HarperDB data access from reports, embedded analytics, and more.
-
Natively Connect to MYOB AccountRight in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to MYOB AccountRight. Leverage the native support for ODBC in PHP.
-
Write a Simple Go Application to work with Pinterest on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Pinterest.
-
Getting Started with the CData ADO.NET Provider for ServiceNow
-