Create customer user via web service

Moderator: crythias

Locked
ivicav
Znuny newbie
Posts: 21
Joined: 12 Jun 2012, 14:16
Znuny Version: 5.0.1
Real Name: Ivica Vujovic
Company: BELIT

Create customer user via web service

Post by ivicav »

Is it possible to create CustomerUser in external another back end via web service? I have problem with connecting Linux OTRS to MS SQL database (drivers issues). Only option I have now is to insert customer directly to OTRS database but I don't like that idea.
Jarod
Znuny newbie
Posts: 30
Joined: 08 Jul 2014, 10:41
Znuny Version: 4.0.6
Real Name: Patrick

Re: Create customer user via web service

Post by Jarod »

Ih ivicav,

I had the das issue some weeks ago.
Connecting from Linux (MariaDB/MySQL) to a MS SQL Server is not that easy.
I solved it the following way:

Created a user with rights to access via remote and write access to a newly created customer db.
The MS SQL Server creates a view of the needed data and writes it remote on the Linux MariaDB/MySQL.

Maybe this would be a solution for you.

Best regards
Viele Grüße

Jarod
ivicav
Znuny newbie
Posts: 21
Joined: 12 Jun 2012, 14:16
Znuny Version: 5.0.1
Real Name: Ivica Vujovic
Company: BELIT

Re: Create customer user via web service

Post by ivicav »

I ended up with similar approach. At some point of my existence will try to create web service which will allow me to create users (need to learn Perl first :) ).
Locked