vTiger CRM is a Customer Relationship Management software distributed oncloud through the Vtiger OnDemand platform , and through opensource code in the vTiger Opensource version . Born in 2004 by an Indian development team, such as SugarCRM fork, with the intention of extending the concept of CRM developed by Sugar Inc., primarily in the catalog management, documentation, interface and phone integration, the latter thanks to native Asterisk platform support .
To date, the latest stable version distributed in opensource is 6.4
vtiger CRM is a very large software and consists of the following modules:
Organizations, Activities, assets, Calendar, Campaigns, Workflow, Contacts, Documents, E-mail, Events, Export, Invoices, quotes, Leads, Opportunity, Products, Projects, Sales Orders, Services, Service Contracts, Audit, Reports, Ticket Assistance, Comments on objects, SMS messages, Webservice, PBX calls
LimeSurvey (formerly PHPSurveyor) is a free and open source on-line survey application written in PHP based on a MySQL, SQLite, PostgreSQL or MSSQL database, distributed under the GNU General Public License. As a web server-based software it enables users using a web interface to develop and publish on-line surveys, collect responses, create statistics, and export the resulting data to other applications.
LimeSurvey allows users to create and host surveys, for general data gathering purposes. It can be used for collecting data from customers and employees
A database link is a schema object in one database that enables you to access objects on another database.
After you have created a database link, you can use it to refer to tables and views on the other database.
You can query a table or view on the other database with the SELECT statement.
You can also access remote tables and views using any INSERT, UPDATE, DELETE, or LOCK TABLE statement.