Mootoon
Scholar

How to Connect MsSql.

I want to use MySQL. 

How to? K2 connect to MySQL. 

 

Thank you,

0 Kudos
4 Replies
KevinZ1
Apprentice

Re: How to Connect MsSql.

Hi 992,

To accomplish this, you will need to first create a Service Instance for SQL which will connect to the database you want to use. 
To do this:

Open your K2 Managements site
→ Integrations

→ Service Types
Create a new service instance for SQL
 

398701a6-fdff-4442-be29-a698738669d9.png
acd375d4-ccfa-4ee0-abd5-d2250d92e672.png

 

After this, you will need to configure the Service Instance per your needs.
 

8b31626b-123f-4621-af10-ea82842fbdfe.png
Note at marker “H” you will need to enter the name of YOUR database

If you need further help please let me know.

Kind Regards,
Kevin

0 Kudos
Mootoon
Scholar

Re: How to Connect MsSql.

Hi Kevin,

  I mean MySQL, not  mean SQL Server . I tried add new service instance but couldn't , 
System show error > VALIDATION A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

 
0 Kudos
KevinZ1
Apprentice

Re: How to Connect MsSql.

Hi 992, 
Unfortunately K2 does not support MySQL, however there is a loop hole to get MySQL connected to K2.
I’m having some trouble finding the documentation on it right now, but I’ll get back to you as soon as I find it.

Kind Regards, 
Kevin

0 Kudos
YUDI2
Apprentice

Re: How to Connect MsSql.

As K2 do not provide out-of-the-box Service broker for MySQL database.

You can use  “Endpoints Assembly” to access your data layer assembly (CRUD).

All public method in you data layer will be publish as smartobject methods.

 

https://maverick0607.wordpress.com/2017/11/08/creating-a-custom-dll-and-integrating-it-with-k2/

https://simonatk2.wordpress.com/2015/07/01/building-a-endpoint-assembly-for-k2-blackpearl/

 

0 Kudos