MSAccess database as Customer backend

[Giulio Soleni]

Hallo,
as far as I know Microsoft Access database is not mentioned as a supported database in the manuals... a customer of mine is asking if there is a possible solution/strategy to integrate the customer data already present in an MS Access database inside OTRS in an effective way.
If ODBC connection is not allowed, maybe we need to copy all the data from the Access db inside the OTRS database...

Do you have any hint/solution?

thank you in advance

[wurzel]

Hi,

OTRS supports all MySQL, Postgres, MSSQL (ODBC), Oracle databases.


If you are not allowed to use ODBC you have to export/import the data to the local DB - would be my suggestion

Florian

[crythias]

Did you try odbc?

[jojo]

MS Access can not be used as it is not a SQL based database and also there are no OTRS Drivers.

[crythias]

I referenced http://stackoverflow.com/questions/1651 ... using-perl
my $dbh = DBI->connect('dbi:ODBC:driver=Microsoft Access Driver (*.mdb, *.accdb);dbq=X:\Path\To\Your\Database.mdb')
sorry if it won't work.

[Giulio Soleni]

Thank you very much everybody,
I will suggest ODBC connection to my customer, as crythias referenced and I'll report back if the solution works.
I will take also jojo considerations into account, should ODBC solution not work as expected.

Thank you,
Giulio