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.

4. 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.

5. 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

🚧

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;