Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Connecting SQL Server using pentaho

  1. #1

    Default Connecting SQL Server using pentaho

    Hi

    I want to connect to sql server using pentaho. But that server is in different domain. We have one sql server in one domain. This server is having master data.

    Now we have some other sql server in different domain and pentaho is installed on it. I want to read master data (from other domain sql server) using pentaho transformation. Is it possible? If yes, what all configurations needs to be done?


    Please revert ASAP.

    regards

  2. #2
    Join Date
    Feb 2009
    Posts
    296

    Default

    Err... how about using the hostname field in the database connection?
    Fabian,
    doing ETL with his hands bound on his back

  3. #3

    Default

    hi,

    Thats fine with host name , but just wanted to check if there any issue of domain ie connecting to server in different domain...

    Please let me know if any other specification is required or not ....

    Regards

  4. #4
    Join Date
    Jul 2009
    Posts
    24

    Default SQL Server Authentication

    We are using SQL Server accounts for all of our JDBC Database connections. There should not be any issue with being in different domains unless you are required to work with Windows Authentication. If Windows Authentication is mandatory you would probably need to use the domain\username instead of username alone. I would agree with the others that there should be no concerns outside of the above when crossing domains.

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.