Overview of the Database plugin

You cannot create a new database with Linx. With Linx you can connect to an existing database and perform various operations on your data. Linx supports SQL Server, Oracle, ODBC, OLE DB and MongoDB.

For details on how to connect to your database, go here.

If you want to run a simple SQL query, add the ExecuteSQL function to your solution and make use of the SQL Editor.

Functions that can be used with databases:

  • BeginTransaction: To start a transaction in a database that facilitate performing multiple database operations on the same transaction.

  • DBBulkCopy: To efficiently copy large amounts of rows to a table in a SQL Server or Oracle database.

  • ExecuteSQL: To execute a SQL query and return relevant data. The query can contain any SQL and calls that are supported by the database driver.

  • ExecuteStoredProcedure: To run a stored procedure on a database.

  • MongoDBMapReduce: To perform a map-reduce style data aggregation on a Mongo database.

  • MongoDBRead: To perform read operations on a Mongo database.

  • MongoDBWrite: To perform write operations on a Mongo database.

Database License