Learn about the connection types you can use with GoldenGate Studio Free and how to create them.

Learn to create a connection to Oracle Database to use as a GoldenGate Studio Free source or target.

1. From the GoldenGate Studio Free Home page, click Create connection.
2. The Create database connection configuration panel consists of six pages. On the General Information page, enter a Database name, and optionally, a Description.
3. Click Next.
4. On the Connections details page, select a Connection role.
   • Select Source, to create a source database connection.
   • Select Target, to create a target database connection.
5. Select Basic from the Connection type dropdown.
6. Enter the database's Hostname and Port.
7. For Database type:
   • If your Oracle database version is 21c or above, select Pluggable database (PDB) in Oracle Database 21c or above.
     1. Enter the Pluggable database service name (PDB).
     2. If you have DBA privileges for the container database, select SYSDBA privileges available, and then log in as sys or system in the Administrator Credentials dialog.
   • If your Oracle database version is 19c or above, select Pluggable database (PDB) in Oracle Database 19c or above.
     1. Enter the Pluggable database service name (PDB).
     2. If you have DBA privileges for the container database, select SYSDBA privileges available, and then log in as sys or system in the Administrator Credentials dialog.
     3. Enter the Pluggable database service name. If you logged in with DBA privileges, the field autopopulates with the PDB name or you can click Get PDB list and then select it from the dropdown.
   • If your database is not a Container database, then select Non-container database, and then enter the Database service name.

   Note:

   Database names with a domain name should be entered in the Database service name field.
8. Click Next.
9. On the GoldenGate admin user page:
   1. Select Add GoldenGate admin database user if one doesn't yet exist.
   2. Enter the GoldenGate username and password.

   Note:

   1. For a container (CDB) Oracle Database connection, the GoldenGate admin user is typically c##ggadmin. For a non-CDB Oracle Database connection, use ggadmin.
   2. See Non-supported special characters for the list of non-supported characters in object and user names. If a user name contains any of the characters in this list, you will encounter issues with your pipelines.
10. Click Next.
11. (If you logged in with DBA privileges, skip to step 13.) On the Validate configuration page, click Validate to ensure that your database is accessible and ready for GoldenGate to use.

    The database connection only validates when the correct service name and password are used. If the service name or password is incorrect, then an error message appears and action must be taken by your database administrator to update the analysis script. Learn more about the script.

    Tip:

    Click the ellipsis (three dots) menu to view log messages for each step.
12. Click Next.
13. On the Configuration page:
    • If you have DBA privileges, click Run analysis. Review the generated script completely, take note of recommended actions, and then select Run SQL to run it now, or Download SQL for your DBA to run the script separately.
    • If you don't have DBA privileges, click Download analysis script and have your DBA run it for you. Learn more about the script.
    • If Archive Log Mode is not enabled, you must download the SQL script and follow the instructions in the script to enable Archive Log Mode, and then restart the database. You can then run the SQL manually to prepare the database. After you run the script, return to the user interface and click Run analysis again to validate and continue creating the connection.
14. On the Confirmation page review a summary of your connection details, and then click Create.

After you have source and target connections created in GoldenGate Studio Free, you can:

• Learn about recipes
• Learn about pipelines
• Create a pipeline