Simple No Security Sample

This example of building a connector is a simple model that features no security and includes structured data only - no files.

• It is based off the standard MS Adventure Works demo.

• If you do not have that available, you may download a zipped up backup of the complete database here.

• Have your database administrator restore this backup to a new database and create a SQL Server User and Password that has permission to read this database.

1. Create new entry and fill in the Connection Connection defines the how Connectivity Hub connects to your Source System (which contains your documents, graphics, etc.,). Your Connection includes identifying elements such as: URL of the BA Insight web service connector you are using, (File Share connector, SharePoint Online connector, etc.), Authentication mode, User Accounts and Credentials, Database information (for database connectors) information tab only.
   • Refer to Connectivity Hub API.
   • Skip the AD A directory service for Windows domain networks. A hierarchical structure that stores information about objects on the network. Used to manage permissions and control access to critical network resources. and Security SQL tab as they do not apply to this sample with no security.
2. Create a new SQL Based Content entry and use the following SQL statements and values for the named form fields:
   

   • Item Enumerator SQL

     Copy

     SELECT Production.Product.ModifiedDate AS SPW_LASTUPDATE,getdate() as
     SPW_CURRENTDATE,Production.Product.ProductID as SPW_ID
     FROM
      Production.Product INNER JOIN Production.ProductModel ON 
     Production.Product. ProductModelID = 
     Production.ProductModel.ProductModelID INNER JOIN
     Production.ProductSubcategory
      ON Production. Product.ProductSubcategoryID = 
     Production.ProductSubcategory. ProductSubcategoryID INNER JOIN
     Production.ProductCategory ON Production. ProductCategory.ProductCategoryID = Production.ProductSubcategory. ProductCategoryID
     WHERE Production.Product.ModifiedDate [SPW_LASTUPDATE]
     ORDER BY SPW_LASTUPDATE ASC

   • Item Extension
     txt

   • Item Definition

     Copy

     SELECT 'f' as 
     SPW_DELFLAG, Production.Product.Name, Production. Product.ProductNumber,
      Production.Product.MakeFlag, Production. Product.FinishedGoodsFlag,
     Production.Product.Color, Production.Product. SafetyStockLevel, Production.Product.ReorderPoint, Production.
     Product.StandardCost,
     Production.Product.ListPrice, Production.
      
     Product.Size, Production.Product.SizeUnitMeasureCode, Production. Product.WeightUnitMeasureCode,
     Production.Product.Weight, Production.Product. DaysToManufacture, Production.Product.ProductLine, Production.
     Product.Class,
     Production.Product.Style, Production.Product. SellStartDate, Production.Product.SellEndDate, Production.Product.
     DiscontinuedDate,
     Production.Product.ModifiedDate AS SPW_LASTUPDATE, Production.ProductModel.Name AS MODEL,
     Production.ProductModel.CatalogDescription,
      Production.ProductSubcategory.Name AS SUBCAT, Production. 
     ProductCategory.Name AS CAT,
     Production.Product.ProductID FROM Production.Product INNER JOIN
     Production.ProductModel ON Production.Product. ProductModelID = Production.ProductModel.ProductModelID INNER JOIN
     Production.ProductSubcategory
      ON Production. Product.ProductSubcategoryID = 
     Production.ProductSubcategory. ProductSubcategoryID INNER JOIN
     Production.ProductCategory ON Production. ProductCategory.ProductCategoryID = Production.ProductSubcategory. ProductCategoryID
     WHERE Production.Product.ProductID = [SPW_ID]

   • Unstructured Data Options: Pick 'Text' (Database Columns)
        [NAME] - [MODEL] - [CATALOGDESCRIPTION]
   • Item URL:
     • You need to create a destination page to show details.
     • The following URL is a sample, using the correct format:
          http://yourportal/pages/showinfo.aspx?ID=[PRODUCTID]
       

   • Item Title:
     [NAME]

   • Item Author: Leave blank.
3. Generate the Metadata Provides context with details such as the source, type, owner, and relationships to other data sets. Metadata provides details around the item being crawled by Connectivity Hub.. Refer to Managing Content Metadata
   
4. Index your data and being searching. Refer to How to Index Your Content.