Connector Dialog for Splunk

Port

The port number required to access the data source.

Tables & Views

Allows you to load, and then select, the tables from your database by manually selecting from a list.

To fetch apps:

1. Select the app to open using the dropdown provided.

2. Click Fetch Apps.

To load saved searches:

1. Click Load Saved Searches to load a list of predefined tables or views. These are displayed on the Tables List (at the left side of the dialog box).

2. Select a table from the Tables List.

   The columns of the table are displayed in the Columns List (beside the Tables List).

3. Select the columns to add to your data table by checking the column boxes.

Note: If you wish to add a duplicate column, select this column from the Add a duplicate column drop-down list provided.

To select a column:

Check the boxes beside the columns you want to use. If you want to use all columns, check the Column box on the header.

To aggregate columns:

If the data returned are to be aggregated, check the Aggregate box on the header, then select the aggregation method you want to use for each column.

The following aggregation methods are possible for each data type:

To filter columns:

If the data returned are to be filtered, check the Apply Filter on the header. Then, for each column, select a filter method from the filter drop down and then enter the filter value in the Filter Value box.

Notes:

• If you are unsure about the filter value format of the Date field, hover on the Filter Value text box to display a tooltip hint:

• Some data sources require case-sensitive filter values. Refer to this list to check which data sources have case-sensitive filters.
• To load tables and views using an SQL Query, select the Query tab.

Preview Data

Click to fetch data using the credentials and criteria you have specified. This allows you to confirm your connection, ensure you have connected to the correct table, check your query, and verify the information that will be loaded.

Notes:

• Only 10 records are displayed to allow you to verify that you are selecting the correct data. This limit prevents system slow down.

• The button is only enabled if the connection is active and the query is correct. Check your connection or your query if one of the buttons is disabled.

OK/CANCEL

Select OK to establish the connection and fetch data or Cancel to close the dialog. 

The state of the OK and PREVIEW buttons provides a handy status about the state of your connection:

• The OK and PREVIEW DATA buttons are enabled as soon as the required fields have been entered and verified. This usually means a connection to the data source has been established and a table has been selected.

• The OK button is disabled when an update is made that can lead to an invalid result (e.g. the User Name or Password is not valid, or the the SQL statement in the Query tab is invalid). In such cases, use  PREVIEW DATA to validate that data can be retrieved. If this fails verify your connection information or query until data can be retrieved.