How to setup Oracle database connection
This chapter will show you how you can connect to your own Oracle database through Oracle connection. Via Oracle it is possible to connect to different types of database servers. If the connection is successful, you can import contacts from your database to the Ozeki Bulk Messenger Software.
Step 1 - Create new database connection
Start the process by creating a new database connection. To do so, you need to click on Create new database connection button.
Step 2- Type of database
With Ozeki Bulk Messenger software solution you are able to connect to different types of database servers. In the following figure you can see on which button you need to click to install a new SQLExpress connection.
Before you connect to the database, you need to install the Oracle client software and the Oledb connector which belongs to the Oracle on the same computer where the Ozeki Bulk Messenger is already installed.
Step 3 - Database connection details
There are two possible ways for giving the details: you can give the data below the General menu, or you can give the connection string below the Advanced menu. In case you give the connection string, it overwrites the data given below the General menu.In this example we give the connection string under the General menu:
- Data source – here we give the IP address or the hostname where the oracle database server has been installed, the server default's port (1521) and the database's name after the / (slash) sign, which is oracle (source here: 192.168.112.121:1521/oracle)
- User ID: - the user id (e.g. ozekiuser)
- Password:- the password to the system user (e.g. qwe123)
If the connection is successful, a green tick will appear under State.
Click to the Open button to go to the details page of this connection
Figure 7 - Click to Open
The event log will show you if you have connected successfully.
Check the data below Event log
Figure 8 - Event log
Step 4 - Testing the database connection
If you click to the Test button, you can give the database table in which you store your contact lists.Click to the Execute button to list the phone numbers that are stored in the given database's table.
Figure 9 - Test the database
More information
- How to setup ODBC database connection
- How to setup OLEDB database connection
- How to setup OLEDB database connection
- How to setup SQL EXPRESS database connection
- How to setup Oracle database connection
- How to setup Microsoft Access database connection
- How to setup DB2 database connection
- How to setup PostgreSQL database connection
- How to setup an Informix database connection
- How to setup SQL Anywhere database connection