![]() ![]() This Template will generate a BDC Model (XML defining BDC), Entity class and Service for fetching data from the LOB application.Start Visual Studio 2010, create a new SharePoint Solution using the Business Data Connectivity Model template under the SharePoint 2010 category.The Spiceworks DSN appears in the System DSN tab.Ĭreate the BDC for accessing data from the Spiceworks' DSN as in the following:.Provide the following entries and click on OK.Select “SQLite3 ODBC Driver” and click Finish.Select the System DSN tab and click on the Add button.Go to Administrative Tools > Data Sources (ODBC). ![]() Create a DSN using the SQLite3 ODBC Driver. ĭownload and install the SQLite3 ODBC driver. All the data related to tickets is stored in the Spiceworks_prod.db file.įor accessing a Spiceworks database we need to install SQLite 3 ODBC, it can be downloaded from. Spiceworks uses a SQLite Database as a backend. We can use SharePoint as a platform for displaying Spiceworks statistics. So, organizations can see statistics of tickets logged in the system and resolved. Spiceworks is a free community Help Desk Management System.
0 Comments
Leave a Reply. |