Osticket integration

Kowshick

Hi Everyone,

I am currently using a helpdesk application which was developed by our own developers , but we don't have a module to create tickets automatically from email received.
Can anyone suggest how to integrate my existing helpdesk with osticket only for auto ticket creation??
Thanks in advance.

PavelH

Nobody know your existing helpdesk. That's why no one can help.
Your developers could connect to and read from the DB.

Kowshick

PavelH
Thanks for the reply , My actual issue is I am preferring Osticket for automatic ticket creation by fetching emails. But ticket ID of existing helpdesk differs from ticket created from OSTicket due to different database (MYSQL and MSSQL).

Is it possible to configure OST in MSSQL instead of MYSql?

PavelH

I think OSTicket do not support Microsoft SQL Server. A more accurate answer must be given by someone on the team.
But you can add your MySQL database as a linked server in SQL Server via the MySQL ODBC driver. This can help: https://www.codeproject.com/Articles/29106/Migrate-MySQL-to-Microsoft-SQL-Server

PavelH

As I see on homepage in downloads

or in Support->FAQ

MSSQL is not supported

Kowshick

Thank you so much for the information , we done the integration through Stored procedure using ODBC for MySQL. Thanks again.