Importing or Creating Schemas

Follow the instructions below to import a predefined schema or create a custom schema for an existing structured data source.

  1. In the Anzo console, expand the Onboard menu and click Structured Data. Anzo displays the Data Sources screen, which lists any existing data sources. For example:

  2. On the Data Sources screen, click the name of the source for which you want to import or create a schema. Anzo displays the details for the source. For example:

  3. Click the Schemas tab. Anzo lists any schemas associated with the source. For example:

  4. If you want to import one or more predefined schemas, follow these steps:
    1. Click the Import Schemas button. Anzo displays the Import Schemas dialog box. For example:

      If you do not see a schema that you expect to see, make sure that you have the necessary access to the data source.

    2. Select the checkbox next to each schema that you want to import, and then click OK. Anzo imports the selected schemas.
  5. If you want to create a schema by writing an SQL statement that specifies a customized set of data to retrieve, follow these steps:
    1. Click the Create Schemas From Query button. Anzo displays the Create Schemas dialog box:

    2. In the Create Schemas dialog box, specify a name for the schema in the Schema Name field.
    3. In the Table Name field, specify a name for the schema table.
    4. Type the SQL statement in the text box. The statement can include any functionality that the database supports. Anzo does not validate the SQL. For information about writing a schema query that onboards data from a database incrementally, see Onboarding Data from a Database Incrementally.
    5. Click Save to save the query.

For information about working with schema tables, see Modifying Schemas.

Related Topics