Read the blog
 

AlloyDB Integration Guides and Tutorials

Ready to get started?

Learn more:

AlloyDB Connectivity Solutions

In this article

Related articles


A list of guides and tutorials for connecting to and working with live AlloyDB data.

CData Software connectivity tools provide access to live AlloyDB data from popular BI, analytics, ETL, and custom applications, offering our customers access to their data wherever they want. Below you will find a list of guides and tutorials for integrating with live AlloyDB data.

Integration Use-Cases

Click below to jump to articles related to specific integration use-case.

Business Intelligence & Analytics


ProductTechnologyArticle Title
Alteryx DesignerODBCPrepare, Blend, and Analyze AlloyDB in Alteryx Designer (ODBC)
Alteryx DesignerConnect CloudWork with Live AlloyDB Data in Alteryx Designer (Connect Cloud)
Amazon QuickSightConnect CloudBuild Interactive Dashboards from AlloyDB in Amazon QuickSight
Aqua Data StudioJDBCConnect to AlloyDB in Aqua Data Studio
AWS DatabricksJDBCProcess & Analyze AlloyDB Data in Databricks (AWS)
Azure Analysis ServicesConnect CloudModel AlloyDB Data Using Azure Analysis Services
BirstJDBCBuild Visualizations of AlloyDB in Birst
BIRTJDBCDesign BIRT Reports on AlloyDB
Clear AnalyticsODBCBuild Charts with AlloyDB in Clear Analytics
Cognos Analytics (On-Prem)Connect CloudAnalyze AlloyDB Data in Cognos Analytics
DBxtraODBCBuild Dashboards with AlloyDB in DBxtra
DomoODBCCreate Datasets from AlloyDB in Domo Workbench
Dundas BIODBCBuild Dashboards with AlloyDB in Dundas BI
Excel (on Mac OS)ODBCWork with AlloyDB Data in MS Excel on Mac OS X
FineReportJDBCFeed AlloyDB into FineReport
Google SheetsConnect CloudAccess Live AlloyDB in Google Sheets
IBM Cognos BIODBCCreate Data Visualizations in Cognos BI with AlloyDB
Infragistics RevealConnect CloudAnalyze AlloyDB Data in Infragistics Reval
JasperServerJDBCCreate AlloyDB Reports on JasperReports Server
Jaspersoft BI SuiteJDBCConnect to AlloyDB in Jaspersoft Studio
JReport DesignerJDBCIntegrate with AlloyDB in JReport Designer
KlipfolioConnect CloudCreate AlloyDB-Connected Visualizations in Klipfolio
KNIMEJDBCEnable the AlloyDB JDBC Driver in KNIME
LINQPadADO.NETWorking with AlloyDB in LINQPad
LookerConnect CloudAnalyze AlloyDB in Looker
Looker StudioConnect CloudCreate Reports from AlloyDB in Looker Studio
MetabaseConnect CloudCreate Interactive AlloyDB-Connected Metabase Dashboards
Microsoft ExcelConnect CloudAccess Live AlloyDB Data in Excel Desktop
Microsoft Excel for the WebConnect CloudAccess Live AlloyDB Data in Excel for the Web
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from AlloyDB
MicroStrategyConnect CloudConnect to Live AlloyDB in MicroStrategy through Connect Cloud
MicroStrategyJDBCUse the CData JDBC Driver for AlloyDB in MicroStrategy
Microstrategy DesktopJDBCUse the CData JDBC Driver for AlloyDB in MicroStrategy Desktop
Microstrategy WebJDBCUse the CData JDBC Driver for AlloyDB in MicroStrategy Web
Mode AnalyticsConnect CloudCreate AlloyDB-Connected Visualizations in Mode
OBIEEJDBCAlloyDB Reporting in OBIEE with the AlloyDB JDBC Driver
pandasPythonUse pandas to Visualize AlloyDB in Python
Pentaho Report DesignerJDBCIntegrate AlloyDB in the Pentaho Report Designer
Power BI DesktopPower BIAuthor Power BI Reports on Real-Time AlloyDB
Power BI ServiceConnect CloudVisualize Live AlloyDB in the Power BI Service
Power PivotConnect ServerAccess AlloyDB Data in Microsoft Power Pivot
Power QueryConnect ServerAccess AlloyDB Data in Microsoft Power Query
Qlik CloudConnect CloudCreate Apps from AlloyDB in Qlik Sense Cloud
QlikViewODBCConnect to and Query AlloyDB in QlikView over ODBC
RJDBCAnalyze AlloyDB in R (JDBC)
RODBCAnalyze AlloyDB in R (ODBC)
RapidMinerJDBCConnect to AlloyDB in RapidMiner
RedashConnect ServerBuild AlloyDB-Connected Dashboards in Redash
SAP Analytics CloudConnect CloudAnalyze AlloyDB in SAP Analytics Cloud
SAP Business ObjectsJDBCCreate an SAP BusinessObjects Universe on the CData JDBC Driver for AlloyDB
SAP Crystal ReportsJDBCPublish Reports with AlloyDB in Crystal Reports
SASODBCUse the CData ODBC Driver for AlloyDB in SAS for Real-Time Reporting and Analytics
SAS JMPODBCUse the CData ODBC Driver for AlloyDB in SAS JMP
SisenseJDBCVisualize Live AlloyDB in Sisense
Spago BIJDBCConnect to AlloyDB in SpagoBI
TableauTableauVisualize AlloyDB in Tableau Desktop
Tableau CloudConnect CloudBuild AlloyDB Visualizations in Tableau Cloud
Tableau ServerTableauPublish AlloyDB-Connected Dashboards in Tableau Server
TIBCO SpotfireADO.NETVisualize AlloyDB in TIBCO Spotfire through ADO.NET
TIBCO SpotfireConnect ServerVisualize AlloyDB Data in TIBCO Spotfire
TIBCO Spotfire ServerJDBCOperational Reporting on AlloyDB from Spotfire Server
VisioODBCLink Visio Shapes to AlloyDB
Zoho AnalyticsConnect CloudCreate AlloyDB-Connect Dashboards in Zoho Analytics

Back to top

ETL & Replication


ProductTechnologyArticle Title
AirbyteConnect CloudConnect to AlloyDB Data in Airbyte ELT Pipelines
Amazon RedshiftCData SyncAutomated Continuous AlloyDB Replication to Amazon Redshift
Amazon S3CData SyncAutomated Continuous AlloyDB Replication to Amazon S3
Apache AirflowJDBCBridge AlloyDB Connectivity with Apache Airflow
Apache CamelJDBCIntegrate with AlloyDB using Apache Camel
Apache CassandraCData SyncAutomated Continuous AlloyDB Replication to Apache Cassandra
Apache KafkaCData SyncAutomated Continuous AlloyDB Replication to Apache Kafka
Apache NiFiJDBCBridge AlloyDB Connectivity with Apache NiFi
Apache NiFi Batch OperationsJDBCPerform Batch Operations with AlloyDB Data in Apache NiFi
AWS GlueConnect CloudConnect to AlloyDB in AWS Glue Jobs
AWS GlueFireDACBuild ETL Jobs with AlloyDB Data in AWS Glue Studio
Azure Data FactoryConnect CloudImport AlloyDB Data Using Azure Data Factory
Azure Data LakeCData SyncAutomated Continuous AlloyDB Replication to Azure Data Lake
Azure SynapseCData SyncAutomated Continuous AlloyDB Replication to Azure Synapse
BIMLSSISUse Biml to Build SSIS Tasks to Replicate AlloyDB to SQL Server
CloverDXJDBCConnect to AlloyDB in CloverDX (formerly CloverETL)
CouchbaseCData SyncAutomated Continuous AlloyDB Replication to Couchbase
CSVCData SyncAutomated Continuous AlloyDB Replication to Local Delimited Files
DatabricksCData SyncAutomated Continuous AlloyDB Replication to Databricks
FoxProODBCWork with AlloyDB in FoxPro
Google BigQueryCData SyncAutomated Continuous AlloyDB Replication to Google BigQuery
Google Cloud SQLCData SyncAutomated Continuous AlloyDB Replication to Google Cloud SQL
Google Data FusionJDBCBuild AlloyDB-Connected ETL Processes in Google Data Fusion
Heroku / Salesforce ConnectCData SyncReplicate AlloyDB for Use in Salesforce Connect
HULFT IntegrateJDBCConnect to AlloyDB in HULFT Integrate
IBM DB2CData SyncAutomated Continuous AlloyDB Replication to IBM DB2
Informatica CloudJDBCIntegrate AlloyDB in Your Informatica Cloud Instance
Informatica PowerCenterJDBCCreate Informatica Mappings From/To a JDBC Data Source for AlloyDB
Jaspersoft ETLJDBCConnect to AlloyDB in Jaspersoft Studio
Microsoft AccessCData SyncAutomated Continuous AlloyDB Replication to Microsoft Access
Microsoft Azure TablesCData SyncAutomated Continuous AlloyDB Replication to Azure SQL
Microsoft ExcelExcelTransfer Data from Excel to AlloyDB
Microsoft Power AutomateConnect CloudBuild AlloyDB-Connected Automated Tasks with Power Automate (Desktop)
MongoDBCData SyncAutomated Continuous AlloyDB Replication to MongoDB
MySQLCData SyncAutomated Continuous AlloyDB Replication to MySQL
Oracle Data IntegratorJDBCETL AlloyDB in Oracle Data Integrator
Oracle DatabaseCData SyncAutomated Continuous AlloyDB Replication to Oracle
petlPythonExtract, Transform, and Load AlloyDB in Python
PostgreSQLCData SyncAutomated Continuous AlloyDB Replication to PostgreSQL
Replicate to CSVPowerShellReplicate AlloyDB to MySQL with PowerShell
SAP HANACData SyncAutomated Continuous AlloyDB Replication to SAP HANA
SingleStoreCData SyncAutomated Continuous AlloyDB Replication to SingleStore
SnapLogicJDBCIntegrate AlloyDB with External Services using SnapLogic
SnowflakeCData SyncAutomated Continuous AlloyDB Replication to Snowflake
SQL ServerCData SyncAutomated Continuous AlloyDB Replication to SQL Server
SQL Server Linked ServerConnect CloudConnect to AlloyDB as a SQL Server Linked Server
SQLiteCData SyncAutomated Continuous AlloyDB Replication to SQLite
TalendJDBCConnect to AlloyDB and Transfer Data in Talend
UiPath StudioODBCCreate an RPA Flow that Connects to AlloyDB in UiPath Studio
VerticaCData SyncAutomated Continuous AlloyDB Replication to a Vertica Database

Back to top

Data Virtualization


ProductTechnologyArticle Title
Access Linked TablesODBCUpdate AlloyDB with a Microsoft Access Linked Table
APOS Live Data GatewayJDBCBuild Semantic Layer Views for AlloyDB (JDBC)
APOS Live Data GatewayConnect CloudBuild Semantic Layer Views for AlloyDB (Connect Cloud)
DenodoJDBCCreate A Data Source for AlloyDB in Denodo Platform
DremioJDBCConnect to AlloyDB as an External Source in Dremio
MySQL Federated TablesConnect ServerConnect to AlloyDB as Federated Tables in MySQL
MySQL Federated TablesODBCConnect to AlloyDB as Federated Tables in MySQL
Oracle DatabaseODBCAccess AlloyDB as a Remote Oracle Database
PostgreSQL FDWJDBCA PostgreSQL Interface for AlloyDB
Salesforce ConnectConnect CloudEdit and Search AlloyDB External Objects in Salesforce Connect
SQL Server Linked ServersODBCConnect to AlloyDB as a Linked Server
SQL Server PolyBaseConnect CloudConnect to AlloyDB using PolyBase with Connect Cloud
SQL Server PolyBaseODBCConnect to AlloyDB as an External Data Source using PolyBase
TIBCO Data VirtualizationTIBCO DVAccess Live AlloyDB Data in TIBCO Data Virtualization

Back to top

Software Development


ProductTechnologyArticle Title
.NET ChartsADO.NETDataBind Charts to AlloyDB
.NET QueryBuilderODBCRapidly Develop AlloyDB-Driven Apps with Active Query Builder
Angular JSConnect ServerUsing AngularJS to Build Dynamic Web Pages with AlloyDB
Apache SparkJDBCWork with AlloyDB in Apache Spark Using SQL
AppSheetConnect CloudCreate AlloyDB-Connected Business Apps in AppSheet
Bubble.ioConnect CloudBuild AlloyDB-Connected Apps in Bubble
C++BuilderODBCDataBind Controls to AlloyDB Data in C++Builder
ChoreoConnect CloudBuild Custom Apps on AlloyDB Data in Choreo
ColdFusionJDBCQuery AlloyDB in ColdFusion Using JDBC
ColdFusionODBCQuery AlloyDB in ColdFusion Using ODBC
DashPythonUse Dash & Python to Build Web Apps on AlloyDB
DelphiODBCDataBind Controls to AlloyDB Data in Delphi
DevExpressADO.NETDataBind AlloyDB to the DevExpress Data Grid
EF - Code FirstADO.NETAccess AlloyDB with Entity Framework 6
EF - LINQADO.NETLINQ to AlloyDB
EF - MVCADO.NETBuild MVC Applications with Connectivity to AlloyDB
Filemaker ProODBCBidirectional Access to AlloyDB from FileMaker Pro
Filemaker Pro (on Mac)JDBCBidirectional Access to AlloyDB from FileMaker Pro (on Mac)
GoODBCWrite a Simple Go Application to work with AlloyDB on Linux
Google Apps ScriptConnect CloudConnect to AlloyDB in Google Apps Script
HibernateJDBCObject-Relational Mapping (ORM) with AlloyDB Entities in Java
IntelliJJDBCConnect to AlloyDB in IntelliJ
JBossJDBCConnect to AlloyDB from a Connection Pool in JBoss
JDBIJDBCCreate a Data Access Object for AlloyDB using JDBI
JRubyJDBCConnect to AlloyDB in JRuby
MendixConnect CloudBuild AlloyDB-Connected Apps in Mendix
Microsoft Power AppsConnect CloudIntegrate Live AlloyDB into Custom Business Apps Built in Power Apps
NodeJSConnect CloudQuery AlloyDB in Node.js (via Connect Cloud)
NodeJSJDBCQuery AlloyDB through ODBC in Node.js
OutSystemsConnect CloudCreate AlloyDB-Connected Enterprise Applications in OutSystems
PHPConnect ServerAccess AlloyDB in PHP through the Cloud Hub
PHPODBCNatively Connect to AlloyDB in PHP
PowerBuilderADO.NETConnect to AlloyDB from PowerBuilder
PowerShellPowerShellPipe AlloyDB to CSV in PowerShell
PyCharmODBCUsing the CData ODBC Driver for AlloyDB in PyCharm
PythonODBCConnect to AlloyDB in Python on Linux/UNIX
ReactConnect ServerBuild Dynamic React Apps with AlloyDB Data
RubyODBCConnect to AlloyDB in Ruby
RunMyProcessConnect CloudConnect to AlloyDB in RunMyProcess
RunMyProcess DSECJDBCConnect to AlloyDB in DigitalSuite Studio through RunMyProcess DSEC
SAP UI5Connect ServerIntegrate Real-Time Access to AlloyDB in SAPUI5 MVC Apps
ServoyJDBCBuild AlloyDB-Connected Apps in Servoy
Spring BootJDBCAccess Live AlloyDB Data in Spring Boot Apps
SQLAlchemyPythonUse SQLAlchemy ORMs to Access AlloyDB in Python
TomcatJDBCConfigure the CData JDBC Driver for AlloyDB in a Connection Pool in Tomcat
UnqorkConnect CloudCreate AlloyDB-Connected Applications in Unqork
VCL App (RAD Studio)ODBCBuild a Simple VCL Application for AlloyDB
WebLogicJDBCConnect to AlloyDB from a Connection Pool in WebLogic

Back to top

Data Management


ProductTechnologyArticle Title
Apache SolrJDBCImport AlloyDB Data into Apache Solr
DB ArtisanJDBCManage AlloyDB in DBArtisan as a JDBC Source
DB ArtisanODBCConnect to AlloyDB in DBArtisan
DBeaverJDBCConnect to AlloyDB in DBeaver
DbVisualizerJDBCConnect to AlloyDB in DBVisualizer
Informatica Enterprise Data CatalogJDBCAdd AlloyDB to Informatica Enterprise Data Catalog
MySQL WorkbenchConnect ServerQuery AlloyDB Data in MySQL Workbench (Connect Server)
MySQL WorkbenchODBCQuery AlloyDB in MySQL Workbench (ODBC)
Power QueryConnect CloudWork with Live AlloyDB Data in Power Query
QuerySurgeJDBCValidate AlloyDB Data with QuerySurge
RazorSQLJDBCConnect to AlloyDB in RazorSQL
SQuirreLJDBCConnect to AlloyDB in Squirrel SQL Client

Back to top

Workflow Automation


ProductTechnologyArticle Title
MuleSoft AnypointJDBCAccess AlloyDB in Anypoint Using SQL
Nintex Workflow CloudConnect CloudBuild AlloyDB-Connected Workflows in Nintex
Power AutomateConnect CloudIntegrate AlloyDB into Power Automate Automated Tasks
SSIS ExportSSISExport Data from SQL Server to AlloyDB through SSIS
SSIS ImportSSISImport AlloyDB Data into SQL Server using SSIS
SSIS LookupSSISInsert New or Update Existing AlloyDB Records from SQL Server

Back to top