Versions Compared

Old Version 3

changes.mady.by.user Omry Koschitzky

Saved on

compared with

New Version Current

changes.mady.by.user Omry Koschitzky

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

In order to add a table from Microsoft SQL Server 2008 or higher as a log source to XpoLog follow these steps:

SQL Authentication

For SQL Server 2008

JDBC Driver

1. Download the driver from heredirectly from Microsoft-here 

  •    For MSSQL 2008+ up to 2017 you may use the current available driver jtds-1.3.1.jar

2. Go to XpoLog Manager > Tools > Address Book, Add New Database Account.
3. In the Database Types screen, click the 'Upload Driver' button and select the sqljdbc4.JDBC jar and file and click the 'Upload' button.

Database account

1. Go to XpoLog Manager > Tools > Address Book, Add New Database Account. 
2. The JDBC Status of SQL Server 2008 should be ready, select it and click 'Create Account'.
3. Required details:

...

4. Save the account and click on the 'Verify' button to verify the connectivity.
If verification fails - ensure all the details are accurate, and that the XpoLog machine can establish a connection to the database machine on port 1433.
5. Once connectivity is verified it is possible to add tables as log source from this database

 

 Example:

Image Added


For SQL Server 2014

1. Download the driver jtds-1.3.1.jar directly from here

 

Windows Authentication

 

2.Go to XpoLog Manager > Tools > Address Book, Add New Database Account.
3. In the Database Types screen, click the 'Upload Driver' button and select the jtds-1.3.1.jar and click the 'Upload' button.

Database account

1. Go to XpoLog Manager > Tools > Address Book, Add New Database Account. 
2. Select type Other and click 'Create Account'.
3. Required details:

  • Name
  • Description
  • Driver Name should be: net.sourceforge.jtds.jdbc.Driver
  • Connection String - 
    jdbc:jtds:sqlserver://<host-name>:<port>/<database-name>
  • User - the user name that will be used for authentication
  • Password - the password that will be used for authentication
  • Database Type - should be SQL Server

 

4. Save the account and click on the 'Verify' button to verify the connectivity.
If verification fails - ensure all the details are accurate, and that the XpoLog machine can establish a connection to the database machine on port 1433.
5. Once connectivity is verified it is possible to add tables as log source from this database

 

Example:

Image Added

Windows Authentication 

JDBC Driver

 

1. Download the driver from here
2. Go to XpoLog Manager > Tools > Address Book, Add New Database Account.
3. In the Database Types screen, click the 'Upload Driver' button and select the jtds-1.23.21.jar and click the 'Upload' button.

 

Database account

 

1. Go to XpoLog Manager > Tools > Address Book, Add New Database Account. 
2. Select type Other and click 'Create Account'.
3. Required details:

...

  • Name
  • Description
  • Driver Name should be: net.sourceforge.jtds.jdbc.Driver
  • Connection String - 
    jdbc:jtds:sqlserver://<host-name>:<port>/<database-name>;domain=<domain-name>
  • User - the user name that will be used for authentication
  • Password - the password that will be used for authentication
  • Database Type - should be SQL Server

 

4. Save the account and click on the 'Verify' button to verify the connectivity.
If verification fails - ensure all the details are accurate, and that the XpoLog machine can establish a connection to the database machine on port 1433.
5. Once connectivity is verified it is possible to add tables as log source from this database

 

Example:

Image Added