Connect to Server (Oracle), Connection Properties
Applies to: 
SQL Server
Use the Connection Properties tab of the Connect to Server dialog box to specify a publishing option of Gateway or Complete. After a Publisher is identified, this option cannot be changed without dropping and reconfiguring the Publisher. For more information, see Configure an Oracle Publisher.
Options
Publisher type
Select Gateway or Complete. The Complete option is designed to provide snapshot and transactional publications with the complete set of supported features for Oracle publishing. The Gateway option provides specific design optimizations to improve performance for cases where replication serves as a gateway between systems. The Gateway option cannot be used if you plan to publish the same table in multiple transactional publications. A table can appear in at most one transactional publication and any number of snapshot publications if you select Gateway.
Timeouts
Specify how long the Microsoft SQL Server Distributor should attempt to connect to the Oracle Publisher before a timeout error occurs.
See Also
Glossary of Terms for Oracle Publishing
Performance Tuning for Oracle Publishers
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for