Delphix Products

Expand all | Collapse all

How to work with connectors

Jump to Best Answer
  • 1.  How to work with connectors

    Posted 04-10-2017 12:30:00 PM
    I have to profile a subset of tables owned by oracle schema. And so i have created a new oracle schema that was able to read only that subset of tables by revoking select permissions on tables of the orignal schema that i have not to profile. That is not enough because Delphix connectors seems only be able to read tables owned by an oracle schema. And so
    I am going to import on my new schema data from an export from the original schema. Then in the new schema i am going to drop those tables that i won't profile.

  • 2.  RE: How to work with connectors
    Best Answer

    Posted 04-10-2017 12:36:00 PM
    Hello Luigidep,
                         If you are trying to profile certain set of tables, you can pick only those tables, while creating a ruleset.

    No need to create a seperate schema with only required tables, to profile.

    Is this the case, or am I missing something?


  • 3.  RE: How to work with connectors

    Posted 04-10-2017 01:06:00 PM
    Yes it is. But if you have to create ruleset by check in only those tables that are useful it  could be very hard work specially when the number of tables involved is of the order of thousands because the guy seems too slow.

  • 4.  RE: How to work with connectors

    Posted 04-10-2017 01:22:00 PM

    You can use filters to limit the listed tables.