Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Bolo.

Table of Contents

Search

  1. Introducing Mass Ingestion
  2. Getting Started with Mass Ingestion
  3. Connectors and Connections
  4. Mass Ingestion Applications
  5. Mass Ingestion Databases
  6. Mass Ingestion Files
  7. Mass Ingestion Streaming
  8. Monitoring Mass Ingestion Jobs
  9. Asset Management
  10. Troubleshooting

Mass Ingestion

Mass Ingestion

Oracle targets

Oracle targets

The following list identifies considerations for preparing and using Oracle targets:
  • Mass Ingestion Databases
    supports Oracle as a target in jobs that replicate data from Db2 for i, Microsoft SQL Server, and Oracle sources. For Db2 for i sources, only initial load jobs are supported. For Microsoft SQL Server and Oracle sources, initial load, incremental load, and initial and incremental load jobs are supported.
  • Mass Ingestion Databases
    requires users to have certain privileges to load data to Oracle target databases. Grant the following user privileges to the Mass Ingestion Databases user (
    cmid_user
    ) to connect to the Oracle target:
    GRANT CREATE SESSION TO <
    cmid_user
    >; GRANT SELECT ON "PUBLIC".V$DATABASE TO <
    cmid_user
    >; GRANT SELECT ON "PUBLIC".V$CONTAINERS TO <
    cmid_user
    >; GRANT SELECT ON DBA_USERS TO <
    cmid_user
    >; GRANT SELECT ON DBA_TABLES TO <
    cmid_user
    >; GRANT SELECT ON DBA_OBJECT_TABLES TO <
    cmid_user
    >; GRANT SELECT ON DBA_INDEXES TO <
    cmid_user
    >; GRANT SELECT ON DBA_OBJECTS TO <
    cmid_user
    >; GRANT CREATE TABLE TO <
    cmid_user
    >; GRANT SELECT ON ALL_CONSTRAINTS TO <
    cmid_user
    >; GRANT SELECT ON ALL_OBJECTS TO <
    cmid_user
    >; GRANT SELECT ON SYS.TAB$ TO <
    cmid_user
    >; GRANT SELECT ON SYS.RECYCLEBIN$ TO <
    cmid_user
    >; GRANT SELECT ON SYS.CCOL$ TO <
    cmid_user
    >; GRANT SELECT ON SYS.CDEF$ TO <
    cmid_user
    >; GRANT SELECT ON SYS.OBJ$ TO <
    cmid_user
    >; GRANT SELECT ON SYS.COLTYPE$ TO <
    cmid_user
    >; GRANT SELECT ON SYS.ATTRCOL$ TO <
    cmid_user
    >; GRANT SELECT ON SYS.IDNSEQ$ TO <
    cmid_user
    >; GRANT SELECT ON SYS.ATTRCOL$ TO <
    cmid_user
    >; GRANT SELECT ON SYS.IDNSEQ$ TO <
    cmid_user
    >; GRANT SELECT ON SYS.IND$ TO <
    cmid_user
    >;

0 COMMENTS

We’d like to hear from you!