Setting Up the Source System

  1. On the source system, execute the following SQL statements, where username is the source system user provided to Teradata Hybrid Cloud Manager to perform the migration.
    If using QueryGrid and foreign views, the user must not be DBC.
    1. GRANT SELECT ON DBC TO username;
    2. GRANT EXECUTE FUNCTION ON TD_SYSFNLIB.QGINITIATORIMPORT TO username;
    3. GRANT EXECUTE FUNCTION ON TD_SYSFNLIB.QGINITIATOREXPORT TO username;
    4. GRANT CREATE SERVER ON TD_SERVER_DB TO username;
    5. GRANT CREATE AUTHORIZATION ON TD_SERVER_DB TO username;
    6. GRANT MONITOR TO username;
    7. CREATE DATABASE console FROM DBC AS PERM = 0;
    8. REPLACE MACRO console.dbscontrol AS (;);
    9. GRANT EXEC ON console.dbscontrol TO username;
    10. GRANT CONNECT THROUGH username TO PERMANENT end-user WITHOUT ROLE;
      Execute this task for every user you want to use foreign views.
    11. GRANT SELECT,DUMP ON any_database_being_migrated TO username;
  2. Establish connectivity from your VPC to your on-premises system.

results matching ""

    No results matching ""