Configuring Microsoft SQL Server (Klassify) Connectors
Connectors allow Stellar Cyber to collect data from external sources and add it to the data lake. You can install a connector to retrieve data from a Microsoft SQL Server (MSSQL) database.
This Microsoft SQL Server connector collects Klassify logs stored in the database. The connector can run on a network/security/modular data sensor.
Klassify is the only supported data source.
Connector Overview: Microsoft SQL Server (Klassify)
Capabilities
-
Collect: Yes
-
Respond: No
-
Native Alerts Mapped: No
-
Runs on: Sensor
-
Interval: Configurable
Collected Data
Content Type |
Index |
Locating Records |
---|---|---|
Classification Logs Client agent status Logs Email Logs Reclassification and policy deviation Logs |
Syslog
|
Domain
<Server hostname or IP> where <Server hostname or IP> is a variable from the configuration of this connector |
Response Actions
N/A
Third Party Native Alert Integration Details
N/A
Required Credentials
-
Server hostname or IP, Username, Password, and Database Name
Let us know if you find the above overview useful.
Adding a MSSQL Connector
To add a MSSQL connector:
Adding the Connector in Stellar Cyber
To add a MSSQL connector in Stellar Cyber:
-
Log in to Stellar Cyber.
-
Click System | Integration | Connectors. The Connector Overview appears.
-
Click Create. The General tab of the Add Connector screen appears. The information on this tab cannot be changed after you add the connector.
The asterisk (*) indicates a required field.
-
Choose Database from the Category drop-down.
-
Choose Microsoft SQL Server from the Type drop-down.
-
For this connector, the supported Function is Collect, which is enabled already.
-
Enter a Name.
This field does not accept multibyte characters.
-
Choose a Tenant Name. The Interflow records created by this connector include this tenant name.
-
Choose the device on which to run the connector.
-
(Optional) When the Function is Collect, you can create Log Filters. For information, see Managing Log Filters.
-
Click Next. The Configuration tab appears.
The asterisk (*) indicates a required field.
-
Enter the Server hostname or IP. This is the hostname or IP address of the MSSQL server. If entering a hostname, do not include https.
-
Enter the Username of a user with read access to the database.
-
Enter the Password for that user.
-
Enter the Database Name. This is the name of the database you want to access on the above server.
-
Choose the Data Source. Currently the only data source is Klassify.
-
Choose the Interval (min). This is how often the logs are collected.
-
Choose the Content Type you would like to collect. The logs for Classification Logs, Client agent status Logs, Email Logs, and Reclassification and policy deviation Logs are supported.
-
Click Next. The final confirmation tab appears.
-
Click Submit.
To pull data, a connector must be added to a Data Analyzer profile if it is running on the Data Processor.
The new connector is immediately active.
Testing the Connector
When you add (or edit) a connector, we recommend that you run a test to validate the connectivity parameters you entered. (The test validates only the authentication / connectivity; it does not validate data flow).
For connectors running on a sensor, Stellar Cyber recommends that you allow 30-60 seconds for new or modified configuration details to be propagated to the sensor before performing a test.
-
Click System | Integrations | Connectors. The Connector Overview appears.
-
Locate the connector that you added, or modified, or that you want to test.
-
Click Test at the right side of that row. The test runs immediately.
Note that you may run only one test at a time.
Stellar Cyber conducts a basic connectivity test for the connector and reports a success or failure result. A successful test indicates that you entered all of the connector information correctly.
To aid troubleshooting your connector, the dialog remains open until you explicitly close it by using the X button. If the test fails, you can select the button from the same row to review and correct issues.
The connector status is updated every five (5) minutes. A successful test clears the connector status, but if issues persist, the status reverts to failed after a minute.
Repeat the test as needed.
Verifying Ingestion
To verify ingestion:
- Click Investigate | Threat Hunting. The Interflow Search tab appears.
- Change the Indices to Syslog. The table immediately updates to show ingested Interflow records.