Who's On?

	Membership:
	Latest: Hitman
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5208

	People Online:
	Visitors: 485
	Members: 1
	Total: 486

	Online Now:
	Aroma

New Topics

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1372
Roger French	1315
mark.cook	1244

Tableau

5 Replies

1 Subscribed to this topic

68 Subscribed to this forum

Sort:

Author

Messages

M.J.

Veteran Member

Posts: 38

4/29/2014 5:05 PM

I was wondering if anyone is using Tableau for creating reports on Lawson data? We currently use Crystal Reports and LBI for dashboard access. I'm going to be looking at adding Tableau to our tool set and was wondering if anyone has used it and if so, what your thoughts are?

Julia

Basic Member

Posts: 18

4/29/2014 5:52 PM

We use Crystal Reports but use Tableau for data analysis. Most of our data for Tableau is staged in a SQL Server data warehouse.

Tableau is an awesome data analysis tool that can support a variety of users allowing users to do some ad-hoc or simply interact with a dashboard created by a developer.

M.J.

Veteran Member

Posts: 38

4/29/2014 6:51 PM

Thanks Julia - glad to hear you find it useful. Are you able to hit your Lawson database with Tableau directly - if so what type of database is your Lawson in (SQL, Oracle, iSeries)?

Julia

Basic Member

Posts: 18

4/30/2014 1:40 PM

Our LAWSON is Oracle and I have not tried direct access from Tableau but do not see why it would be an issue. We create views in Oracle and dump into tables on SQL Server and Tableau accesses those tables. Primary reason for this is not wanting to impact the production database. We also do our joining in SQL and then create Tableau data extracts from the tables and publish those to Tableau server.

M.J.

Veteran Member

Posts: 38

4/30/2014 2:31 PM

Thanks Julia - great info!

JonA

Veteran Member

Posts: 1163

5/8/2018 3:41 PM

This thread is a few years old but we've just started experimenting with Tableau. I've connected to our Lawson test server via ODBC but I'm wary of connecting to production because I don't know if it will cause undue stress on the server. In other words I don't want to crash production. We don't have any Lawson data stored on a separate SQL server that I could access with Tableau. I do use Crystal on production via ODBC without issue.