Test Data Manager

Can CA data maker tool support RAW, LONG , BLOB and Object datatype (database: Oracle) ?

If yes, Please provide the document to refer.

I tried for  Object datatype but this is not working.

In source:

Step1

CREATE TYPE address_typ AS OBJECT (
adr1 VARCHAR2(100),adr2 VARCHAR2(100),street VARCHAR2(30),city VARCHAR2(20),state CHAR(2),postal_code VARCHAR2(6) );
/

Step2

CREATE table employee_det (
employee_id NUMBER(6),first_name VARCHAR2(20),last_name VARCHAR2(25),email VARCHAR2(25),
phone_number VARCHAR2(20),address_det address_typ);

Step3

INSERT INTO employee_det VALUES (3,'grrhi','klrra','c@c.com','1234567890',
address_typ('adr3', 'adr4', 'street4', 'bangalore','KA','560100'))

Step4

Registered the table in Data maker

Step5

When setting action for Registered object getting error:

Select Error: ORA-01013: user requested cancel of current operation

while executing

SELECT * FROM employee_det

Thank you in Advance.

For Datamaker:

LONG data type is no longer being supported by Oracle, so it will not be supported by Datamaker. 

This is from Oracle:
https://docs.oracle.com/cd/B28359_01/server.111/b28318/datatype.htm#CNCPT1831
Do not create tables with LONG columns. Use LOB columns (CLOB, NCLOB) instead. LONG columns are supported only for backward compatibility.
Oracle also recommends that you convert existing LONG columns to LOB columns. LOB columns are subject to far fewer restrictions than LONG columns. Further, LOB functionality is enhanced in every release, whereas LONG functionality has been static for several releases.

http://www.orafaq.com/wiki/LONG
Since Oracle 8i, Oracle advised against using the LONG datatype. Users should convert to CLOB or NCLOB types.

The CLOB data type is supported in Datamaker for creating test data marts and as a filter option in creating transformation maps.
https://docops.ca.com/ca-test-data-manager/4-4/en/provisioning-test-data/configure-test-data-reservation-service/configure-form-based-test-data-reservation-service/test-matching-and-re-matching/construct-test-data-mart
https://docops.ca.com/ca-test-data-manager/4-4/en/reference/filter-options-for-transformation-maps

The BLOB variable is supported in transformation maps.
See 'DateTime expression function' in https://docops.ca.com/ca-test-data-manager/4-4/en/reference/filter-options-for-transformation-maps/custom-filter-functions-for-transformation-maps

If you wish to see more capabilities in either product specific to CLOB or BLOB field masking, please submit an enhancement request using the steps detailed in this document: https://support.ca.com/us/knowledge-base-articles.TEC1107947.html

RAW is supported by Datamaker.

You can read more about how here: https://docops.ca.com/ca-test-data-manager/4-3/en/provisioning-test-data/configure-test-data-reservation-service/configure-dynamic-test-data-reservation-service 

If you are experiencing any issues, please open a support case by going to Contact CA Support - CA Technologies. 

Hi Taylor,

       Thank you for the quick update.

       Could you please provide an update in Oracle Object datatype ?

Thank you.

This is supported as well. I have found this by searching 'object type' in our documentation here CA Test Data Manager - Home - CA Test Data Manager - 4.4 - CA Technologies Documentation 

I am not finding the exact information what i am looking for object type field for Oracle database.