CData Software - Knowledge Base
Recent Articles
-
Connect to Google Drive in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to connect and process PayPal from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live PayPal.
-
Create Reports with MailChimp in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date MailChimp.
-
Import SAP HANA into the Power BI Service for Visualizations
Use CData Connect AI to connect to SAP HANA and provide access to live SAP HANA for custom reports in the Power BI Service.
-
How to Access SAP SuccessFactors Using Entity Framework
This article shows how to access SAP SuccessFactors using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Manage ADP in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ADP.
-
Bind Live Sage Intacct Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Sage Intacct data
-
Connect to Shopify from Asprova with CData Software ODBC Driver for Shopify
This article shows how to connect faster to Shopify data from Asprova.
-
Use the CData Software ODBC Driver for Power BI XMLA in MicroStrategy
Connect to Power BI XMLA in MicroStrategy Developer using the CData Software ODBC Driver for Power BI XMLA.
-
Build SAS Data Sets-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SAS Data Sets.
-
Migrating data from IBM Cloud Object Storage to Snowflake using CData SSIS Components.
Easily push IBM Cloud Object Storage to Snowflake using the CData SSIS Tasks for IBM Cloud Object Storage and Snowflake.
-
Access Live Acumatica in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Acumatica ERP from your Google Sheets.
-
Create Teradata 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 connect to Blackbaud FE NXT in DBVisualizer
Integrate Blackbaud FE NXT with visual data analysis tools and data connection wizards in DBVisualizer
-
Migrating data from Okta to Google BigQuery using CData SSIS Components.
Easily push Okta to Google BigQuery using the CData SSIS Tasks for Okta and Google BigQuery.
-
Automated Continuous Google Search Replication to Snowflake
Use CData Sync for automated, continuous, customizable Google Search replication to Snowflake.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for HubSpot
Provide connectivity to HubSpot through an SAP BusinessObjects universe.
-
How to Connect DBeaver to ServiceNow via a JDBC Driver
Manage ServiceNow with visual tools in DBeaver like the query browser.
-
Use Azure AI Foundry to Talk to Your Google Directory via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Google Directory for you.
-
How to create Visio diagrams from Salesforce Pardot
Automatically update Salesforce Pardot with the changes you make to Visio master shapes.
-
Visualize HubSpot in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load HubSpot into TIBCO Spotfire.
-
Publish AlloyDB-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Google AlloyDB.
-
Bridge NetSuite Connectivity with Apache NiFi
Access and process NetSuite CRM & ERP in Apache NiFi using the CData JDBC Driver.
-
Object-Relational Mapping (ORM) with Gmail Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Gmail into a Java-based ORM framework, Hibernate.
-
Getting Started with the CData Python Connector for Salesloft
Learn to install and license the CData Python Connector
-
Automated Continuous SAP BusinessObjects BI Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to PostgreSQL.
-
Create Office 365-Connected Dashboards in Grafana
Connect to Office 365 via CData Connect AI in Grafana and create custom business dashboards with real-time access to Microsoft Office 365.
-
Build BigQuery-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Google BigQuery.
-
Model, Search, and Visualize Live GitHub in ThoughtSpot
Use CData Connect AI to connect to live GitHub for modeling, searching, and visualizing.
-
Extract, Transform, and Load SAS xpt in Informatica PowerCenter
Create a simple Workflow for SAS XPORT in Informatica PowerCenter.
-
How to Design Sage Intacct Power Apps with Database-Like Connectivity
This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.
-
How to import SAS xpt into Apache Solr
Use the CData Software JDBC Driver for SAS xpt in Data Import Handler and create an automated import of SAS XPORT to Apache Solr Enterprise Search platform.
-
Create Reports from Zendesk in Looker Studio
Use CData Connect AI to gain access to live Zendesk and create custom reports in Looker Studio.
-
Query, Visualize, and Share live Amazon Athena in Redash
Use CData Connect AI to connect to live Amazon Athena in Redash for querying, visualizing, and sharing.
-
How to update Paylocity from Excel
This article explains how to transfer data from Excel to Paylocity using the Excel Add-In for Paylocity.
-
Build Charts with GitHub in Clear Analytics
Create dynamic charts and perform analytics based on GitHub in Clear Analytics.
-
A PostgreSQL Interface for Workday using the CData ODBC Driver
Use the SQL Gateway and Workday ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData SSIS Components to Insert New or Update Existing Azure Table Records from SQL Server
Easily push SQL Server data to Azure Table using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Azure Table or update existing records with data from a SQL Server database.
-
Build Data Flows from Presto to SQL Server using SSIS
Easily back up Presto to SQL Server using the SSIS components for Presto.
-
Automated Continuous Aha Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Aha replication to Microsoft Access.
-
Create Informatica Mappings From/To a JDBC Data Source for Oracle Sales
Create Oracle Sales data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Query SAP HANA in DataGrip
Create a Data Source for SAP HANA in DataGrip and use SQL to query live SAP HANA.
-
Create Informatica Mappings From/To an ODBC Data Source for Azure Data Catalog
Create an ODBC connection to Azure Data Catalog in Informatica and browse and transfer Azure Data Catalog.
-
Design BIRT Reports on Dynamics 365 Business Central
Provide current Dynamics 365 Business Central to your embedded analytics.
-
How to pipe Spark to CSV in PowerShell
Use standard PowerShell cmdlets to access Spark tables.
-
Prepare, Blend, and Analyze Azure Table in Alteryx Designer (Connect AI)
Build workflows to access live Azure Table Storage for self-service data analytics.
-
Getting Started with the CData PowerShell Cmdlets for Harvest
-