When creating a custom integration via Information Centric Analytics ( ICA ) through the Integration Wizard you will be required to create a data source within Risk Fabric.
In the current version of ICA we support the ability to create data sources for the following Data Source Types: SQL Server, Splunk, ArcSight, Dropbox, file systems for flat file integrations, and Q Radar. This TECH NOTE will guide you through the process of creating a data source query for SQL Server based data sources.
1. Navigate to the Integration application under Admin -> Integration.
Figure 1 Navigate to the Integration application through Admin Menu
2. By accessing the integration menu, ICA will deliver you to the Integration Packs tab by default. This tab displays a comprehensive listing of all Integration Packs configured for your instance of ICA. By default, there are no integration packs configured for ICA. In the figure below, you can see that there are two Integration Packs configured in our demonstration system, the Risk Fabric Active Directory Integration Pack and the Risk Fabric Symantec Data Loss Prevention Integration Pack.
Figure 2 This figure depicts the Integration Packs tab
3. Navigate to the Data Sources tab next to the Integration Packs tab. The Data Sources Tab will provide you with a comprehensive list of all data sources currently configured for the ICA application. By default, no data sources are configured for ICA out-of-the-box. In the figure below, we have a data source configured for demonstration purposes. To create a data source, click on the Create Data Source button to the left of the Edit button.
Figure 3 This figure depicts the Data Sources tab, it displays all data sources configured within ICA
Figure 5 Verify Linked Servers within SQL Server Management Studio