Scribd
Upload
6 views23 pages

Database Connection Configuration Guide

There are three types of configuration assistances for connecting to databases: 1) Use a profile that contains connection information provided by the database administrator. 2) Search the local network to find databases. 3) Manually configure a connection by providing the connection details like protocol, configuration, and database name. The document then provides steps for exporting a configuration to a file, importing from a file, and using a profile to connect to databases. It also describes searching the network to find and connect to databases.

Uploaded by

Udaykiranrajitha Kammala
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
6 views23 pages

Database Connection Configuration Guide

There are three types of configuration assistances for connecting to databases: 1) Use a profile that contains connection information provided by the database administrator. 2) Search the local network to find databases. 3) Manually configure a connection by providing the connection details like protocol, configuration, and database name. The document then provides steps for exporting a configuration to a file, importing from a file, and using a profile to connect to databases. It also describes searching the network to find and connect to databases.

Uploaded by

Udaykiranrajitha Kammala
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd

CA: CONFIGURATION ASSISTANCES They are three types configuration assistances: Use profile Select if you have a file

e containing all the necessary information for accessing a remote server. Typically, your database administrator will provide you with the name of the access profile that contains all the information necessary to configure connections to the required databases. Search the network. Select to find databases on your local network Manually configure a connection to a database. Select if you know all the information necessary to connect to the desired database. This includes the protocols supported by the remote server, the connection configuration and the name of the database

Practical session: In this session we can learn how to create the response file and how to use the configuration parameters like cfexport (configuration export) and cfimport (configuration import). Goto control center

Click on tools select configuration assistant

the configuration assistant windows occurs.

Click on configure select export profile select customize

Give the file name and specify the path

Select the database and move it to the other side and select the options give below.

Hence we got the response file and it was exported to the specified path. In this same way we can use the cfimport.

IMPORTING OF THE CONFIGURATION FILE: Goto control center tools configuration assistant In configuration assistant (window) click on configure select Import Profile

Select the file name from the path

After selecting the file click on the button Load select the database click on the button import.

USING THE PROFILE: Select if you have a file containing all the necessary information for accessing a remote server. Typically, your database administrator will provide you with the name of the access profile that contains all the information necessary to configure connections to the required databases. Goto control center click on Tools configuration assistant In configuration assistant (window) click on Selected select add database using wizard

Add Database wizard(window) select the Use a Profile

Select the Required File and click on the Button Load and Select the DataBase Click on the Next

Specify a Nickname for the database Click Next

Select the Register this DataBase for ODBC Click on Finish

Hence the cfimport was completed

SEARCH FOR THE NETWORK: Select to find databases on your local network Click on Next

Select a Database from the network search result Click on Add System (to select required the database from the remote system)

Click on the Discover (it display the systems in network and select the required system)

Select the Required System Click on OK

From the obtained Machine , select the required database which is going to be replicated . Click on Next

Specify a nickname for the database Click on Next

Register the DataBase as a Data Source Click on Finish

Manually Configuration a connection to a DataBase Select if you know all the information necessary to connect to the desired database. This includes the protocols supported by the remote server, the connection configuration and the name of the database

You might also like