ZennoPoster has in-built tools to work with different types of databases, such as MicrosoftSQL, MySQL, SQLite, etc. You will be able to connect to database files on local computer or remote server and load data required for your seo tasks.
To add operation with database to your project, use action Data>Database:
To work with database, you should set up connection to it. Connection settings may be different depending on database type.
Zennoposter allows to use several data providers for connection:
Connection string field should be filled with input data, such as login and password, to connect to database. You can find examples of connection string for different DBMS on www.connectionstrings.com
To create connection easily, you may use “Connection manager”:
ZennoPoster allows to use the following request types to work with database:
Request w/out answer - for operations that do not require data return from database, for example INSERT or DELETE. As response, this operation returns number of records involved in the request.
Scalar request - allows to get single value. For example, if you want to run an aggregate function (select sum(price) from fruit).
Standard request - returns datatable.
To simplify request, you can use parameters (“Use parameters in request”). Parameters will be inserted into required positions in text. There are two types of parameters - named (use names) and unnamed (use order).
Here are the exampled of requests:
It depends on DBMS which request to use.
Request result can be saved to variable, list or table.
When saving data to table, cells will be filled according to request.
When saving to list, it's important to specify separator for columns. Thus, each line from base table will be written to new list item and specified separator will be inserted between columns.
The same works when saving results to variable, but in this case, you should specify separator for lines.