Database Connection Settings

For successful connection and indexing, valid Database Collection settings must be provided along with valid query for Database collection.
To index databases like MySQL, SQL Server, Oracle, and PostgreSQL, the required database collections settings are:

  • Database Type
  • Host IP/Name
  • Host Port No.
  • Database Name
  • Database Username
  • Database Password

Other database connectors require the Database URL String.

Database Connection Settings for Databases

MySQL Settings

1812

SQL Server Settings

1780

📘

SearchBlox supports MS SQL Server versions later than 2012.

SQL Server Configuration

SQL Server has a dynamic port. In order to set the listening port (the host port in the image), follow the steps shown here: http://msdn.microsoft.com/en-us/library/ms177440.aspx.

Enter the port number in the dynamic port (see screenshots).

  1. Enter 1433 as the dynamic port for 10.200.2.9 and 127.0.0.1, and nothing in TCP port.
  2. If there are other IPs, enter 0 as the dynamic port.
  3. In IPAll, enter 1433 as TCP Port.
  4. Restart SQL Server and test the connection in SearchBlox.
    (ref: https://www.spdockit.com/support/help/faq/troubleshooting-sql-server/configure-sql-server-listen-specific-port/)
427 425

Oracle Settings

1799

Postgre SQL

1631

Database Connection Settings for Other Database Connectors

Database URL String has to be provided as shown in the screenshot for other database connectors listed in the section Database Connectors

1837

Database Connectors

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

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 Analytics jdbc: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
Alfresco jdbc: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 Athena jdbc: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 Marketplace jdbc: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 RedShift jdbc: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 S3 jdbc:amazons3:AccessKey=a123;SecretKey=s123;SELECT * FROM Buckets http://cdn.cdata.com/help/SXE/jdbc/pg_select.htm
Apache HBase jdbc:apachehbase:Server=127.0.0.1;Port=8080;SELECT * FROM Account
http://cdn.cdata.com/help/RHE/jdbc/pg_select.htm
Apache Hive jdbc:apachehive:Server=127.0.0.1;Port=10000;TransportMode=BINARYSELECT * FROM Customers
http://cdn.cdata.com/help/FIE/jdbc/pg_select.htm
Apache Phoenix jdbc: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
Bugzilla jdbc:bugzilla: Url=http:///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
CosmosDB jdbc: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
CSV jdbc:csv:GenerateSchemaFiles=OnStart;URI=https://MyAPI;Location=C:\MySchemaFolder;SELECT * FROM NorthwindOData http://cdn.cdata.com/help/RVE/jdbc/pg_select.htm
DocuSign jdbc: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 Central jdbc: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 Online jdbc: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 Ads jdbc:googleads:InitiateOAuth=GETANDREFRESH;DeveloperToken=myDeveloperToken;ClientCustomerId=myClientCustomerId;SELECT * FROM CampaignPerformance :: http://cdn.cdata.com/help/DZE/jdbc/pg_select.htm
Google Ads Manager jdbc: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 Directory jdbc:googledirectory:InitiateOAuth=GETANDREFRESH;SELECT * FROM Group http://cdn.cdata.com/help/EUE/jdbc/pg_select.htm
Google Drive jdbc:googledrive:InitiateOAuth=GETANDREFRESH;SELECT * FROM Files :: http://cdn.cdata.com/help/RGE/jdbc/pg_select.htm
Google Search jdbc:googlesearch:ApiKey=abc123; CustomSearchID=def456;"SELECT * FROM WebSearch WHERE SearchTerms = 'Fantastic Four'
http://cdn.cdata.com/help/BLE/jdbc/pg_select.htm"
Google Spanner jdbc: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 SpreadSheets jdbc: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
Instagram jdbc:instagram:InitiateOAuth=GETANDREFRESH;BusinessAccountId=3218475SELECT * FROM Users http://cdn.cdata.com/help/ENE/jdbc/pg_select.htm
JDBC-ODBC Bridge jdbc: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
JIRA jdbc:jira:User=admin;APIToken=myApiToken;Url=https://yoursitename.atlassian.netSELECT * FROM Projects http://cdn.cdata.com/help/BJE/jdbc/pg_select.htm
JSON jdbc:json:DataModel=Relational;URI=C:\people.jsonSELECT * FROM NorthwindOData http://cdn.cdata.com/help/DJE/jdbc/pg_select.htm
Kintone jdbc:kintone:User=myuseraccount;Password=mypassword;Url=http://subdomain.domain.com;GuestSpaceId=myspaceidSELECT * FROM Comments http://cdn.cdata.com/help/EKE/jdbc/pg_select.htm
LDAP jdbc: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
MailChimp jdbc:mailchimp:APIKey=myAPIKey;SELECT * FROM Lists http://cdn.cdata.com/help/CME/jdbc/pg_select.htm
MariaDB jdbc: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
MarkLogic jdbc:marklogic:User='myusername';Password='mypassword';Server='marklogic'SELECT * FROM Customer http://cdn.cdata.com/help/OME/jdbc/pg_select.htm
Microsoft Exchange jdbc: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 Planner jdbc: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 Project jdbc: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
MYOB jdbc: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
MySQL jdbc: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 Cloud jdbc:oraclesalescloud:HostURL=https://my.host.oraclecloud.com; Username=abc123; Password=abcdef;SELECT * FROM Opportunities
http://cdn.cdata.com/help/EOE/jdbc/pg_select.htm
Pinterest jdbc:pinterest:InitiateOAuth=GETANDREFRESH;OAuthClientId=YourClientId;OAuthClientSecret=YourClientSecret;CallbackURL='https://localhost:33333'SELECT * FROM USERS http://cdn.cdata.com/help/UPE/jdbc/pg_select.htm
PostgreSQL jdbc: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
Redis jdbc:redis:Server=127.0.0.1;Password=myPassword;SELECT * FROM Customers http://cdn.cdata.com/help/EIE/jdbc/pg_select.htm
REST jdbc: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 Accounting jdbc:sagebcaccounting:InitiateOAuth=GETANDREFRESH;SELECT * FROM SampleTable_1 http://cdn.cdata.com/help/GAE/jdbc/pg_select.htm
Sage Intacct jdbc: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 Chatter jdbc: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 Analytics jdbc: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 Cloud jdbc:sfmarketingcloud:User=myUser;Password=myPassword;SELECT * FROM Subscriber http://cdn.cdata.com/help/FEE/jdbc/pg_select.htm
Salesforce Pardot jdbc:salesforcepardot: ApiVersion=4;User=YourUsername;Password=YourPassword;UserKey=YourUserKey;SELECT * FROM Prospects http://cdn.cdata.com/help/GPE/jdbc/pg_select.htm
SAP Business One jdbc: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 DI jdbc: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 ByDesign jdbc: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 ERP jdbc: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 HANA jdbc: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 Customer jdbc:saphybrisc4c:User=user;Password=password;SELECT * FROM AccountCollection
http://cdn.cdata.com/help/OHE/jdbc/pg_select.htm
SAP SuccessFactors jdbc: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 ASE jdbc: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
Shopify jdbc: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 SQL jdbc:sparksql:Server=127.0.0.1;SELECT * FROM Customers
http://cdn.cdata.com/help/ESE/jdbc/pg_select.htm
Splunk jdbc:splunk:user=MyUserName;password=MyPassword;URL=MyURL;SELECT * FROM DataModels http://cdn.cdata.com/help/FUE/jdbc/pg_select.htm
SQL Server jdbc: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
SurveyMonkey jdbc: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
Teradata jdbc: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 Vault jdbc:veevavault:Url=myURL;User=myUser;Password=myPassword;SELECT * FROM Documents http://cdn.cdata.com/help/SVE/jdbc/pg_select.htm
Wasabi jdbc:wasabi:AccessKey=a123;SecretKey=s123;SELECT * FROM Buckets http://cdn.cdata.com/help/UWE/jdbc/pg_select.htm
WordPress jdbc: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 Max jdbc:xeroworkflowmax:APIKey=myApiKey;AccountKey=myAccountKey;SELECT * FROM Clients
http://cdn.cdata.com/help/GXE/jdbc/pg_select.htm
XML jdbc: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 Data jdbc:youtube:InitiateOAuth=GETANDREFRESH;SELECT * FROM Videos http://cdn.cdata.com/help/CGE/jdbc/pg_select.htm
Zendesk jdbc:zendesk:URL=https://subdomain.zendesk.com;User=[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