Home      DB      Replicator      CRM      Solutions  
 
Daffodil Replicator
 
Explore Replicator (OS)
 

Product Overview
Download Daffodil Replicator (E)
Getting Started Guide
User Guide
Features
How it Works?
Usage Scenarios
Usage Examples
Recommended JDBC Drivers
Replicator Class Reference
Sample Java Code
Error Messages
Daffodil Replicator (E) FAQ
Daffodil Replicator (E) BLOG
User Forum
Buy

 
Getting Started Guide > Adding JDBC DataSource


Adding JDBC DataSource


To provide database access and manage database connections in the replication process, you need to add JDBC DataSource. You can add JDBC DataSource in the following ways:

When to use Replication DataSource

In case of JDBC DataSource, Replicator gives multiple calls to JDBC DataSource for retrieving and merging data. Therefore, it increases the number of round trips. To reduce the number of round trips, Daffodil Replicator provides the facility to use Replication DataSource. Replication DataSource is installed on the same machine where databases are installed. When you use Replication DataSource, it retrieves data from a JDBC DataSource, writes it into a file, and merges it into another JDBC DataSource through FTP Server.


Adding JDBC DataSource Directly

To add JDBC DataSource directly, you need to configure JDBC DataSource in Replicator. The steps to configure JDBC DataSource:
  1. Click on add button in the Replicator window. Select DataSource Type dialog box appears, as shown in the following figure:

  2. />
    Selecting DataSource Type


  3. Select JDBC DataSource and click the OK button. JDBC DataSource dialog box appears as follows:


  4. JDBC-DataSource
    JDBC DataSource
  5.  

  6. Different data fields in JDBC DataSource dialog box are:
    • DataSource Name – Specifies the name to identify the JDBC DataSource.
    • Vendor Name – Select the vendor name of the Relational Database Management System (RDBMS) used in the replication process. For example, Microsoft SQL Server, Oracle, and PostGreSQL.
    • Database Name – Enter the name of the database on which you want to perform replication.
    • User Name – Enter the user name for the specified RDBMS. The user name must be same as defined at the time of the installation of RDBMS.
    • Password – Enter the password for the specified RDBMS. The password must be same as defined at the time of the installation of RDBMS.
    • Port No – Select the port number on which the specified RDBMS provides services. The port number is used at the time of connection to the database.
    • DB Server Name – Enter the name of the database server where the RDBMS is installed.
    • Enable Existing Data For Replication – Check this check box, if you want to enable existing data for replication process.

    Note: The DataSource Class Name will appear automatically according to the vendor name.



  7. After entering the information in different data fields, click forward button to select tables in databases. Select Tables dialog box appears:


  8. Selecting Tables


  1. Select the table from Tables in Database list box in the Select Tables dialog box. Click arrow button to add the tables in Selected Tables list box. Click replay button to move to previous screen. Click right button to add the tables. And click cross button to cancel the Select Tables dialog box.

Adding JDBC DataSource Using Replication DataSource

You need to add JDBC DataSource using Replication DataSource, when you want to replicate data over Internet. To add JDBC DataSource using Replication DataSource:
  • Configure JDBC DataSource in Replication DataSource
  • Add Replication DataSource in Replicator

Configure JDBC DataSource in Replication DataSource

The steps to configure JDBC DataSource in Replication DataSource:
  1. Click on add button on the Replication DataSource window. JDBC DataSource dialog box appears as follows:

  1. JDBC DataSource


    Different data fields in JDBC DataSource dialog box are:
    • DataSource Name – Specifies the name to identify the JDBC DataSource.
    • Vendor Name – Select the vendor name of the Relational Database Management System (RDBMS) used in the replication process. For example, Microsoft SQL Server, Oracle, and PostGreSQL.
    • Database Name – Enter the name of the database on which you want to perform replication.
    • User Name – Enter the user name for the specified RDBMS. The user name must be same as defined at the time of the installation of RDBMS.
    • Password – Enter the password for the specified RDBMS. The password must be same as defined at the time of the installation of RDBMS.
    • Port No – Select the port number on which the specified RDBMS provides services. The port number is used at the time of connection to the database.
    • DB Server Name – Enter the name of the database server where RDBMS is installed.
    • Enable Existing Data For Replication – Check this check box, if you want to enable existing data for replication process.


    Note: The DataSource Class Name will appear automatically according to the vendor name.



  2. After entering the information in different data fields, click forward button to select tables in databases. Select Tables dialog box appears:

  1. Selecting Tables


  2. Select the table from Tables in Database list box in the Select Tables dialog box. Click arrow button to add the tables in Selected Tables list box. Click replay button to move to previous screen. Click right button to add the tables. And click cross button to cancel the Select Tables dialog box.


Add Replication DataSource in Replicator

After configuring JDBC DataSource in Replication DataSource, you need to configure settings for Replicator and Replication DataSource as specified in Configure Settings for Replicator and Replication DataSource. After configuring settings for Replicator and Replication DataSource, you can add Replication DataSource in Replicator. The steps to add Replication DataSource:
  1. Click on add button in the Replicator window. Select Data Source Type dialog box appears, as shown in the following figure:



  2. Selecting DataSource Type
  1. Select Replication DataSource to add JDBC DataSource using Replication DataSource. Click the OK button to display the Replication DataSource dialog box, as shown in the following figure:



  2. Replication DataSource


    Different data fields in Replication DataSource dialog box are:
    • DataSource Name – Enter the name to identify Replication DataSource.
    • System IP Address – Enter the IP address of the system where Replication DataSource is running.
    • Port No. – Enter the port number where web service is running.
    • HTTPS Required – Enable this checkbox if you want the support of HTTP over SSL (HTTPS). Enable this checkbox only when you enabled it while configuring settings for Replicator and Replication DataSource.
    • Proxy Server Required – Enable this checkbox if the system (where Replicator is running) is connected with the LAN.

  3. After enabling the Proxy Server Required checkbox, Proxy ServerIP textbox appears as shown in the following figure:



  4. Replication DataSource when Proxy Server Required


  5. Enter Proxy Server IP. After entering information in these data fields, click the OK button to add JDBC DataSource using Replication DataSource
 
  ©2008 Daffodil Software Ltd. Contact Us | Disclaimer | Sitemap