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 information tab only.
    • Refer to Connectivity Hub API.
    • Skip the AD 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

      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

      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. Refer to Managing Content Metadata
  4. Index your data and being searching. Refer to How to Index Your Content.