You can create new data object either manually by adding required attributes or automatically from the database table or view or file structure.
Method I: Automatic creation
To create a data object by importing the structure corresponding to the tables or views from the database/schema or structure corresponding to the file data from layout file or data file, follow the steps in the page Importing Schema.
Method II: Manual creation
To create data object manually by adding attributes corresponding to the structure of table or view in database or structure of file data, follow below steps:
Step I: Navigate to New Data Object window in one of the following ways.
Option I: On the Navigation pane, mouseover the Data Object, and then click New.
Option II: On the Navigation pane click Data Object, and then on the actions menu, click New icon and select New.
Create New Data Objects window appears and prompts you to provide the details for the new data object.
Step II: In the Create New Data Objects window,
1. The window displays the list of supported data platforms, click and select a Data Platform.
Note: To search for a specific database, enter the keyword in search bar and the window displays the search result. Select the required data platform and click Ok.
2. Upon selecting the data platform, the window displays the list of data points for the selected platform. Select the data point (here we are considering Teradata Data point for reference) and click Next.
- To search for a specific project, from the project drop down, enter the keyword in the search bar, and the window displays the related projects.
- If there is any Global project that user has access to, then the Project drop-down will list them. Select the Global project from the list if the data object must be chosen from there. After selection, the canvas displays respective global data objects as per the database type.
- Upon selecting data platform as File, JSON, COBOL, AVRO, associated standard data points, rest data points, avro data points, GCS data points, AmazonS3 data points, JMS data points, and Kafka data points are displayed together in the available data points list.
3. Upon selecting the data point, the window displays the general properties for the selected data point.
- Previously selected Data Platform and Data Point names are displayed and they are non-editable.
- Name field displays the default Data Object name and it's editable. If required, define a name as per your requirement.
- In the Group Name field, either enter a new name or select a name from the existing list (here we are considering Teradata for reference).
- The Data Object Name should match the database table or view that needs to be accessed during runtime using this data object.
- Upon selecting a Global data point, the data point name in data object list page is appended with alphabet 'G'.
- To search for a specific group name, from the Group Name drop down, enter the keyword in the search bar, and the window displays the related group.
- To move back to previous step, click Back.
- To close the widow, click Cancel.
Click Ok, navigates you to the respective Data Object workspace.
Step III: The General Tab displays the following details:
1.The Name is auto populated and editable.
- To edit the connection name, click the icon next to name field.
- Edit Name window appears and allows you to change the name.
2. Group Name field displays the Group Name selected. Further if required, enter a new name or select a name from the existing list.
3. In the Description text-box, provide a description and is optional.
4. The details of the Data Object - corresponding parameter name, associated data point, associated data point database, displays whether it is transient object or not, type of data object, the user who last updated the data object along with date and time of last save are displayed.
5. To configure other tabs, refer Working with Data Object.
Step IV: Configuring attributes
Manage the attributes associated with the data object through the Attributes tab.
1. To add a new attribute, click on Click Here.
New entry for attributes is generated and success message is displayed at the bottom right corner of the screen.
To work with data objects you must configure at-least one attribute and following fields are default across all the data objects in attributes tab:
- Attribute: Define the name of the attribute
- Data Type: From the list of data types, select and assign appropriate type
- Precision: Define the number of digits in the data object
- Scale: Define the number of digits to the right of the decimal point
2. You can also copy attributes from another Data Object of same type and paste here, to do that, click Paste.
- Following operations are allowed on the database entries: Add, Cut, Copy, Paste, Up, Down, Delete, and Search.
- From the list of attributes, multiple attributes can be selected and we can perform/apply these operations.
- To add a new attribute, click Add. By default a new attribute is populated in the last row. If you want to add an attribute at a specific position then, select the attribute in the position prior to it and click Add.
- To search for a specific attribute, enter the keyword in the search bar, and the page displays the related attributes.
Step V: Save the data object
- To save the changes made to the data object, refer Saving Data Object.
- If the changes made to the data object need to be reverted and not saved then, refer Reverting changes in Data Object.
- Once the data object has been created and the changes have been saved then, Close or Unlock the data object so that it is editable by other users. For more information, refer Closing Data Object and Unlocking Data Object.
DDL is generated based on the created columns(Attributes) and their properties in Attributes tab. DDL is available only for data objects corresponding to relational tables and for File data objects the DDL is not available.
Viewing sample Data:
Displays preview of created data object values retrieved from the database.