CData Python Connector for Oracle Fusion Cloud SCM

Build 24.0.9175

CreateSchema

Generates schema definitions for Oracle Fusion Cloud SCM tables, streamlining data organization.

CreateSchema

Creates a local schema file (.rsd) from an existing table or view in the data model.

The schema file is created in the directory set in the Location connection property when this procedure is executed. You can edit the file to include or exclude columns, rename columns, or adjust column datatypes.

The connector checks the Location to determine if the names of any .rsd files match a table or view in the data model. If there is a duplicate, the schema file will take precedence over the default instance of this table in the data model. If a schema file is present in Location that does not match an existing table or view, a new table or view entry is added to the data model of the connector.

Input

Name Type Description
TableName String The name of the database table for which the schema definition is being generated. This table must exist within the specified schema and is used to extract metadata, including column details, constraints, and relationships.
SchemaName String The name of the OracleSCM schema that contains the target table. This field ensures that the correct schema context is used when retrieving table metadata, especially in multi-schema environments where different functional areas such as Inventory, Procurement, or Order Management can be separated.
FileName String The full file path and name where the generated schema file is saved. This path allows for persistent storage of the schema definition, which can be used for documentation, integration with external systems, or version control (for example, 'C:\\scripts\\Accounts.rsd'). If specified, the output is written to this file instead of being returned in memory.
SimplifyNames String A flag indicating whether the generated schema should include simplified column names. When enabled, system-generated prefixes or complex technical identifiers are removed to enhance readability, making the schema easier to use in external applications and reporting.

Result Set Columns

Name Type Description
Result String A status flag that indicates whether the schema generation process completed successfully. This flag can be used to confirm successful execution or trigger error handling workflows if the operation fails.
FileData String A Base64-encoded representation of the generated schema. This output is particularly useful for transmitting the schema over APIs, embedding it in structured responses, or storing it in environments where direct file access is restricted. This output is only provided when neither FileName nor FileStream is specified.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175