Before you can use the FSA to scan databases, you must ensure that the Oracle or SQL Server client tools have been installed on the DBMS host server. These client tools are available from your database vendor and include the drivers (that is, the OLE DB Providers) that the FSA uses to access the target database. For example, Oracle Data Access Components (ODAC) include the necessary drivers for accessing Oracle databases.
When you create a new scanning job using the FSA Job Definition wizard in the Administration console, you must choose from a list of SQL Server or Oracle OLE DB Providers. This allows the FSA to identify what type of database it needs to connect to and, therefore, which drivers it must use.
In technical terms, the FSA uses the specified OLE DB Provider type plus other details supplied by yourself (such as the database name and authentication details) to generate a connection string that it uses to connect to the target database.
| Copyright © 2011 CA. All rights reserved. | Email CA Technologies about this topic |