Hitachi Vantara Pentaho Community Forums
Results 1 to 7 of 7

Thread: How to define JNDI connection to MS SQL Server database

  1. #1
    Join Date
    Jan 2008
    Posts
    13

    Default How to define JNDI connection to MS SQL Server database

    Hi,
    How to define a JNDI connection to MS SQL Server Database.
    I am able to successfully connect to that database thru jdbc connection. But i don't know how to connect to that MS SQLServer database through JNDI. What all to define in the simple-jndi\jdbc.properties file.
    Kindly help asap
    Regards,
    Swati.

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Here are a few samples:

    http://source.pentaho.org/svnkettler...dbc.properties

    HTH,

    Matt

  3. #3
    Join Date
    Jan 2008
    Posts
    13

    Default

    Hi Matt,
    The samples that u hv mentioned do not hv any connection values for MS SQL Server. I want to know what values to specify for the parameters(type, driver, URL) for connection to MS SQL Server.
    Regards,
    Swati.

  4. #4

    Default MS SQL Server JNDI

    Here is an example:

    my_database/type=javax.sql.DataSource
    my_database/driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
    my_database/url=jdbc:sqlserver://localhost;databaseName=demo
    my_database/user=sa
    my_database/password=password

    Don't forget to download sqljdbc.jar from MicroSoft and add it to <your kettle path>\libext\JDBC\

    Chris
    BreadboardBI.com

  5. #5
    Join Date
    Jun 2013
    Posts
    8

    Default

    this link is not available.. please specify some other options.. How to create jndi data source for mssql server.?

  6. #6
    Join Date
    Oct 2015
    Posts
    14

    Default

    Sorry about reviving an old post, but does anyone know how to set this up for MSSQL Native?

    Quote Originally Posted by clavigne View Post
    Here is an example:

    my_database/type=javax.sql.DataSource
    my_database/driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
    my_database/url=jdbc:sqlserver://localhost;databaseName=demo
    my_database/user=sa
    my_database/password=password

    Don't forget to download sqljdbc.jar from MicroSoft and add it to <your kettle path>\libext\JDBC\

    Chris
    BreadboardBI.com

  7. #7
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    That simple-jndi paragraph is for MSSQL Native
    You can tell this because it's calling for the Microsoft SQL Server JDBC driver.

    Where that paragraph says "my_database" you can replace it with the name that you will use for JNDI
    make sure you update the url line to point to the right host (example host has localhost) and database to connect to on that host.
    change your user and password as appropriate.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.