SQL Server Database Connection/Datasource

SQL Server Database Connection/Datasource

Is it possible to get/put Data from SQL Server Database?

  • 03 September 2018
  • SOTI Snap
  • 9 Answers
  • 0 Upvote
  • 1 Follower
  • 346 Views
    • 9 Answers
    • 0 Upvote
    • 1 Follower

9 Answers

Order By:   Standard | Newest | Votes
Raymond, Chan | posted this 03 September 2018

What a short question!   I actually don't know what you have in mind.

 

Technically, yes.  You can read or write any data you want from the MS SQL databases.

 

For example, you can use the same SQL Server instance to have other databases used by application(s) other than MobiControl, provided your SQL server instance has sufficient cpu and memory bandwidth to deliver performances acceptable to you.  

 

For databases used by MobiControl, it should be safe to just read data from the SQL server instance even while MobiControl servers are operating.  For example, you can use MS Management studio to read different tables of the MobiControl databases from the SQL server.  However, writing to the databases are highly discouraged, unless you are told by Soti support team to do what are necessary with the right steps as instructed.   As most people do not know the database schema and how different tables are used by MobiControl servers to manage your devices,  arbitrarily changing any table can potentially crash the whole MDM system in the worst case.  If my customers do that, both my company (and possibly Soti ) can potentially deny any further support for the product/implementation.    If full fallback is not possible, we might then charge customer a lot to debug and/or reverse what was done, or in the worst case, to reinstall everything from scratch, and recall and re-enrol all devices previously deployed.

 

  • 0
  • 0
Joachim Schneider | posted this 03 September 2018

Thanks for your response but my request refer to Soti Snap ;-)

 

  • 0
  • 0
Raymond, Chan | posted this 03 September 2018

If you are referring to Soti Snap,  then the data to be read/written should be safe as the bottom layers of code implementing all the operations are from Soti, who knows what, when and how SQL tables can be safely accessed and modified.

 

  • 0
  • 0
Joachim Schneider | posted this 03 September 2018

I thought Soti snap provides the ability to create a SQL Server or Oracle database source. Then you can use a control/widget to display this data in a ListView or TreeView.
Too bad this is not offered out of the box.
One more question. Is it possible to view the generated source code somehow?

  • 0
  • 0
Raymond, Chan | posted this 03 September 2018

Frankly, I don't have much exposure to Soti Snap.    I watched some demo video and Soti trainings, but did not spend any time to test it out in detail during their beta release period.   I can't rule out possibility that it's included features that support what your need.  It's better for Soti experts in Soti Snap to answer you.

  • 0
  • 0
Joachim Schneider | posted this 03 September 2018

Thanks Raymond ;-)

  • 0
  • 0
Support Staff | posted this 04 September 2018

Hi Joachim, 

 

As of now we do not have plans to provide support VIA the DB directly or to the source code for SOTI SNAP.  In its initial offering we wanted to ensure that it is less intimidating and intend to have the application as simplified as possible.

 

How are you enjoying the application so far?

 

Regards,

Technical Support | SOTI Inc. |1.905.624.9828 | support@soti.net | www.soti.net |

  • 0
  • 0
Joachim Schneider | posted this 05 September 2018

This is very regrettable because my application cases currently can not be met. I am currently synonymous no enterprise function without database connection.
The application is otherwise very intuitive to use.
What I did not find, though, was the control or property to jump from shape to shape (not link).

Best regards

  • 0
  • 0
Varun Mittal | posted this 16 October 2018

We don’t offer DB connection at this point.  

However, following export/ import functionalities in Snap 1.7 will be helpful in this case. The same will be available in Snap 1.7 Production Release by 1st Nov.

  • If you are looking to export or import data on Snap to or from (respectively) your DB, you can do the same using Rest API, Webhook or Zapier connections in Snap
  • If you are looking to pull data from Snap to your DB, you can also use Snap developer APIs

We will be happy to engage with you in case there are any specific use cases which can’t be achieved with functionalities mentioned above.

  • 1
  • 0
Give us your feedback
Give us your feedback
Feedback