Skip to content

Enhance Credit Card Fraud Recipe: Give example source connector #1421

@chuck-confluent

Description

@chuck-confluent

I think the credit card fraud recipe would benefit from having an example source connector. Our technical marketing demo for database modernization does this with Oracle CDC:

There is a small issue when doing this -- you will get a "column name already exists" when creating the customers table because the connector will set a json record key called id. So you would have to rename the field and do something like this:

CREATE TABLE FD_CUSTOMERS (
  customer_id DOUBLE PRIMARY KEY
  ) WITH (KAFKA_TOPIC = 'ORCL.ADMIN.CUSTOMERS',KEY_FORMAT='JSON',VALUE_FORMAT = 'JSON_SR');

All subsequent references to the field would have to be updated too.

For more information, see

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions