Optional External Feed

External feeds allow you to send Guardium report data directly to an external database.

Sending reporting data to an external database is useful in several scenarios, for example when combining or correlating Guardium data with non-Guardium data, when using Guardium data with external reporting tools, or when machine-parsing records in especially large reports.

Before using external feeds, verify the following prerequisites:

Map a feed between Guardium and an external database. External feeds currently support relational databases and may not function with other database types.
Create a report defining the data to send via the external feed. Predefined reports will not work with external feeds. If you want to use a predefined reports, make a copy with the report and use the copy for the external feed.
Define an audit process that will use the external feed.

The first time that an optional external feed task runs, the necessary internal representation of the audit sources will be created. One limitation is that data that is time-stamped with a date earlier than the audit source creation date cannot be stored. This means that the first time the task runs, it will only export data for the current date. On subsequent executions of the task following that date, any data from that date forward can be exported. (In other words, the next day, you will be able to export that day's data plus the prior day's data.)

Create an Optional External Feed Task

If you have not yet started to define a compliance workflow automation process, see Create a Workflow Process before performing this procedure.

If the Add New Task pane is not open, click Add Audit Task.
Click External Feed.
Select the feed type from the Feed Type list. (The controls that appear next depend on the feed type selected.) One predefined feed type is Object Last Referenced.
Note: You must map an external feed before attempting to use this feature.
Select an event type from the Event Type list.
Select a report from the Report list. Depending on the report selected, a variable number of parameters appear in the Task Parameters pane.
In the Extract Lag box, enter the number of hours by which the feed is to lag, and mark the Continuous box to include data up to the time that the audit task runs. Extract Log only works when the Continuous box is marked.
In the Datasources pane, identify one or more datasources for the external feed. For instructions on how to define or select datasources, see Datasources.
Enter all parameter values in the Task Parameters pane. The parameters will vary depending on the report selected. Count column is not supported in External Feed.
Click Apply.