[CR/DR] Scanning databases

Introduction

All information and guides regarding database scanning for Card & Data Recon shall be documented here.

 

MS SQL

It is required to have a data source set up beforehand, here's how;

  1. On your database server, go to 'Start' > 'Run' > Enter "odbcad32"
  2. Click on the 'User DSN' tab
  3. Click on 'Add' and select the appropriate SQL Server driver then click 'Finish'
  4. Enter the following details;
    - Name of DSN
    - Description
    - Server name
  5. Select if you would like to use the Domain or SQL Authentication then hit 'Next' and 'Test Connection' followed by 'OK'

Once done, you may proceed to run Card/Data Recon and scan your database. Below is a step-by-step guide:

  1. First, we have to set up your Credentials
    On the main page of Card/Data Recon, click on the 'Credentials' button shown below:



  2. Click on the 'Add' button and select 'Microsoft SQL Server'



  3. Enter your DSN name as the 'Target Location' and fill in the respective username and password



  4. Once done, go back to the main page of CR/DR and click on the 'Targets' button this time



  5. Here, you may choose to add your MS SQL server as a new Target or edit any existing Target/s
    Please make sure you have sufficient licenses for each Target you intend to scan



  6. After making your choice, select 'Microsoft SQL' under the 'Databases' category



  7. After expanding 'Microsoft SQL', you should see your server name/DSN underneath
    If it doesn't show up, manually enter your server name
  8. Afterwards, you have to specify a valid catalog to scan, so your path should look like:
    <HOSTNAME>/<CATALOG> or <HOSTNAME>/<CATALOG>/<TABLE>
  9. You may now click on the 'Select' button and commence your scan

 

 

Oracle

When scanning Oracle DB using CR/DR, it is required to install Oracle Instant Client v11.2.0.3.0.
The Oracle Instant Client installation directory must be added to the System Path Environment Variable.
Append this folder location to System Path Environment Variable;
Path=<Previous_Paths>;C:\<Parent_Folders>\instantclient-basic-nt-11.2.0.3.0\instantclient_11_2\

Please note that scanning of Oracle DB is only supported on Windows.

Once ready, follow the instructions below:

  1. First, we have to set up your Credentials
    On the main page of Card/Data Recon, click on the 'Credentials' button shown below:



  2. Click on the 'Add' button and select 'Microsoft SQL Server'



  3. Enter your DSN name as the 'Target Location' and fill in the respective username and password



  4. Once done, go back to the main page of CR/DR and click on the 'Targets' button this time



  5. Here, you may choose to add your MS SQL server as a new Target or edit any existing Target/s
    Please make sure you have sufficient licenses for each Target you intend to scan



  6. After making your choice, select 'Oracle' under the 'Databases' category



  7. Type in your Oracle DB hostname in the 'Add database server' field
    Alternatively, you may fill in the 'Path' field below using the syntax; //<HOSTNAME>/<CATALOG>/<TABLE>
  8. Click on the 'Select' button and you may now commence your scan.

 

IBM DB2

It is required to download & install appropriate ODBC drivers from the IBM Support Portal beforehand.
After you've installed the drivers, please perform the following steps:

  1. Go to 'Start' > 'Run' > odbcad32
  2. Under the 'User DSN' tab, click on 'Add' and select your IBM DB2 driver
  3. Go to the 'Advanced Settings' tab and click 'Add'
  4. Enter the hostname of your server, name of DB, and the port number it is using
  5. Now go to the 'Data Source' tab and enter the credentials required to connect to the database, then click on 'Connect' to verify the connection

Once done, you may proceed to run Card/Data Recon and scan your database. Below is a step-by-step guide:

  1. First, we have to set up your Credentials
    On the main page of Card/Data Recon, click on the 'Credentials' button shown below:



  2. Click on the 'Add' button and select 'IBM DB2'



  3. Enter your DSN name as the 'Target Location' and fill in the respective username and password



  4. Once done, go back to the main page of CR/DR and click on the 'Targets' button this time



  5. Here, you may choose to add your IBM DB2 server as a new Target or edit any existing Target/s
    Please make sure you have sufficient licenses for each Target you intend to scan



  6. After making your choice, select 'IBM DB2' under the 'Databases' category



  7. Select or type in your IBM DB2 hostname in the 'Add database server' field
  8. Click on the 'Select' button and you may now commence your scan.

 

Sybase

It is required to download & install Sybase ASE beforehand. Kindly install only the client related options.
After the installation, please perform the following steps:

  1. Go to 'Start' > 'Run' > Enter odbcad32
  2. Go to the 'User DSN' tab
  3. Click on 'Add' and select the Sybase driver
  4. Go to the 'Login' tab and enter your credentials, server name, and database name
  5. Click on 'Test Connection' on the main tab to verify your connection

Once done, you may proceed to run Card/Data Recon and scan your database. Below is a step-by-step guide:

  1. First, we have to set up your Credentials
    On the main page of Card/Data Recon, click on the 'Credentials' button shown below:



  2. Click on the 'Add' button and select 'Sybase'



  3. Enter your DSN name as the 'Target Location' and fill in the respective username and password



  4. Once done, go back to the main page of CR/DR and click on the 'Targets' button this time



  5. Here, you may choose to add your Sybase server as a new Target or edit any existing Target/s
    Please make sure you have sufficient licenses for each Target you intend to scan



  6. After making your choice, select 'Sybase' under the 'Databases' category



  7. Select or type in your IBM DB2 server hostname in the 'Add database server' field
  8. Click on the 'Select' button and you may now commence your scan.

 

PostgreSQL

No prior setup/configurations needed, just run CR/DR and follow the steps below:

  1. First, we have to set up your Credentials
    On the main page of Card/Data Recon, click on the 'Credentials' button shown below:



  2. Click on the 'Add' button and select 'PostgreSQL'



  3. Enter your DSN name as the 'Target Location' and fill in the respective username and password



  4. Once done, go back to the main page of CR/DR and click on the 'Targets' button this time



  5. Here, you may choose to add your PostgreSQL server as a new Target or edit any existing Target/s
    Please make sure you have sufficient licenses for each Target you intend to scan



  6. After making your choice, select 'PostgreSQL' under the 'Databases' category



  7. Select or type in your PostgreSQL server hostname and catalog name in the 'Add database server' field
    <HOSTNAME>/<CATALOG>
  8. Click on the 'Select' button and you may now commence your scan.

 

Troubleshooting

Microsoft SQL: "Library failed to load"

  1. Manually locate the DB2 driver installation directory
    There should be a 'bin' sub-folder that contains the files 'db2cli.dll' & 'db2cli64.dll'
  2. Create a sub-folder named 'db2' in the folder where your CR/DR is located, then copy the entire 'bin' folder into this sub-folder
  3. Verify that the file is in the correct directory by opening up a Command Prompt window in your CR/DR directory and running the command; dir db2\bin]db2cli.dll
    The 'db2cli.dll' file should be shown
  4. Re-launch CR/DR

Oracle DB: "Libraries not found"

Examples

  • Oracle client libraries not found: oraociei11.dll: The specified module is not found
  • Oracle client libraries not found: oci.dll: The specified module could not be found.

Causes

  • Oracle Instant Client 11.2.0.3.0 is not installed
  • The Oracle Instant Client has not been added to the System Path Environment Variable

 

All information in this article is accurate and true as of the last edited date.

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.