Joie Andrew on 10 Feb 2017 07:19:39
BMC has not updated the ARSYS ODBC provider in forever, have stated that they will and it is only available in 32-bit. Also, it is sill the most viable way to pull data out of Remedy or ITSM for use by external analytic tools.
It would be great if Microsoft could work with BMC to create a new data source connector (ODBC, web service, etc.) that could allow rich reporting directly ffrom Remedy/ITSM data. We currently use the legacy ARSYS ODBC provider, but it is very lacking in features and forces one to use 32-bit PBI desktop to report off of any live data.
- Comments (4)
RE: BMC Remedy ITSM Data Source
'If I use Power BI and ODBC using a Select query, I am able to fetch the information from the table, however if I use ARSYS DSN Table as connection, it is unable to fetch information and returns below error.
DataSource.Error: ODBC: ERROR [07006] [AR System ODBC Driver]Conversion error
Details:
DataSourceKind=Odbc
DataSourcePath=dsn=BMC AR ODBC
OdbcErrors=Table
= Source{[Name="ITSM_INC_Table",Kind="Table"]}[Data]
RE: BMC Remedy ITSM Data Source
Lee, I like what Northcraft have done and would love to be able to use it, but for our needs it is way too expensive. While there's a good argument for the kind of customisation Northcraft can offer, if you just need to be able to produce a standard set of dashboards from Remedy there really should be a relatively easy API to connect to it.
But I would also say this is as much on BMC as MS, because their reporting toolset has been sorely lacking since v7.
RE: BMC Remedy ITSM Data Source
It's not needed any more, due to this - https://www.youtube.com/watch?v=zZ0m_SJgiOw
RE: BMC Remedy ITSM Data Source
For more details, click here - https://www.northcraftanalytics.com/bmc-remedy-itsm-2/