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
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).
- Enter 1433 as the dynamic port for 10.200.2.9 and 127.0.0.1, and nothing in TCP port.
- If there are other IPs, enter 0 as the dynamic port.
- In IPAll, enter 1433 as TCP Port.
- 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 Name | Database URL String | Sample Query |
|---|---|---|
| Active Directory | jdbc: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 DynamoDB | jdbc: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=BINARY | SELECT * 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.Net | jdbc:authorizenet:LoginID=myLoginID;TransactionKey=myTransactionKey | SELECT * FROM SettledBatchList http://cdn.cdata.com/help/CWE/jdbc/pg_select.htm |
| Azure Table Storage | jdbc:azuretables:AccessKey=myAccessKey;Account=myAccountName; | SELECT * FROM NorthwindProducts http://cdn.cdata.com/help/CAE/jdbc/pg_select.htm |
| BaseCamp | jdbc:basecamp:InitiateOAuth=GETANDREFRESH;AccountId=1234567;Schema=V3;ProjectId=abcd1234 | SELECT * FROM Projects http://cdn.cdata.com/help/BCE/jdbc/pg_select.htm |
| Box | jdbc: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 |
| Cassandra | jdbc: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 |
| Couchbase | jdbc: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:33333 | SELECT * FROM Account http://cdn.cdata.com/help/UCE/jdbc/pg_select.htm |
| DropBox | jdbc: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 Operations | jdbc:d365finop:InitiateOAuth=GETANDREFRESH;OrganizationUrl=https://myaccount.operations.dynamics.com/; | SELECT * FROM Accounts http://cdn.cdata.com/help/FFE/jdbc/pg_select.htm |
| Dynamics 365 Sales | jdbc:d365sales:InitiateOAuth=GETANDREFRESH;OrganizationUrl=https://myaccount.crm.dynamics.com/; | SELECT * FROM Accounts http://cdn.cdata.com/help/ERE/jdbc/pg_select.htm |
| Dynamics CRM | dbc: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 GP | jdbc: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 NAV | jdbc: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 |
| Elasticsearch | jdbc:elasticsearch:Server=127.0.0.1;Port=9200; | SELECT * FROM Account http://cdn.cdata.com/help/EEE/jdbc/pg_select.htm |
| Eloqua | jdbc:oracleeloqua:User=user;Password=password;Company=MyCompany | SELECT * FROM Contact http://cdn.cdata.com/help/DUE/jdbc/pg_select.htm |
jdbc 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 Online | jdbc:exactonline:InitiateOAuth=GETANDREFRESH;Region='United States';Division=5512; | SELECT * FROM Accounts http://cdn.cdata.com/help/DYE/jdbc/pg_select.htm |
| Excel | jdbc: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 Services | jdbc: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 |
| jdbc:facebook:InitiateOAuth=GETANDREFRESH; | SELECT * FROM Statuses http://cdn.cdata.com/help/RBE/jdbc/pg_select.htm | |
| Gmail | jdbc: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=GETANDREFRESH | SELECT * FROM Orders http://cdn.cdata.com/help/BDE/jdbc/pg_select.htm |
| Google Analytics | jdbc:googleanalytics:InitiateOAuth=GETANDREFRESH;Profile=myProfile; | SELECT * FROM Traffic http://cdn.cdata.com/help/DAE/jdbc/pg_select.htm |
| Google BigQuery | jdbc: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 Manager | jdbc: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=NorthwindOrders | SELECT * FROM Spreadsheet1_Sheet1 http://cdn.cdata.com/help/RLE/jdbc/pg_select.htm |
| HPCC | jdbc: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 |
| HubSpot | jdbc:hubspot:InitiateOAuth=GETANDREFRESH; | "SELECT * FROM Contacts http://cdn.cdata.com/help/DHE/jdbc/pg_select.htm" |
| LDAP | jdbc:ldap:user=myuseraccount;password=mypassword; | SELECT * FROM User http://cdn.cdata.com/help/RJA/jdbc/pg_select.htm |
| jdbc:instagram:InitiateOAuth=GETANDREFRESH;BusinessAccountId=3218475 | SELECT * FROM Users http://cdn.cdata.com/help/ENE/jdbc/pg_select.htm | |
| JDBC-ODBC Bridge | jdbc:jdbcodbc:Driver={SQL Server};Server=localhost;Database=AdventureWorks | SELECT 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.net | SELECT * FROM Projects http://cdn.cdata.com/help/BJE/jdbc/pg_select.htm |
| JSON | jdbc:json:DataModel=Relational;URI=C:\people.json | SELECT * 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=myspaceid | SELECT * 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 |
| jdbc:linkedin:InitiateOAuth=GETANDREFRESH;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;CallbackURL=http://localhost:portNumber;CompanyId=XXXXXXX | SELECT * FROM CompanyStatusUpdates http://cdn.cdata.com/help/CLE/jdbc/pg_select.htm | |
| Magento | jdbc:magento:Schema=magento2;User=admin;Password=admin;Url=https://mymagentohost/magento2 | SELECT * 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 |
| Marketo | jdbc: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 Teams | jdbc:msteams:InitiateOAuth=GETANDREFRESH;OAuthClientId=MyApplicationId;OAuthClientSecret=MySecretKey;CallbackURL=http://localhost:33333; | SELECT * FROM Teams http://cdn.cdata.com/help/GSE/jdbc/pg_select.htm |
| MongoDB | jdbc: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 |
| OData | jdbc:odata:User=myuseraccount;Password=mypassword;URL=http://myserver/myOrgRoot; | SELECT * FROM Lead http://cdn.cdata.com/help/RDE/jdbc/pg_select.htm |
| Office 365 | jdbc: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 Database | jdbc: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 |
| 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=5432 | SELECT ShipName, ShipCity AS My_ShipCity, GETDATE() FROM Orders WHERE ShipCountry = 'USA' http://cdn.cdata.com/help/FPE/jdbc/pg_resultsetmetadatajdbc.htm |
| Quandl | jdbc:quandl:ApiKey=abc123;DatabaseCode=WIKI; | SELECT * FROM AAPL http://cdn.cdata.com/help/BRE/jdbc/pg_select.htm |
| QuickBooks | jdbc:quickbooks:User=test;Password=test;URL=http://localhost:8166; | SELECT * FROM Customers http://cdn.cdata.com/help/RQE/jdbc/pg_select.htm |
| QuickBooks Online | jdbc:quickbooksonline:InitiateOAuth=GETANDREFRESH; | SELECT * FROM Customers http://cdn.cdata.com/help/RNE/jdbc/pg_select.htm |
| QuickBooks POS | jdbc: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=XML | SELECT * FROM NorthwindOData http://cdn.cdata.com/help/DWE/jdbc/pg_select.htm |
| RSS | jdbc:rss:URI=http://myservice/myfeed/; | SELECT * FROM RSSFeed http://cdn.cdata.com/help/RRE/jdbc/pg_select.htm |
| Sage 50 UK | jdbc: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 |
| Salesforce | jdbc: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:portNumber | SELECT * 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 Concur | jdbc: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.com | SELECT * 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 IQ | jdbc:sybaseiq: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/GYE/jdbc/pg_resultsetmetadatajdbc.htm |
| ServiceNow | jdbc:servicenow:OAuthAccessToken=MyOAuthAccessToken;Instance=MyInstance; | SELECT * FROM incident http://cdn.cdata.com/help/BNB/jdbc/pg_select.htm |
| SharePoint | jdbc: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 |
| Slack | jdbc:slack:InitiateOAuth=GETANDREFRESH;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;CallbackURL=http://localhost:33333; | SELECT * FROM Channels http://cdn.cdata.com/help/FCE/jdbc/pg_select.htm |
| Smartsheet | jdbc: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 |
| Snowflake | jdbc 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 |
| SugarCRM | jdbc: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.1 | SELECT ProductId, ProductName AS My_ProductName, GETDATE() FROM NorthwindProducts WHERE CategoryId = '5' http://cdn.cdata.com/help/OTE/jdbc/pg_resultsetmetadatajdbc.htm |
| Twilio | jdbc:twilio:AccountSid=MyAccountSid;AuthToken=MyAuthToken; | SELECT * FROM Applications http://cdn.cdata.com/help/BTE/jdbc/pg_select.htm |
| jdbc: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 |
| Xero | jdbc: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 Analytics | jdbc: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;[email protected];Password=test123; | SELECT * FROM Tickets http://cdn.cdata.com/help/FZE/jdbc/pg_select.htm |
| ZohoCRM | jdbc:zohocrm:User='[email protected]';Password='myPassword'; AuthToken='1a2b3c4d5e6f...'; | SELECT * FROM Accounts http://cdn.cdata.com/help/CZA/jdbc/pg_select.htm |
| Microsoft Exchange | jdbc:zohocrm:InitiateOAuth=GETANDREFRESH;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;CallbackURL=http://localhost:33333 | SELECT * FROM Accounts http://cdn.cdata.com/help/CZE/jdbc/pg_select.htm |
Updated 7 months ago