Can we do an SQL query on K2 database

B
Badge +1

Hi,

I want to know if  its a good practisce to write an store procedure in K2 DB for querying K2 database table , specially K2 smartbox . I have requirement where I want my dotnet application to access my K2 smartbox to fetch data. So can we exposed store procedure to them to fetch the data?

 

Thanking you for your responses!!

 

Thanks,

Taher Badshah

 

3 replies

Albarghouthy
Userlevel 5
Badge +16

Hello Taher,

 

Check  @sbrownhuntoilco's  answer here that will guid you to another thread to read more about it

 

wish it helps

 

B
Badge +1

Hi Mustufa,

Thanks for your reply...

 

I want to know is it recommended to have a store procedure written in external database which could connect to the K2 database to fetch the data from K2 smartbox tables.

Or what are other available approaches to fetch data from K2 smartbox tables other then using Smartobject services and APIs?

Is there way to connect to smartbox tables using ADO.net ?

 

Thanks,

Taher Badshah

S
Badge +8

As Mustafa said: you can do it, but it isn't recommended.  Its not officially supported by K2 and the functionality you can implement is limited (think read-only; no insert or create process).

 

K2 does provide an ADO.NET provider for querying SmartObjects.  Read more about it here.

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings