Appendix: Quick Reference
Connection Type Selection Guide
Source System |
Recommended Type |
Access Mode |
|---|---|---|
SAP S/4 HANA |
API (RFC) |
Replicated |
SuccessFactors |
API (OData) |
Replicated |
NetSuite |
JDBC or API |
Replicated |
Dynamics 365 |
API (OData) |
Replicated |
SQL Server |
JDBC |
Virtual/Replicated |
Oracle DB |
JDBC |
Virtual/Replicated |
PostgreSQL |
JDBC |
Virtual/Replicated |
Common Port Numbers
System |
Default Port |
Protocol |
|---|---|---|
SQL Server |
1433 |
TCP |
Oracle |
1521 |
TCP |
PostgreSQL |
5432 |
TCP |
MySQL |
3306 |
TCP |
NetSuite |
1708 |
TCP |
HTTPS APIs |
443 |
TCP |