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.

🚧

CentOS users workaround to access MSSQL Database:

Due to the server selected protocol version TLS10 is not accepted by client preferences, database connection will fail for CentOS users. To disable the TLS version follow the following steps:

NOTE : OpenJDK will be disabling TLS 1.0 and 1.1 availability by default in java.security file. Java applications using TLS to communicate will need to use TLS 1.2 or above to establish a connection.

  1. Go to OpenJDK installation path and go to OpenJDK/conf/Security folder and edit java.security file.
  2. Java.security can be found in /usr/lib/jvm/java-17-openjdk-amd64/conf/security may vary from system to system.
  3. You can edit this value in java.security file directly. Search for the property jdk.tls.disabledAlgorithms. For OpenJDK , it's contents will be similar to the following:

jdk.tls.disabledAlgorithms=SSLv3, TLSv1, TLSv1.1, RC4, DES, MD5withRSA, \ DH keySize < 1024, EC keySize < 224, 3DES_EDE_CBC, anon, NULL, \ include jdk.disabled.namedCurves.

  1. Look for TLSv1 or TLSv1.0 or TLSv1.1 and remove those versions if present on file.
    Example : Remove TLSv1 and TLSv1.1 from the list on the java.security of previous step.

jdk.tls.disabledAlgorithms=SSLv3, RC4, DES, MD5withRSA, \ DH keySize < 1024, EC keySize < 224, 3DES_EDE_CBC, anon, NULL, \ include jdk.disabled.namedCurves.

  1. Restart searchblox service.

Reference for java.security is shown below:

Database Connection Settings for Databases

MySQL Settings

SQL Server Settings

📘

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/)

Oracle Settings

Postgre SQL

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

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
Amazon Athena jdbc:amazonathena:AWSAccessKey='a123';AWSSecretKey='s123';AWSRegion='IRELAND';Database='sampledb';S3StagingDirectory='s3://bucket/staging/';SELECT * FROM Customers http://cdn.cdata.com/help/FKE/jdbc/pg_select.htm
Amazon DynamoDBjdbc:amazondynamodb:AWS Access Key=xxx;AWS Secret Key=xxx;Domain=amazonaws.com;AWS Region=OREGON;SELECT * FROM Account http://cdn.cdata.com/help/DDE/jdbc/pg_select.htm
Amazon Marketplace jdbc:amazonmarketplace:MWSAuthToken=myMWSAuthToken;SellerId=mySellerId;Marketplace=United States;Schema=Marketplace;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:AWSAccessKey=a123;AWSSecretKey=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 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:email: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;User=[[email protected]](mailto:[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
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
IBM DB2jdbc:db2:Server=10.0.1.2;Port=50000;User=admin;Password=admin;Database=test;
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
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
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 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 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:snowflake:url=https://myaccount.region.snowflakecomputing.com;user=Admin;password=test123;Database=Northwind;Warehouse=TestWarehouse;Account=Tester1;SELECT * FROM Products <https://cdn.cdata.com/help/OWJ/jdbc/default.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
Veeva Vault jdbc:veevavault:Url=myURL;User=myUser;Password=myPassword;SELECT * FROM Documents http://cdn.cdata.com/help/SVE/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
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:InitiateOAuth=GETANDREFRESH;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;CallbackURL=http://localhost:33333SELECT * FROM Accounts
http://cdn.cdata.com/help/CZA/jdbc/pg_select.htm
Zoho Projectsjdbc:zohoprojects:InitiateOAuth=GETANDREFRESH;SELECT * FROM Portals
<https://cdn.cdata.com/help/PZJ/jdbc/>

🚧

NOTE:

For Snowflake database, while providing SQL Query in Database Settings page , please provide the column names and table name in uppercase letter and define primary key as uid.

Ex : SELECT EMAIL as uid, NAME, PHONE FROM CDATA_TEST.PUBLIC.TEST;