Ananke – General Purpose Database Tool

 

Ananke is an universal database application that allows users to view, modify, delete data from any number of databases. Currently supported DB providers are MSSQL , Oracle and DB2.

(Note: you need to have the corresponding database client files installed ).

 

The key features are :

  • Activity logging (all the instructions are logged, per connection, sql success and date). You will get sql files that will contain the instructions that failed to execute, separated from the ones that went fine, so you may verify the history of your work, if you ran a sql instructions or not and what were the results.
  • Before executing a DELETE, UPDATE, ALTER command the application will verify the impact on the table and will calculate the number of rows that will be updated. If that number is higher than 1 (bulk update/delete) then a confirmation message will be displayed, helping you to avoid accidental deletes/updates of data. (this feature may be disabled from the settings if you dont need disturbing messages asking for confirmation and you know what you are doing). This feature helps you not to update/delete more rows when you intend to update/delete only one (happens if you forget to add a condition when performing update/delete)
  • Undo SQL instructions are created and saved to undo files. This means if you modify/delete by mistake  a row you can recover the data just by checking the undo logs. This functions may be disabled too or tweaked, you may specify the row limit that will trigger the creation of undo sql instructions (default is 1). If setting value is too high it may take a lot to create the undo sql instructions (the application is creating an undo sql for each row in the affected rowset ), setting the value to zero will disable the creation of undo sql.
  • Easy edit of data by using edit dialogs where user will know clearly what data is modifying:
  • Select data from multiple databases with one command and compare the results. You may select/execute SQL on more than one connection. When selecting data the data is displayed for each connection and you may also compare the data rows from different connections. 20160321-190510
  • You may also compare table data and generate SQL updates to sync the data between tables.
  • Default where variables (when you need to add some where conditions every time you query tables Ananke can help by defining rules that will automatically add the conditions to your queries, without typing them)
  • Also you have the possibility to use connection specific variables. For example you may use  “select * from table1 where field1={{variable1}}  and define different values for the variable1 in each connection.
  • Easy export of data rows as SQL commands (export as Update, as Insert, as Delete), via clipboard.20160321-190440
  • Easy export of data to Excel via clipboard (copy to clipboard the selected rows and have tab separated data ready to be pasted in Excel)
  • Easy export of data to files as SQL insert. Just use Export <table> where <conditions> <orderby>  command and the table will be exported to file. Also the Export commands may be run in a batch (multiple table export to a single file)
  • Table structure auto completion (when writing sql you may get information about tables and fields by pressing Ctrl+Space and a contextual menu will help you write faster)
  • Complex customization of table specific SQL scripts. You may have common and frequently used SQL commands prepared for each table just by using Ctrl+Space command. (For example you may have, starting from table name, an SQL script like select f1, f2, f3 from table where f4 is null).
  • Client sort of data in the list view by clicking on the column header. Also you may search the results for a specific text, the list will highlight the results with a specific color.
  • Export multiple sql results to single html file  containing all the executed sql and the corresponding result for each one.
  • Export of a customized data values. Sometimes you want to duplicate objects in database, with Ananke you may choose to modify the values you will export in the files. To be more clear, imagine you have a database that keeps user groups in a table and the rights for each group in another table. If you want to duplicate  a group just select the group from the groups table (select * from groups where id=2) and specify that the new ID value will be 10. The exports will contain all the data from the two tables related to id=2 but having the id=10 in the exported file.
  • Global database Search : sometimes you need to find a value but you dont know exactly in what table/column is that value. Ananke helps you to search ALL DATABASE TABLES for that particular value. The value may be numerical or a text like value and also you may restrict the tables being searched by a table name pattern.
  • Execute large files of SQL. Sometimes you have large SQL files required to be executed on a database. Most SQL clients will require displaying the data first to the interface which makes this difficult, high memory consumption etc. With Ananke you dont have to display all the file, the program will execute each SQL instruction and, very important, will save the results in two separate files, one for the successfully executed instructions and another for the failed ones (together with the error message). This feature allows you to identify the lines that caused problems and also gives you the possibility to run them again.
  • With large databases you may have tens or even hundreds of tables having the same field name (for example idCustomer of DocumentNumber etc). You may search in all database the tables that have that specified field (or more, not only one field) with the desired values. You will be prompted with the desired condition (you will write , for example: idCustomer=777 and year=2015) and Ananke will offer you a batch to be executed containing all the tables having fields idCustomer and year like this:
    • select * from table1 where idCustomer=777 and year=2015
    • select * From table2 from idCustomer=777 and year=2015
    • etc
    • Note: You may also choose to use Export table or Update table set year=2016 instead of select * from table.
  • Create SQL from tabular data. For example, you have a tabular data containing lots of rows, lets say you have 2 columns (Country and Code). You easily create the insert SQL commands from a template like “INSERT INTO TABLE  VALUES (‘{0}’, ‘{1}’) and you will get the template duplicated for each row in the tabular data and have the {0},{1} etc values replaced by the corresponding values in the tabular data columns of each row.
  • Customized interface and  fonts.
  • Keyboard shortcuts that makes typing faster (Ctrl + ‘ : wrap/unwrap the word with ‘ , Ctrl + 0: pad the word with zeroes until a fixed length of word)

 

 

Download Ananke DB Tools Setup

Comments are closed.