Developer Tool Guide > Physical Data Objects > Nonrelational Data Objects
  

Nonrelational Data Objects

Import a nonrelational data object to use in a mapping, mapplet, or profile. A nonrelational data object is a physical data object that uses a nonrelational data source.
You can import nonrelational data objects for the following connection types:
When you import a nonrelational data object, the Developer tool reads the metadata for the object from its PowerExchange data map. A data map associates nonrelational records with relational tables so that the product can use the SQL language to access the data. To create a data map, use the PowerExchange Navigator.
After you import the object, you can include its nonrelational operations as read, write, or lookup transformations in mappings and mapplets. Each nonrelational operation corresponds to a relational table that the data map defines. To view the mapping of fields in one or more nonrelational records to columns in the relational table, double-click the nonrelational operation in the Object Explorer view.
For more information about data maps, see the PowerExchange Navigator Guide.

Importing Nonrelational Data Objects

Import one or more nonrelational data objects to use in a mapping, mapplet, or profile.
Before you import a nonrelational data object, you need to configure a connection to the database or data set. You also need to create a data map for the object.
    1. Select a project or folder in the Object Explorer view.
    2. Click File > New > Data Object.
    3. Select Non-relational Data Object and click Next.
    The New Non-relational Data Object dialog box appears.
    4. Optionally, enter a name for the physical data object.
    5. Click Browse next to the Connection option and select a connection.
    6. Click Browse next to the Data Map option.
    The Select a Data Map dialog box appears.
    7. Optionally, enter filter criteria.
    8. In the Resources area, expand the connection and schemas as needed and select the desired data maps.
    9. Click OK to close the Select a Data Map dialog box, and then click Finish.
    The nonrelational data objects and corresponding nonrelational operations appear under the connection name under Physical Data Objects in the project or folder in the Object Explorer view.
Note: You can also import nonrelational data objects by using the Connection Explorer view.

Creating a Read, Write, or Lookup Transformation from Nonrelational Data Operations

You can add a nonrelational data operation to a mapping or mapplet as a read, write, or lookup transformation.
    1. Open the mapping or mapplet in which you want to create a read, write, or lookup transformation.
    2. In the Object Explorer view, select one or more nonrelational data operations.
    3. Drag the nonrelational data operations into the mapping editor.
    The Add to Mapping dialog box appears.
    4. Select the Read, Write, or Lookup option.
    As independent data object(s) is automatically selected.
    5. Click OK.
    The Developer tool creates a read, write, or lookup transformation for each nonrelational data operation.