sql-serverpentahobusiness-intelligence
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.
Solution
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.
- What's the best method to do paging in my ASP page
- What is the Equivalent syntax of mysql " LIMIT " clause in SQL Server
- Is there any performance issue using Row_Number to implement table paging in Sql Server 2008?
- Clean up a SQL Server Query with too many DISTINCT clauses in it
- SQLAlchemy does not connect to SQL Server with ODBC Driver 18 for SQL Server but pyodbc does
- Sort Month Name in SQL Query
- When should I use semicolons in SQL Server?
- Import Excel to Pandas Dataframe, but preserve order of Day/Month in dates?
- Encryption PowerShell script generated by SQL Server Management Studio executes but doesn't work
- SSIS Error: External Column for Source out of sync with Data Source columns; How do I remove External Columns?
- I need good tool for database unit testing
- how to calculate database transaction count per second and database growth
- SQL Server TRY...CATCH Is Not Catching An Error
- JDBC connection hangs with no response from SQL Server 2008 r2
- How to use Table -Valued Parameter with Dynamic query
- Why won't SQL Server allow creation of a user with SQL Server Authentication?
- Last Run Date on a Stored Procedure in SQL Server
- SQL Server: Search all tables for a particular GUID
- Truncate (not round) decimal places in SQL Server
- Find a string by searching all tables in SQL Server
- What is the benefit of using "SET XACT_ABORT ON" in a stored procedure?
- How to use SET XACT_ABORT ON the right way
- Basic SQL commands in Terraform
- What tools are available to test SQL statement performance?
- Get space used by Mirth per channel in SQL Server
- SQL Server recursive CTE and paging
- Why I am getting Cascade delete cycle error when updating the database
- Find if any row parameter value was equal to 1 in period of time
- Azure DataSync tables not showing up
- Change Existing JSON value "JSON_MODIFY" must be a string literal