Brief Discussion on Oracle Sybase Database

I would like to introduce Oracle to you. Many people may not know about the Oracle Sybase database. It does not matter. After reading this article, you will certainly have a lot of GAINS. I hope this article will teach you more. With the development of society, the information of audited organizations is getting higher and higher, and various large databases, such as Oracle and Sybase, are also widely used by audited organizations.

How to collect the data we need from these large data has become an important task for auditors. I have participated in several Auditing Projects and summarized some experiences from my data collection experience. I hope this will be helpful to my colleagues.

Oracle Sybase Database Data Collection

Most of the auditors' work computers are Windows operating systems, while the databases of audited organizations are generally installed on Unix operating systems. Since the Oracle Sybase database does not support cross-OS backup and restoration as the Oracle database does, direct connection is generally used for data collection in the Oracle Sybase Database.
The first step is to require the audited organization to provide a computer with Sybase client software installed and able to access the Oracle Sybase Database on the server.
Step 2: Install a database software on this computer. Take SQL Server as an example.
Step 3: Open the SQL Server Import and Export wizard and select Sybase ASE OLE DB Provider in the Select data source step.

Click the "properties" button on the page and enter the connection information. Enter the data source name, for example, "Test". Note: The data source name should be provided by the audited organization. It contains the configuration information for connecting the Sybase client to the background database, which can be directly used ), enter the user name and password. In "Enter the initial directory to be used", click the drop-down button, enter the user name and password, and select the database.

Summary and analysis of backup and direct connection

Using the backup method, the obtained data is raw and complete, so that auditors can perform repeated operations locally. However, this puts forward high requirements on the level of auditors and the performance of computers. Using the direct connection method, the configuration information of the database client to connect to the server is fully utilized, avoiding tedious backup and restoration operations and directly capturing data from the database. The operation is relatively simple and easy, auditors can select the preferred one based on their actual situation. The preceding section describes the Oracle Sybase Database.

1. Analysis and Discussion on Oracle Database Restoration
2. Oracle remote disk image
3. New Oracle 11g function display
4. Detailed analysis of Oracle XML data
5. Oracle Data Guard