Database servers

LabeljoyNew version

Labeljoy talks to the most common professional databases by itself - there's nothing else to install. In the Data connection wizard, choose MySQL, SQL Server, Oracle, Firebird, PostgreSQL or MongoDB, and tell it how to reach the server. Your database administrator knows the details.

The wizard's Connection parameters step for SQL
Server: Host, Port with 1433, User name, Password, Database name, and the switches Trusted connection and Trust server
certificate.

Connection parameters
HostThe server's name or address.
PortFilled in with the usual one for the server you chose - change it if yours is different.
User name, PasswordThe account to connect with. The password is saved with the document, encrypted, so updating the data doesn't ask for it.
Database nameWhich database on the server. For Oracle it's Service name; for Firebird, the database's path or alias on the server.
Authentication databaseMongoDB only: where your account is defined. Empty, it's admin.
Trusted connectionSQL Server only: connects with the account you signed in to your computer with, instead of a user name and password.
Trust server certificateSQL Server only: accepts the server's security certificate even when no authority vouches for it - a new SQL Server Express, for example, has one of its own. Switch it on when connecting fails with The certificate chain was issued by an authority that is not trusted.

A SQL Server named instance goes in Host as server\instance, with Port left empty.

Next connects to the server, and the Data source step lists its tables and views. When two of them have the same name in different parts of the database, the full name tells them apart, as in Sales.Customer. Stored procedures and functions aren't listed: to use one, pick SQL query and call it there, as your server does - EXEC on SQL Server, CALL on MySQL, for example.

Good to know
SQL queryWritten in your server's own SQL. Next checks it with the server, and says what's wrong if it can't run it.
A read-only accountLabeljoy only reads, but a query runs whatever you type in it. An account that can only read is the safe choice.
OracleLists the tables and views of the account you connect with. For anyone else's, use a query.
MongoDBLists the collections of the database. The fields are the properties found in the first 50 documents; a property holding an object or a list comes through as its JSON text. A collection is read whole: there's no query for MongoDB.
Opening the documentThe records are saved in the document, so it opens and prints without the server. Labeljoy connects again only when you update the data.