Connect external database for customers

[Phil_Moscado]

Used Zammad version: 3.5.x
Used Zammad installation source: package

Request / Question:

It would be great if there is a way to connect Zammad with our JTL WaWi Database.

This DB is running on MSSQL.

Maybe readonly is enough and safe.

Is this already implemented or maybe coming soon?

Best regards
Phil

[dvnkln]

Hey @Phil_Moscado,

you’ll probably want to have a look at this:
https://docs.zammad.org/en/latest/install/source.html#configure-your-databases

Looking inside the referred file will show you the following:

# If the database server is not on localhost, you can set hostname and port:
# host:
# port:

The rest should be up to you.

Plus you should consider the supported DBs:
https://docs.zammad.org/en/latest/prerequisites/software.html#database-server

cheers

[Phil_Moscado]

Hey,

i think here is a misunderstood.

There is a running instance of Zammad.

And now we want to connect it to our customer database to find them in Zammad.
MSSQL isnt supported i know, so a bridge or something is needed.

Our dream is, that Zammad is able to lookup customers in this MSSQL database.

Is something like this planned or possible?

Best regards

[MrGeneration]

There’s no native function that allows you to hook up to third party databses.
This is usually a big rabbit hole.

As this is a feature request on the community, votes on your first article will decide if this is going to be a candidate for a functionality in Zammad.