CData Software - Knowledge Base

Recent Articles

• «
• 443
• 444
• 445
• 446
• 447
• 448
• 449
• 450
• 451
• 452
• »

• Edit and Search External SharePoint Objects in Salesforce Connect

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

• Query SFTP in DataGrip

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

• Consume Spark OData Feeds in SAP Lumira

  Use the API Server to create data visualizations on Spark feeds that reflect any changes in SAP Lumira.

• Replicate Multiple Exact Online Accounts via the CData Sync CLI

  Replicate multiple Exact Online accounts to one or many databases.

• How to connect to TaxJar from Spring Boot

  Connect to TaxJar in a Spring Boot Application using CData JDBC TaxJar Driver

• Integrate JotForm in Pentaho Data Integration

  Build ETL pipelines based on JotForm in the Pentaho Data Integration tool.

• Work with SQL Analysis Services in FoxPro

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

• Extract, Transform, and Load SAP Hybris C4C in Informatica PowerCenter

  Create a simple Workflow for SAP Hybris C4C in Informatica PowerCenter.

• Publish Reports with SAP Business One in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date SAP Business One.

• How to connect to Certinia from IntelliJ

  Integrate connectivity to Certinia with wizards in IntelliJ.

• Import and Visualize SharePoint in Power View

  Create data visualizations based on Microsoft SharePoint in Excel.

• Model Zoho Projects Using Azure Analysis Services

  Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Zoho Projects, enabling the direct import of real-time Zoho Projects.

• Access SAP from MySQL in PHP

  Connect to SAP through the standard MySQL libraries in PHP.

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

  Use the CData ODBC Driver for Veeva Vault to visualize Veeva Vault & Vault CRM in Power BI Desktop and then publish them to Power BI Report Server.

• Easily Integrate Amazon S3 in Lazarus Pascal IDE

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

• Use the CData Software ODBC Driver for ServiceNow in MicroStrategy Desktop

  Connect to ServiceNow in MicroStrategy Desktop using the CData Software ODBC Driver for ServiceNow.

• ShipStation Reporting in OBIEE with the ShipStation JDBC Driver

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

• Use the CData ODBC Driver for Sage 300 from SharePoint Excel Services

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

• How to connect PolyBase to HarperDB

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live HarperDB.

• Access Live BCart in Google Sheets via Connect Cloud

  Use CData Connect Cloud to gain access to live BCart from your Google Sheets.

• Build Automated Workflows with Live Google Analytics in Workato

  Use CData Connect Cloud to connect to live Google Analytics and build automated workflows in Workato.

• Using the CData Software ODBC Driver for Oracle in PyCharm

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

• Connect to Dropbox from PowerBuilder via JDBC

  This article demonstrates how to access Dropbox from PowerBuilder using the Dropbox JDBC Driver.

• How to Connect to Microsoft Exchange in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Microsoft Exchange. Leverage the pyodbc module for ODBC in Python.

• Access Live HBase in TIBCO Data Virtualization

  Use the CData Software TIBCO DV Adapter for HBase to create a Apache HBase source in TIBCO Data Virtualization Studio and gain access to live Apache HBase from your TDV Server.

• Access Live Procore in AWS Lambda

  Connect to live Procore in AWS Lambda using the CData JDBC Driver.

• Analyze CSV in R via ODBC

  Create data visualizations and use high-performance statistical functions to analyze CSV/TSV Files in Microsoft R Open.

• Automated Continuous Pinterest Replication to Vertica

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

• Connect to Acumatica in DBArtisan

  Use wizards in DBArtisan to configure Acumatica ERP as a data source.

• Analyze Zenefits in R via ODBC

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

• Establish a Live Connection with Amazon Athena using Tableau Bridge

  The CData ODBC Driver for Amazon Athena enables you to integrate live Amazon Athena into Tableau Cloud dashboards using the Tableau Bridge.

• Choosing the Best Method to Connect Salesloft to SQL Server: 5 Options Explained

  Discover multiple ways to connect and use Salesloft from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

• Integrate Blackbaud FE NXT in the Pentaho Report Designer

  Publish reports based on Blackbaud FE NXT in the Pentaho BI tool.

• Create SSAS Tabular Models from Azure Analysis Services

  How to build a SQL Server Analysis Service Tabular Model from Azure Analysis Services using CData drivers.

• Excel Spreadsheet Automation on Odoo with the QUERY Formula

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

• Back Up Oracle Service Cloud to SQL Server through SSIS

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

• Automate Google Ad Manager Replication to SAP HANA

  Use CData Sync to customize and automate Google Ad Manager replication to SAP HANA.

• How to integrate JDBC-ODBC Bridge with Apache Airflow

  Access and process JDBC-ODBC Bridge in Apache Airflow using the CData JDBC Driver.

• Access Live Zoho Books in AWS Lambda

  Connect to live Zoho Books in AWS Lambda using the CData JDBC Driver.

• How to Connect DBeaver to Freshdesk via a JDBC Driver

  Manage Freshdesk with visual tools in DBeaver like the query browser.

• Automate MariaDB Integration Tasks from PowerShell

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

• Build a Simple VCL Application for Bing Search Results

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

• Automated Continuous OData Replication to MongoDB

  Use CData Sync for automated, continuous, customizable OData replication to MongoDB.

• How to connect to BambooHR with Squirrel SQL client

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

• Automated Continuous Shopify Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable Shopify replication to Amazon S3.

• Connect to MYOB AccountRight in Ruby

  Connect to MYOB AccountRight in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

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

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

• How to Connect DBeaver to Square via a JDBC Driver

  Manage Square with visual tools in DBeaver like the query browser.

• Import Shopify Using Azure Data Factory

  Use CData Connect Cloud to connect to Shopify from Azure Data Factory and import live Shopify.

• Model SAP Concur Using Azure Analysis Services

  Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and SAP Concur, enabling the direct import of real-time SAP Concur.

• Access Typeform 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 Typeform.

• Create Apps from ShipStation in Qlik Sense Cloud

  Use CData Connect Cloud to connect to ShipStation and build apps from live ShipStation in Qlik Sense Cloud.

• Integrate with Adobe Commerce using Apache Camel2

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

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

  Create an ODBC connection to Freshdesk in Informatica and browse and transfer Freshdesk.

• PowerShell Scripting to Replicate Sybase to MySQL

  Write a simple PowerShell script to replicate Sybase to a MySQL database.

• Using the CData Software ODBC Driver for Bitbucket in PyCharm

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

• Create Dynamic HarperDB Grids Using the Infragistics XamDataGrid

  Learn how you can connect HarperDB to Infragistics XamDataGrid to build dynamic grids.

• Feed NetSuite into FineReport

  How to set NetSuite CRM & ERP as a JDBC data source in FineReport.

• Integrate Sage Intacct in Pentaho Data Integration

  Build ETL pipelines based on Sage Intacct in the Pentaho Data Integration tool.

• Automate Trello Integration Tasks from PowerShell

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

• Connect to HDFS in Ruby

  Connect to Apache HDFS in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Perform Batch Operations with Google Campaign Manager 360 in Apache NiFi

  Connect to Google Campaign Manager 360 and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• How to integrate Metabase with Marketo

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

• Create Gmail-Connected Dashboards in Grafana

  Connect to Gmail via CData Connect Cloud in Grafana and create custom business dashboards with real-time access to Gmail.

• Publish Oracle-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Oracle Database.

• Feed SharePoint into FineReport

  How to set Microsoft SharePoint as a JDBC data source in FineReport.

• Import Odoo into the Power BI Service for Visualizations

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

• Query Zuora as a SQL Server Database in Node.js

  Execute SQL Server queries against Zuora from Node.js.

• Use the CData Software ODBC Driver for SAP Business One in MicroStrategy

  Connect to SAP Business One in MicroStrategy Developer using the CData Software ODBC Driver for SAP Business One.

• Build MYOB AccountRight-Connected Apps in Bubble

  Use CData Connect Cloud to create an OData feed for MYOB AccountRight and create custom apps in Bubble.

• Build a Simple VCL Application for Invoiced

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

• Automated Continuous Certinia Replication to Apache Cassandra

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

• Build Sage Cloud Accounting-Connected Apps in Choreo

  Use CData Connect Cloud to connect to Sage Cloud Accounting from Choreo and build custom apps using live Sage Business Cloud Accounting.

• Connect to PayPal from a Connection Pool in WebLogic

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

• Object-Relational Mapping (ORM) with SharePoint 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 Microsoft SharePoint into a Java-based ORM framework, Hibernate.

• Migrating data from Pipedrive to Databricks using CData SSIS Components.

  Easily push Pipedrive to Databricks using the CData SSIS Tasks for Pipedrive and Databricks.

• Connect to Office 365 as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft Office 365.

• Connect to MarkLogic in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Automated Continuous Harvest Replication to MySQL

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

• Back Up Basecamp to SQL Server through SSIS

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

• Connect to Sugar CRM in RazorSQL

  Connect to Sugar CRM from wizards and query Sugar CRM from the GUI in the RazorSQL database management tool.

• Viewing JotForm in RAD Studio Data Explorer

  How to view JotForm in RAD Studio Data Explorer using the CData ODBC Driver for JotForm.

• Rapidly Develop Parquet-Driven Apps with Active Query Builder

  Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.

• Validate Authorize.Net with QuerySurge

  Access and validate Authorize.Net in QuerySurge using the CData JDBC Driver.

• Create Bullhorn CRM-Connected Nintex Workflows

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

• Query Monday.com in ColdFusion

  Write standard ColdFusion data access code to connect to Monday.com.

• How to connect to Access with Squirrel SQL client

  Connect to Microsoft Access and execute queries in the Squirrel SQL Client.

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

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

• Pipedrive Reporting and Star Schemas in OBIEE

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

• Configure the CData JDBC Driver for MYOB AccountRight in a Connection Pool in Tomcat

  Connect to MYOB AccountRight from a connection pool in Tomcat.

• DataBind Charts to Klaviyo

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Klaviyo from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

• Use Dash to Build to Web Apps on Wave Financial

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

• Viewing QuickBooks Time in RAD Studio Data Explorer

  How to view QuickBooks Time in RAD Studio Data Explorer using the CData ODBC Driver for QuickBooks Time.

• Connect to Avalara AvaTax in Aqua Data Studio

  Access Avalara AvaTax from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Visualize Kafka in TIBCO Spotfire through OData

  Integrate Apache Kafka into dashboards in TIBCO Spotfire.

• Automate Tasks in Power Automate Using the CData Software API Server and Cloudant ADO.NET Provider

  Automate actions like sending emails to a contact list, posting to social media, or syncing CRM and ERP.

• Integrate Act CRM into Automated Tasks with Power Automate

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

• Analyze Live Zoho Creator in SAS Viya

  Use CData Connect Cloud to connect to Zoho Creator from SAS Viya and deploy self-service analytics using live Zoho Creator.

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

  Connect to MariaDB 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.

• Explore Geographical Relationships in Clio with Power Map

  Create data visualizations with Clio in Power Map.

• «
• 443
• 444
• 445
• 446
• 447
• 448
• 449
• 450
• 451
• 452
• »