DownloadsDocumentationAPI ReferenceChangelogOpen A TicketContact
HomeGuidesAPI ReferenceChangelog
DownloadsDocumentationAPI ReferenceChangelogOpen A TicketContactLog In
Guides

Supported Database Connectors List

Database Collection supports an array of connectors. Please find the list of connectors, Database URL strings and reference link in the table below

Database NameDatabase URL StringSample Query
Active Directoryjdbc:activedirectory:User=MyUserName;Password=MyPassword;Server=MyServer;Port=MyPort;SELECT * FROM User
http://cdn.cdata.com/help/CDE/jdbc/pg_select.htm
Adobe Analyticsjdbc:adobeanalytics:GlobalCompanyId=myGlobalCompanyId;RSID=myRSID;OAuthClientId=myOauthClientId;OauthClientSecret=myOAuthClientSecret;CallbackURL=myCallbackURL;SELECT * FROM SampleTable_1 http://cdn.cdata.com/help/SCE/jdbc/pg_select.htm
Alfrescojdbc:alfresco:ConnectionProperty1=Value1;ConnectionProperty2=Value2"SELECT DBID, Column1 AS My_Column1, GETDATE() FROM Alfresco WHERE Column2 = 'Bob'
http://cdn.cdata.com/help/SJE/jdbc/pg_resultsetmetadatajdbc.htm"
Amazon Athenajdbc:amazonathena:AccessKey='a123';SecretKey='s123';Region='IRELAND';Database='sampledb';S3StagingDirectory='s3://bucket/staging/';SELECT * FROM Customers http://cdn.cdata.com/help/FKE/jdbc/pg_select.htm
Amazon DynamoDBjdbc:amazondynamodb:Access Key=xxx;Secret Key=xxx;Domain=amazonaws.com;Region=OREGON;SELECT * FROM Account http://cdn.cdata.com/help/DDE/jdbc/pg_select.htm
Amazon Marketplacejdbc:amazonmarketplace:AWS Access Key Id=myAWSAccessKeyId;AWS Secret Key=myAWSSecretKey;MWS Auth Token=myMWSAuthToken;Seller Id=mySellerId;Marketplace=United States;SELECT * FROM SampleTable_1 http://cdn.cdata.com/help/ONE/jdbc/pg_select.htm
Amazon RedShiftjdbc:redshift:User=admin;Password=admin;Database=dev;Server=examplecluster.my.us-west-2.redshift.amazonaws.com;Port=5439;SELECT ShipName, ShipCity AS My_ShipCity, GETDATE() FROM Orders WHERE ShipCountry = 'USA'
http://cdn.cdata.com/help/FRE/jdbc/pg_resultsetmetadatajdbc.htm
Amazon S3jdbc:amazons3:AccessKey=a123;SecretKey=s123;SELECT * FROM Buckets http://cdn.cdata.com/help/SXE/jdbc/pg_select.htm
Apache HBasejdbc:apachehbase:Server=127.0.0.1;Port=8080;SELECT * FROM Account
http://cdn.cdata.com/help/RHE/jdbc/pg_select.htm
Apache Hivejdbc:apachehive:Server=127.0.0.1;Port=10000;TransportMode=BINARYSELECT * FROM Customers
http://cdn.cdata.com/help/FIE/jdbc/pg_select.htm
Apache Phoenixjdbc:apachephoenix:Server=localhost;Port=8765;SELECT Id, Name AS My_Name, GETDATE() FROM Account WHERE Industry = 'Floppy Disks'
http://cdn.cdata.com/help/UAE/jdbc/pg_resultsetmetadatajdbc.htm
Authorize.Netjdbc:authorizenet:LoginID=myLoginID;TransactionKey=myTransactionKeySELECT * FROM SettledBatchList
http://cdn.cdata.com/help/CWE/jdbc/pg_select.htm
Azure Table Storagejdbc:azuretables:AccessKey=myAccessKey;Account=myAccountName;SELECT * FROM NorthwindProducts
http://cdn.cdata.com/help/CAE/jdbc/pg_select.htm
BaseCampjdbc:basecamp:InitiateOAuth=GETANDREFRESH;AccountId=1234567;Schema=V3;ProjectId=abcd1234SELECT * FROM Projects http://cdn.cdata.com/help/BCE/jdbc/pg_select.htm
Boxjdbc:box:InitiateOAuth=GETANDREFRESH;SELECT * FROM Files http://cdn.cdata.com/help/BBE/jdbc/pg_select.htm
Bugzillajdbc:bugzilla: Url=http://<yourdomainname>/Bugzilla;APIKey=abc123;SELECT * FROM SampleTable_1
http://cdn.cdata.com/help/SBE/jdbc/pg_select.htm
Cassandrajdbc:cassandra:Database=MyCassandraDB;Port=9042;Server=127.0.0.1;SELECT * FROM Account
http://cdn.cdata.com/help/RCE/jdbc/pg_select.htm
CosmosDBjdbc:cosmosdb:AccountEndpoint=myAccountEndpoint;AccountKey=myAccountKey;SELECT * FROM Customers http://cdn.cdata.com/help/EHE/jdbc/pg_select.htm
Couchbasejdbc:couchbase:User='myusername';Password='mypassword';Server='http://couchbase40'SELECT * FROM Customer
http://cdn.cdata.com/help/CKE/jdbc/pg_select.htm
CSVjdbc:csv:GenerateSchemaFiles=OnStart;URI=https://MyAPI;Location=C:\\MySchemaFolder;SELECT * FROM NorthwindOData http://cdn.cdata.com/help/RVE/jdbc/pg_select.htm
DocuSignjdbc:docusign:InitiateOAuth=GETANDREFRESH;OAuthClientId=MyClientId;OAuthClientSecret=MyClientSecret;CallbackURL=http://localhost:33333SELECT * FROM Account http://cdn.cdata.com/help/UCE/jdbc/pg_select.htm
DropBoxjdbc:dropbox:InitiateOAuth=GETANDREFRESH;SELECT * FROM Files http://cdn.cdata.com/help/OFE/jdbc/pg_select.htm
Dynamics 365 Business Centraljdbc:d365businesscentral:OrganizationUrl=https://businesscentral.dynamics.com/myAccount/;User=myUser;Access Key=myAccessKey;SELECT * FROM Accounts http://cdn.cdata.com/help/FBE/jdbc/pg_select.htm
Dynamics 365 Finance And Operationsjdbc:d365finop:InitiateOAuth=GETANDREFRESH;OrganizationUrl=https://myaccount.operations.dynamics.com/;SELECT * FROM Accounts http://cdn.cdata.com/help/FFE/jdbc/pg_select.htm
Dynamics 365 Salesjdbc:d365sales:InitiateOAuth=GETANDREFRESH;OrganizationUrl=https://myaccount.crm.dynamics.com/;SELECT * FROM Accounts http://cdn.cdata.com/help/ERE/jdbc/pg_select.htm
Dynamics CRMdbc:dynamicscrm:User=myuseraccount;Password=mypassword;
URL=https://myOrg.crm.dynamics.com/;CRM Version=CRM Online;		SELECT * FROM Lead
http://cdn.cdata.com/help/RMA/jdbc/pg_select.htm
Dynamics GPjdbc:dynamicsgp:CompanyId=-1;user=myuser;password=mypassword;
URL= http://{servername}:{port}/Dynamics/GPService		SELECT * FROM Customer
http://cdn.cdata.com/help/DPA/jdbc/pg_select.htm
Dynamics NAVjdbc:dynamicsnav:URL=http://myserver:7048;
User=myserver\Administrator;Password=admin;
ServerInstance=DYNAMICSNAV71;		SELECT * FROM Customer
http://cdn.cdata.com/help/CNA/jdbc/pg_select.htm
Elasticsearchjdbc:elasticsearch:Server=127.0.0.1;Port=9200;SELECT * FROM Account
http://cdn.cdata.com/help/EEE/jdbc/pg_select.htm
Eloquajdbc:oracleeloqua:User=user;Password=password;Company=MyCompanySELECT * FROM Contact
http://cdn.cdata.com/help/DUE/jdbc/pg_select.htm
Emailjdbc📧Port=993;Server=imap.gmail.com;Password=password;User=user;Protocol=IMAP;SMTP Port=587;SMTP Server=smtp.gmail.com;SELECT * FROM [INBOX]
http://cdn.cdata.com/help/REE/jdbc/pg_select.htm
Exact Onlinejdbc:exactonline:InitiateOAuth=GETANDREFRESH;Region='United States';Division=5512;SELECT * FROM Accounts
http://cdn.cdata.com/help/DYE/jdbc/pg_select.htm
Exceljdbc:excel:Excel File=C:\MyExcelWorkbooks\SampleWorkbook.xlsx;SELECT * FROM Sheet
http://cdn.cdata.com/help/RXE/jdbc/pg_select.htm
Excel Onlinejdbc:excelonline:InitiateOAuth=GETANDREFRESH;SELECT * FROM Test_xlsx_Sheet1 http://cdn.cdata.com/help/FXE/jdbc/pg_select.htm
Excel Servicesjdbc:excelservices:Url=https://myorg.sharepoint.com;[email protected];Password=password;File=Book1.xlsx;SELECT * FROM Account
http://cdn.cdata.com/help/DTE/jdbc/pg_select.htm
Facebookjdbc:facebook:InitiateOAuth=GETANDREFRESH;SELECT * FROM Statuses
http://cdn.cdata.com/help/RBE/jdbc/pg_select.htm
Gmailjdbc:gmail:user=myuseraccount;password=mypassword;SELECT * FROM Inbox
http://cdn.cdata.com/help/DLE/jdbc/pg_select.htm
Google Adsjdbc:googleads:InitiateOAuth=GETANDREFRESH;DeveloperToken=myDeveloperToken;ClientCustomerId=myClientCustomerId;SELECT * FROM CampaignPerformance :: http://cdn.cdata.com/help/DZE/jdbc/pg_select.htm
Google Ads Managerjdbc:googleadsmanager:InitiateOAuth=GETANDREFRESHSELECT * FROM Orders http://cdn.cdata.com/help/BDE/jdbc/pg_select.htm
Google Analyticsjdbc:googleanalytics:InitiateOAuth=GETANDREFRESH;Profile=myProfile;SELECT * FROM Traffic
http://cdn.cdata.com/help/DAE/jdbc/pg_select.htm
Google BigQueryjdbc:googlebigquery:InitiateOAuth=GETANDREFRESH;ProjectId=NameOfProject;DatasetId=NameOfDataset;SELECT * FROM publicdata.samples.github_nested
http://cdn.cdata.com/help/DBE/jdbc/pg_select.htm
Google Campaign Managerjdbc:googlecm:InitiateOAuth=GETANDREFRESH;ProfileID=MyUserProfileID;SELECT * FROM CampaignPerformance http://cdn.cdata.com/help/EPE/jdbc/pg_select.htm
Google Directoryjdbc:googledirectory:InitiateOAuth=GETANDREFRESH;SELECT * FROM Group http://cdn.cdata.com/help/EUE/jdbc/pg_select.htm
Google Drivejdbc:googledrive:InitiateOAuth=GETANDREFRESH;SELECT * FROM Files :: http://cdn.cdata.com/help/RGE/jdbc/pg_select.htm
Google Searchjdbc:googlesearch:ApiKey=abc123; CustomSearchID=def456;"SELECT * FROM WebSearch WHERE SearchTerms = 'Fantastic Four'
http://cdn.cdata.com/help/BLE/jdbc/pg_select.htm"
Google Spannerjdbc:GoogleSpanner:ProjectId='project1';InstanceId='instance1';Database='db1';OAuthClientId='757060765381';OauthClientSecret='abc';SELECT * FROM Customer http://cdn.cdata.com/help/OGE/jdbc/pg_select.htm
Google SpreadSheetsjdbc:googlesheets:InitiateOAuth=GETANDREFRESH;Spreadsheet=NorthwindOrdersSELECT * FROM Spreadsheet1_Sheet1
http://cdn.cdata.com/help/RLE/jdbc/pg_select.htm
HPCCjdbc:hpcc:URL=http://127.0.0.1:8510;User=test;Password=xA123456;Version=1;Cluster=hthor;SELECT * FROM hpcc::test::person
http://cdn.cdata.com/help/CHE/jdbc/pg_select.htm
HubSpotjdbc:hubspot:InitiateOAuth=GETANDREFRESH;"SELECT * FROM Contacts
http://cdn.cdata.com/help/DHE/jdbc/pg_select.htm"
LDAPjdbc:ldap:user=myuseraccount;password=mypassword;SELECT * FROM User
http://cdn.cdata.com/help/RJA/jdbc/pg_select.htm
Instagramjdbc:instagram:InitiateOAuth=GETANDREFRESH;BusinessAccountId=3218475SELECT * FROM Users http://cdn.cdata.com/help/ENE/jdbc/pg_select.htm
JDBC-ODBC Bridgejdbc:jdbcodbc:Driver={SQL Server};Server=localhost;Database=AdventureWorksSELECT Id, Name AS My_Name, GETDATE() FROM Account WHERE Industry = 'Floppy Disks' http://cdn.cdata.com/help/EJE/jdbc/pg_resultsetmetadatajdbc.htm
JIRAjdbc:jira:User=admin;APIToken=myApiToken;Url=https://yoursitename.atlassian.netSELECT * FROM Projects http://cdn.cdata.com/help/BJE/jdbc/pg_select.htm
JSONjdbc:json:DataModel=Relational;URI=C:\people.jsonSELECT * FROM NorthwindOData http://cdn.cdata.com/help/DJE/jdbc/pg_select.htm
Kintonejdbc:kintone:User=myuseraccount;Password=mypassword;Url=http://subdomain.domain.com;GuestSpaceId=myspaceidSELECT * FROM Comments http://cdn.cdata.com/help/EKE/jdbc/pg_select.htm
LDAPjdbc:ldap:user=MyUserName;password=MyPassword;Server=MyServer;Port=MyPort;SELECT * FROM User
http://cdn.cdata.com/help/RJE/jdbc/pg_select.htm
LinkedInjdbc:linkedin:InitiateOAuth=GETANDREFRESH;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;CallbackURL=http://localhost:portNumber;CompanyId=XXXXXXXSELECT * FROM CompanyStatusUpdates http://cdn.cdata.com/help/CLE/jdbc/pg_select.htm
Magentojdbc:magento:Schema=magento2;User=admin;Password=admin;Url=https://mymagentohost/magento2SELECT * FROM Products
http://cdn.cdata.com/help/BZE/jdbc/pg_select.htm
MailChimpjdbc:mailchimp:APIKey=myAPIKey;SELECT * FROM Lists http://cdn.cdata.com/help/CME/jdbc/pg_select.htm
MariaDBjdbc:mariadb:User=myUser;Password=myPassword;Database=NorthWind;Server=myServer;Port=3306;SELECT ShipName, ShipCity AS My_ShipCity, GETDATE() FROM Orders WHERE ShipCountry = 'USA'
http://cdn.cdata.com/help/SRE/jdbc/pg_resultsetmetadatajdbc.htm
Marketojdbc:marketo:Schema=REST;RESTEndpoint=https://MyMarketoUrl/rest;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;SELECT * FROM Leads
http://cdn.cdata.com/help/DKE/jdbc/pg_select.htm
MarkLogicjdbc:marklogic:User='myusername';Password='mypassword';Server='marklogic'SELECT * FROM Customer http://cdn.cdata.com/help/OME/jdbc/pg_select.htm
Microsoft Exchangejdbc:exchange:User='[email protected]';Password='myPassword';Server='https://outlook.office365.com/EWS/Exchange.asmx';Platform='Exchange_Online';Schema='EWS';SELECT * FROM Contacts
http://cdn.cdata.com/help/CEE/jdbc/pg_select.htm
Microsoft Plannerjdbc:microsoftplanner:InitiateOAuth=GETANDREFRESH;OAuthClientId=MyApplicationId;OAuthClientSecret=MySecretKey;CallbackURL=http://localhost:33333;SELECT * FROM Tasks
http://cdn.cdata.com/help/UIE/jdbc/pg_select.htm
Microsoft Projectjdbc:microsoftproject:user=myuseraccount;password=mypassword;URL=http://myserver/myOrgRoot;SELECT * FROM Projects http://cdn.cdata.com/help/COE/jdbc/pg_select.htm
Microsoft Teamsjdbc:msteams:InitiateOAuth=GETANDREFRESH;OAuthClientId=MyApplicationId;OAuthClientSecret=MySecretKey;CallbackURL=http://localhost:33333;SELECT * FROM Teams http://cdn.cdata.com/help/GSE/jdbc/pg_select.htm
MongoDBjdbc:mongodb:Server=127.0.0.1;Port=27017;Database=test;User=test;Password=test;SELECT * FROM Customers
http://cdn.cdata.com/help/DGE/jdbc/pg_select.htm
MYOBjdbc:myob: If using an online instance: InitiateOAuth=GETANDREFRESH;OAuthClientId=YourClientId;OAuthClientSecret=YourClientSecret;CompanyFileId=yourCompanyFileId;CallbackURL=http://localhost:33333;User=companyFileUser;Password=companyFilePassword; If using an on premise instance: InitiateOAuth=OFF;URL=http://localhost:8080/accountright;CompanyFileId=327eed10-9615-4e5e-bd9e-ae2cc00e2c70;User=companyFileUser;Password=companyFilePassword;SELECT * FROM Accounts
http://cdn.cdata.com/help/UME/jdbc/pg_select.htm
MySQLjdbc:mysql:User=myUser;Password=myPassword;Database=NorthWind;Server=myServer;Port=3306;SELECT ShipName, ShipCity AS My_ShipCity, GETDATE() FROM Orders WHERE ShipCountry = 'USA'
http://cdn.cdata.com/help/DME/jdbc/pg_resultsetmetadatajdbc.htm
ODatajdbc:odata:User=myuseraccount;Password=mypassword;URL=http://myserver/myOrgRoot;SELECT * FROM Lead
http://cdn.cdata.com/help/RDE/jdbc/pg_select.htm
Office 365jdbc:office365:InitiateOAuth=GETANDREFRESH;OAuthClientId=MyApplicationId;OAuthClientSecret=MySecretKey;CallbackURL=http://localhost:33333;SELECT * FROM Events
http://cdn.cdata.com/help/CXE/jdbc/pg_select.htm
Oracle Databasejdbc:oracleoci:User=scott;Password=tiger;Server=127.0.0.1;Port=1521;SELECT CompanyName, City AS My_City, GETDATE() FROM Customers WHERE Country = 'US' http://cdn.cdata.com/help/SOE/jdbc/pg_resultsetmetadatajdbc.htm
Oracle Sales Cloudjdbc:oraclesalescloud:HostURL=https://my.host.oraclecloud.com; Username=abc123; Password=abcdef;SELECT * FROM Opportunities
http://cdn.cdata.com/help/EOE/jdbc/pg_select.htm
Pinterestjdbc:pinterest:InitiateOAuth=GETANDREFRESH;OAuthClientId=YourClientId;OAuthClientSecret=YourClientSecret;CallbackURL='https://localhost:33333'SELECT * FROM USERS http://cdn.cdata.com/help/UPE/jdbc/pg_select.htm
PostgreSQLjdbc:postgresql:User=postgres;Password=admin;Database=postgres;Server=127.0.0.1;Port=5432SELECT ShipName, ShipCity AS My_ShipCity, GETDATE() FROM Orders WHERE ShipCountry = 'USA'
http://cdn.cdata.com/help/FPE/jdbc/pg_resultsetmetadatajdbc.htm
Quandljdbc:quandl:ApiKey=abc123;DatabaseCode=WIKI;SELECT * FROM AAPL
http://cdn.cdata.com/help/BRE/jdbc/pg_select.htm
QuickBooksjdbc:quickbooks:User=test;Password=test;URL=http://localhost:8166;SELECT * FROM Customers
http://cdn.cdata.com/help/RQE/jdbc/pg_select.htm
QuickBooks Onlinejdbc:quickbooksonline:InitiateOAuth=GETANDREFRESH;SELECT * FROM Customers
http://cdn.cdata.com/help/RNE/jdbc/pg_select.htm
QuickBooks POSjdbc:quickbookspos:user=myuseraccount;password=mypassword;URL=http://localhost:2080;qbxmlversion=3.0;SELECT * FROM Customers
http://cdn.cdata.com/help/DRE/jdbc/pg_select.htm
Redisjdbc:redis:Server=127.0.0.1;Password=myPassword;SELECT * FROM Customers http://cdn.cdata.com/help/EIE/jdbc/pg_select.htm
RESTjdbc:rest:DataModel=Relational;URI=C:\people.xml;Format=XMLSELECT * FROM NorthwindOData http://cdn.cdata.com/help/DWE/jdbc/pg_select.htm
RSSjdbc:rss:URI=http://myservice/myfeed/;SELECT * FROM RSSFeed
http://cdn.cdata.com/help/RRE/jdbc/pg_select.htm
Sage 50 UKjdbc:sage50uk:URL=http://localhost:5493/sdata/accounts50/GCRM/{C4C863BE-B098-4A7D-A78B-D7A92B8ADB59};User=Manager;Password=xxxxxx;SELECT * FROM TradingAccounts
http://cdn.cdata.com/help/CSE/jdbc/pg_select.htm
Sage Business Cloud Accountingjdbc:sagebcaccounting:InitiateOAuth=GETANDREFRESH;SELECT * FROM SampleTable_1 http://cdn.cdata.com/help/GAE/jdbc/pg_select.htm
Sage Intacctjdbc:sageintacct:User='myusername';CompanyID='TestCompany';Password='mypassword';SenderID='Test';SenderPassword='abcde123';SELECT * FROM Customer http://cdn.cdata.com/help/CTE/jdbc/pg_select.htm
Salesforcejdbc:salesforce:User=myUser;Password=myPassword;Security Token=myToken;SELECT * FROM Account
http://cdn.cdata.com/help/RFE/jdbc/pg_select.htm
Salesforce Chatterjdbc:salesforcechatter:InitiateOAuth=GETANDREFRESH;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;CallbackURL=https://localhost:34343;SELECT * FROM Users http://cdn.cdata.com/help/BFE/jdbc/pg_select.htm
Salesforce Einstein Analyticsjdbc:sfeinsteinanalytics:InitiateOAuth=GETANDREFRESH;OAuthClientId=MyConsumerKey;OAuthClientSecret=MyConsumerSecret;CallbackURL=http://localhost:portNumberSELECT * FROM Dataset_Opportunity http://cdn.cdata.com/help/FSE/jdbc/pg_select.htm
Salesforce Marketing Cloudjdbc:sfmarketingcloud:User=myUser;Password=myPassword;SELECT * FROM Subscriber http://cdn.cdata.com/help/FEE/jdbc/pg_select.htm
Salesforce Pardotjdbc:salesforcepardot: ApiVersion=4;User=YourUsername;Password=YourPassword;UserKey=YourUserKey;SELECT * FROM Prospects http://cdn.cdata.com/help/GPE/jdbc/pg_select.htm
SAP Business Onejdbc:sapbusinessone:Url=http://localhost:50000/b1s/v1;User=username;Password=password;CompanyDB=dbname;SELECT * FROM Orders
http://cdn.cdata.com/help/FVE/jdbc/pg_select.htm
SAP Business One DIjdbc:sapbusinessonedi:Server=ServerName;DBServerType=MSSQL_2016;CompanyDB=SBODemoCA;User=manager;Password=manager;SELECT AcctCode, AcctName AS My_AcctName, GETDATE() FROM OACT WHERE AcctName = 'account_name'
http://cdn.cdata.com/help/GDE/jdbc/pg_resultsetmetadatajdbc.htm
SAP ByDesignjdbc:sapbydesign:URL=https://my999999.sapbydesign.com;User=username;Password=password;CustomService=servicename;SELECT * FROM Account http://cdn.cdata.com/help/UYE/jdbc/pg_select.htm
SAP Concurjdbc:sapconcur:InitiateOAuth=GETANDREFRESH;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;SELECT * FROM Departments http://cdn.cdata.com/help/FNE/jdbc/pg_select.htm
SAP ERPjdbc:saperp:Host=sap.mydomain.com;User=EXT90033;Password=xxx;Client=800;System Number=09;ConnectionType=Classic;SELECT * FROM MARA http://cdn.cdata.com/help/RYE/jdbc/pg_select.htm
SAP HANAjdbc:saphana:User=system;Password=mypassword;Server=localhost;Database=systemdb;"SELECT Id, ProductName AS My_ProductName, GETDATE() FROM Products WHERE ProductName = 'Konbu'
http://cdn.cdata.com/help/SNE/jdbc/pg_resultsetmetadatajdbc.htm"
SAP Hybris Cloud for Customerjdbc:saphybrisc4c:User=user;Password=password;SELECT * FROM AccountCollection
http://cdn.cdata.com/help/OHE/jdbc/pg_select.htm
SAP SuccessFactorsjdbc:sapsuccessfactors:User=username;Password=password;CompanyId=CompanyId;Url=https://api4.successfactors.comSELECT * FROM SampleTable_1 http://cdn.cdata.com/help/GBE/jdbc/pg_select.htm
SAP Sybase ASEjdbc:sybase:user=myuser;password=mypassword;Server=localhost;Database=Northwind"SELECT Id, ProductName AS My_ProductName, GETDATE() FROM Products WHERE ProductName = 'Konbu'
http://cdn.cdata.com/help/OYE/jdbc/pg_resultsetmetadatajdbc.htm"
SAP Sybase IQjdbc:sybaseiq:user=myuser;password=mypassword;Server=localhost;Database=NorthwindSELECT Id, ProductName AS My_ProductName, GETDATE() FROM Products WHERE ProductName = 'Konbu'
http://cdn.cdata.com/help/GYE/jdbc/pg_resultsetmetadatajdbc.htm
ServiceNowjdbc:servicenow:OAuthAccessToken=MyOAuthAccessToken;Instance=MyInstance;SELECT * FROM incident
http://cdn.cdata.com/help/BNB/jdbc/pg_select.htm
SharePointjdbc:sharepoint:User=MyUserAccount;Password=MyPassword;Auth Scheme=NTLM;URL=http://sharepointserver/mysite;SELECT * FROM Calendar
http://cdn.cdata.com/help/RSE/jdbc/pg_select.htm
Shopifyjdbc:shopify:AppId=MyAppId;Password=MyPassword;ShopUrl=https://yourshopname.myshopify.com;SELECT * FROM Customers http://cdn.cdata.com/help/FOE/jdbc/pg_select.htm
Slackjdbc:slack:InitiateOAuth=GETANDREFRESH;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;CallbackURL=http://localhost:33333;SELECT * FROM Channels http://cdn.cdata.com/help/FCE/jdbc/pg_select.htm
Smartsheetjdbc:smartsheet:InitiateOAuth=GETANDREFRESH;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;CallbackURL=http://localhost:33333;SELECT * FROM Sheet_Test_Sheet http://cdn.cdata.com/help/BSE/jdbc/pg_select.htm
Snowflakejdbc❄️url=https://myaccount.region.snowflakecomputing.com;user=Admin;password=test123;Database=Northwind;Warehouse=TestWarehouse;Account=Tester1;SELECT * FROM Products http://cdn.cdata.com/help/OWE/jdbc/pg_select.htm
Spark SQLjdbc:sparksql:Server=127.0.0.1;SELECT * FROM Customers
http://cdn.cdata.com/help/ESE/jdbc/pg_select.htm
Splunkjdbc:splunk:user=MyUserName;password=MyPassword;URL=MyURL;SELECT * FROM DataModels http://cdn.cdata.com/help/FUE/jdbc/pg_select.htm
SQL Serverjdbc:sql:user=myuser;password=mypassword;Server=localhost;Database=Northwind;SELECT Id, ProductName AS My_ProductName, GETDATE() FROM Products WHERE ProductName = 'Konbu'
http://cdn.cdata.com/help/RUE/jdbc/pg_resultsetmetadatajdbc.htm
SugarCRMjdbc:sugarcrm:URL=http://mySugarCRM.com;User=myUser;Password=myPassword;SELECT * FROM Accounts
http://cdn.cdata.com/help/CCE/jdbc/pg_select.htm
SurveyMonkeyjdbc:surveymonkey:InitiateOAuth=GETANDREFRESH;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;CallbackURL=http://localhost:portNumber;SELECT * FROM MySurvey_Responses http://cdn.cdata.com/help/FME/jdbc/pg_select.htm
Teradatajdbc:teradata:User=Admin;Password=test123;Database=Northwind;DataSource=127.0.0.1SELECT ProductId, ProductName AS My_ProductName, GETDATE() FROM NorthwindProducts WHERE CategoryId = '5'
http://cdn.cdata.com/help/OTE/jdbc/pg_resultsetmetadatajdbc.htm
Twiliojdbc:twilio:AccountSid=MyAccountSid;AuthToken=MyAuthToken;SELECT * FROM Applications
http://cdn.cdata.com/help/BTE/jdbc/pg_select.htm
Twitterjdbc:twitter:InitiateOAuth=GETANDREFRESH;SELECT * FROM Tweets
http://cdn.cdata.com/help/RTE/jdbc/pg_select.htm
Veeva Vaultjdbc:veevavault:Url=myURL;User=myUser;Password=myPassword;SELECT * FROM Documents http://cdn.cdata.com/help/SVE/jdbc/pg_select.htm
Wasabijdbc:wasabi:AccessKey=a123;SecretKey=s123;SELECT * FROM Buckets http://cdn.cdata.com/help/UWE/jdbc/pg_select.htm
WordPressjdbc:wordpress:Url=http://www.yourwordpresshost.com;User=yourUsername;Password=yourPassword;SELECT * FROM Categories http://cdn.cdata.com/help/FWE/jdbc/pg_select.htm
Xerojdbc:xero:InitiateOAuth=GETANDREFRESH;SELECT * FROM Contacts
http://cdn.cdata.com/help/DXE/jdbc/pg_select.htm
Xero Workflow Maxjdbc:xeroworkflowmax:APIKey=myApiKey;AccountKey=myAccountKey;SELECT * FROM Clients
http://cdn.cdata.com/help/GXE/jdbc/pg_select.htm
XMLjdbc:xml:DataModel=Relational;URI=C:\people.xml;SELECT * FROM NorthwindOData http://cdn.cdata.com/help/DVE/jdbc/pg_select.htm
YouTube Analyticsjdbc:youtubeanalytics:InitiateOAuth=GETANDREFRESH;ContentOwnerId=MyContentOwnerId;ChannelId=ChannelId;SELECT * FROM Groups http://cdn.cdata.com/help/BYE/jdbc/pg_select.htm
YouTube Datajdbc:youtube:InitiateOAuth=GETANDREFRESH;SELECT * FROM Videos http://cdn.cdata.com/help/CGE/jdbc/pg_select.htm
Zendeskjdbc:zendesk:URL=https://subdomain.zendesk.com;[email protected];Password=test123;SELECT * FROM Tickets http://cdn.cdata.com/help/FZE/jdbc/pg_select.htm
ZohoCRMjdbc:zohocrm:User='[email protected]';Password='myPassword';
AuthToken='1a2b3c4d5e6f...';		SELECT * FROM Accounts
http://cdn.cdata.com/help/CZA/jdbc/pg_select.htm
Microsoft Exchangejdbc:zohocrm:InitiateOAuth=GETANDREFRESH;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;CallbackURL=http://localhost:33333SELECT * FROM Accounts
http://cdn.cdata.com/help/CZE/jdbc/pg_select.htm

Updated 6 days ago

Did this page help you?