Excel Pivot and ODBC connection to MySQL

[lmasal]

Hello,

if you can help or advise me it would be great.

I have installed OTRS 3.3.8 on CentOS 6.5 and configured as my company wanted and it's working great.

Because OTRS doesn't have reports, I'm using excel pivot table and exported *.csv file to get some statistics, but I have founded that is possible to connect directly on MySQL base of OTRS trough Connector/ODBC for Excel, but I'm having problem with reading data from it.

When I select all tables from OTRS MySQL database it's only showing data from first table.

Does any of you using this way of getting data from OTRS? or maybe have some idea how to connect and read all data?

Thanks.

[crythias]

use a query that's relevant to your spreadsheet.

Essentially, the default is select * from [first table].

Selecting all the data from all the tables is memory intensive and generally useless. It's better to use a database program: MySQL Workbench, PHPMyAdmin, even MS Access, if you want, and SELECT /JOIN the tables WHERE criteria.

I'd also strongly suggest creating a read-only user for ODBC reporting "just in case" (Something that doesn't have UPDATE and DROP permission, at least)

Much of the reporting types you can think of already exist, and if not, specifically requesting one here, in the forums, might point you to ideas on queries.

[lmasal]

Hi Crythias,

thanks for answering and advice.

But I have installed Windows Server, MSSQL, IIS and OTRS for Windows and now I can access to SQL base from Excel very easily.

And now I don't have any more problem.

Thanks anyway.