When adding a new TIBCO Scribe® Online Connector For Oracle Database to a Flow, only the "Execute" block appears for the connection.

The "Execute" block is the only block that appears because the TIBCO Scribe® Online Connector For Oracle Database could not retrieve metadata for the tables that the user has access to.

Even if the user has access to the tables within SQL Developer, they may not be the table's owner or have the required permissions to retrieve the table's metadata. To allow metadata retrieval for a table that the user is not the owner of or does not have the required permissions, a Private Synonym can be created for the required tables under the user's profile within the Oracle Database.

When creating the Private Synonym for the user, giving the Synonym the same name as the table it is referencing is recommended. You would then select the actual owner of that table and then the table itself.

Once the Private Synonyms are created, and the metadata is reset for the Oracle Database connection, the entire set of connection blocks will appear. The created Synonyms will also be available for entity selection within the connector blocks.

Adding a new Oracle Database connection to a Flow, only the "Execute" Block appears for selection.