Saturday, December 25, 2010

Oracl connectivity to Access/SQL server etc securedly

Heterogeneous Services

Oracle9i, like previous versions, supports heterogeneous services to allow data in non-Oracle database to be queried using SQL. This support has been in the form of transparent gateways, which are vendor specific, or generic connectivity which uses ODBC or OLEDB to make the connections.

The functionality supported by generic connectivity is typically more limited than that possible when using vendor specific gateways, but it is quick and simple to configure.
The steps listed below can be used to connect Oracle to any ODBC compliant database (MS Access, SQL Server etc.) on the local server: Click for More
-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Vacation and Cyber Security

Summer vacations and travel plans are ON. Unfortunately, travel can open you up to many new vulnerability . It is important to strive to be ...

  • Segregation of Duties under ERP
    Segregation of Duties (SoD) separates roles and responsibilities to ensure that an individual cannot process a transaction from initiation ...
  • Test your security
    Security Planner provides research-based recommendations that are beneficial for a general population of users, most of the time. It is not...
  • Is your Password Safe
    Millons of the passwords are hacked in several security breaches. The password you are currently using - Is it secure and is not availa...