LDW 2.1.11 released: More features for DV Web, DV command line client

In version 2.1 we introduced Data Virtuality Web as a web-based self-service tool to search metadata and query objects, without the need to install Data Virtuality Studio. Based on initial feedback, we implemented a number of usability improvements, as well as new features, to make DV Web cover additional use cases. This includes:

• Editing virtual views and procedures: Instead of only querying views and procedures, the definition can now be updated from your web browser
  
• The query history will show recent queries from all users
• Metadata can be reloaded from the server without refreshing the whole website

If you haven't been using Data Virtuality Web before, open http://<your DV server>:8080/editor in your browser (login with your DV user credentials) and let us know your thoughts. Your feedback is always welcome in our Feature Requests section.

Another new feature is a command line client to send SQL queries to Data Virtuality. This can be handy for administrative purposes, such as monitoring or automated provisioning. In /opt/datavirtuality/dvserver/bin there is now a script dsql.sh which you can invoke to send SQL queries to the DV server:

./dsql.sh -u admin -p admin -h 127.0.0.1 "SELECT 1" 

Studio

• DVCORE-5303: Deleting a "run once immediately" schedule of a running job causes inconsistent behavior
• DVCORE-6210 Data Virtuality Synchronization Tool: Fails to sync changed jobs
• DVCORE-6074: XML builder adds TO_CHARS function to the resulting query for XML containing encoding information in prolog

Connectors

• DVCORE-4562 (Improvement) Oracle: Allow dates to be treated as timestamps
• DVCORE-6059 (Improvement) BigQuery: Implement a JDBC driver supporting the Standard SQL dialect
• DVCORE-4581 BigQuery: TIME, DATETIME, TIMESTAMP data types cannot be queried after materialization
• DVCORE-4177 BigQuery: Native queries consume an exceeding amount of memory
• DVCORE-4153 BigQuery: PSQLException when copying a table with varchar columns
• DVCORE-3688 BigQuery: Dates are retrieved in the wrong time standard
• DVCORE-3687 BigQuery: Bigdecimal and float data types are handled improperly

DV Web

• DVCORE-6181 (New Feature): Add edit definition feature
• DVCORE-5934 (New Feature): Implement query history
• DVCORE-6214 (Improvement): Rearrange objects in 'Browse' panel and sort the data sources alphabetically
• DVCORE-6177 (Improvement): Make the 'Clear' button also clear away the error messages if there were any
• DVCORE-5857 (Improvement): Remove tooltips from object explorer
• DVCORE-5853 (Improvement): Remove 'i' icons from functions
• DVCORE-5852 (Improvement): Place column data types in braces
• DVCORE-5849 (Improvement): Change procedure parameters icons
• DVCORE-5847 (Improvement): Make functions clickable
• DVCORE-5844 (Improvement): Change the name of downloadable .csv file
• DVCORE-5843 (Improvement): Procedures generated by sample code must have different names
• DVCORE-5799 (Improvement): Add a 'Reload' button to the browser pane
• DVCORE-5793 (Improvement): Change text in the query result panel when a query is running
• DVCORE-5792 (Improvement): Enable user to stop query execution
• DVCORE-5791 (Improvement): Change query results and history header style
• DVCORE-6180: Not all column names in generated statements are wrapped in double quotes
• DVCORE-6178: Error messages are meaningless
• DVCORE-6154: The app does not open in IE
• DVCORE-5851: Remove data source descriptions
• DVCORE-5848: Change mouse cursor on hovering over unclickable objects

Backend

• DVCORE-6247 (New Feature): Create a CLI client to connect to Data Virtuality Server and run a query from the command line
• DVCORE-6094 (Improvement): Allow writing connection/data source properties from initializeMetadata() procedure
• DVCORE-6005 (Improvement): Implement changeJob procedure for copyOver jobs
• DVCORE-3832 (Improvement): Create a separate map to store arbitrary connector's values
• DVCORE-5604: Query containing multiple JOINs of sub-queries using table functions with materialized tables results in an error
• DVCORE-4003: CopyOver jobs fail on target tables having names written not in lower case