General Features

Screenshot

Authentication

Connect to any SQL server database or Azure database via SQL authentication or Windows authentication.


SQL

Query data by using any SQL statement.


Actions

Following actions are supported:

  • Create CSV file only
  • Create CSV file and transfer via FTP
  • Create CSV file, transfer via FTP, and send a notification via email


File

Following file formats and naming conventions are supported to generate the output file:

  • .CSV
  • .TXT
  • Add unique timestamp to file name


Configuration

Following features are supported to manage configurations:

  • Save configuration to file (.xml).
  • Load configuration from file (.xml).
  • Load a default configuration (.config) while starting the application.


Logs

Check out the local log files to understand each every execution step in more detail:

  • Log.txt
  • Error.txt

Sensitive Information

All sensitive data (passwords) will be encrypted (in configuration files or logs).