Reputation: 120
Pentaho biserver using sql server DB installation
I'm new in this field, please kindly help me. I'm installing pentaho biserver for community in my notebook. At first, it's succeed (with default configuration) like this. but, when I'm trying to change the database with ms sql server like this tutorial,
help.pentaho.com/Documentation/5.4/0F0/0K0/040/0D0
an error occurs:
Can anybody tell me what's wrong with the installation?
I'm using:
- Sql server developer edition 2014
- pentaho biserver community 4.8.0
- apache-tomcat-8.5.3
- jdk8
- sql server driver sqljdbc42.jar and I put it under
\biserver-ce\tomcat\lib
I also try something like Using Pentaho Community Edition with SQL Server 2005 but still not working.
Upvotes: 1
Views: 340
Answers (1)
Reputation: 2440
switch to default configuration. no need to do anything. while creating Datasource connection Pentaho provides option for connecting to different RDBMS database.You just need to place JDBC connector file into lib directory.
Upvotes: 1
Related Questions
- How to concatenate text from multiple rows into a single text string in SQL Server
- How to add a column with a default value to an existing table in SQL Server?
- Check if table exists in SQL Server
- How do I UPDATE from a SELECT in SQL Server?
- How do I escape a single quote in SQL Server?
- How to check if a column exists in a SQL Server table
- How can I do an UPDATE statement with JOIN in SQL Server?
- LEFT JOIN vs. LEFT OUTER JOIN in SQL Server
- How can I delete using INNER JOIN with SQL Server?