Ekaterina Sklyarova

Devart has upgraded SecureBridge with support for FTP and FTPS protocols, new capabilities and features, and much more.

Devart, a recognized vendor of professional database tools for developers and DBAs, has released a fresh version of SecureBridge, a network security solution. Now SecureBridge supports the FTP and FTPS protocols, which allow users to exchange files in a common way and securely.

Another feature that’s worth mentioning is a possibility to connect to a remote host through a proxy server enabling indirect network connections to various network services. In addition to the functionality described above, the release includes the following features:

The TScFTPClient component to support seamless access to remote files when using FTP protocol.

Thread-safe TScStorage to use one storage for many SSH and SSL clients from different threads.

The TScSSHConnectionInfo.LocalSockAddr property to retrieve a local IP address.

The TScSSHServerOptions.MaxConnections property to limit the number of active connections on the SSH server.

The TScSSHServer.BeforeClientConnect event to reject or accept a connection based on the client’s IP before his authentication, which greatly increases server performance.

Dive deep into other useful features of SecureBridge at https://www.devart.com/sbridge/ .

About Devart
Devart is one of the leading developers of database tools and administration software, ALM solutions, data providers for various database servers, data integration and backup solutions. The company also implements Web and Mobile development projects.
Learn more about Devart at https://www.devart.com .

Devart introduced a significant update of dbForge tools for MySQL with cutting-edge connectivity and compatibility options and a new, more secure than ever, activation procedure.

Devart, a Czech software vendor of database tools and data connectivity solutions, has rolled out greatly improved, crisp and clean dbForge tools for MySQL after the recent grand update of dbForge Studio for MySQL. All the tools have been packed with the powerful connectivity and compatibility options which enable users to work with a greater number of databases and database engines. In addition, an activation mechanism has received an extreme makeover to ensure the maximum possible security and reliability of the tools.

Here is a closer look at what’s new in dbForge tools for MySQL:

1) Connectivity and Compatibility. dbForge tools for MySQL now support the following  databases and cloud services:
-MariaDB 10.1
-MariaDB 10.2
-NDBCLUSTER
-Google Cloud Platform
-Alibaba Cloud

2) Trial Product Activation. The new activation process that traditionally comes after a 30-day trial period is more secure and reliable than ever before. It protects users against potential piracy and ensures that they are using an authentic product that can be trusted with their business data.

3) New Look and Feel. Among other updates, Devart redesigned the interface of MySQL tools to give them a cleaner look and feel.

4) Other Improvements include Compliance with the Federal Information Processing Standard.

To see the full list of updates, please visit: https://www.devart.com/dbforge/mysql/.

Devart has released new versions of SSIS Data Flow Components 1.7 with support for Marketo, a well-known cloud lead management and marketing automation solution. Now users can seamlessly integrate Marketo objects with other cloud applications and databases via the SQL Server Integration Services engine.

Devart, a recognized vendor of professional database management software for developers and DBAs, has released the new versions of SSIS Data Flow Components with support for Marketo. They allow users to integrate Marketo templates, subscribers, campaigns and many other objects with cloud applications and databases via SQL Server Integration Services (SSIS). The list of components includes optimized Marketo Source, Marketo Destination and Marketo Lookup components that provide their own Marketo Connection Manager.

On the mission to make marketing automation fast and flawless, SSIS Data Flow Components for Marketo offer the following capabilities:
   • Building SSIS-based integration solutions for Marketo in the blink of an eye
   • No-brainer automating Marketo integration via SSIS Data Flow tasks
   • Handy importing and exporting CSV files to Marketo
   • Synchronizing Marketo with SQL Server or other data sources
   • And many more
To learn more about new SSIS Data Flow Component for Marketo, please visit https://www.devart.com/ssis/marketo.html

About Devart
Devart is one of the leading developers of database tools and administration software, ALM solutions, data providers for various database servers, data integration and backup solutions. The company also implements Web and Mobile development projects.
For additional information about Devart, visit https://www.devart.com/.

Devart introduced a significant update of dbForge Studio for MySQL with a bunch of new unique features, including support for Google Sheets, new schema comparison and synchronization engine, and much more.

Devart, a Czech software vendor of database tools and data connectivity solutions, has released a significantly improved version of its universal MySQL and MariaDB GUI tool, dbForge Studio for MySQL v.7.4. The most outstanding and notable updates implemented in dbForge Studio for MySQL are:  

1) Support for Google Sheets for easy migration of table data between MySQL tables and Google Spreadsheets. The feature is incorporated into handy Data Export / Import Wizard, and the only thing users should do now is to specify the URL/ID of a Google Spreadsheets table.

2) Improved SQL document management with Execution notifications and Transaction Reminder as well as highlighting of the current code line.

3) Enhanced Code Completion with dozens of new variables and functions supported (Percona Server variables, MySQL Server variables, variables for MariaDB Server, etc.)

4) Both, schema/data comparison and synchronization wizards feature a new progress window with the list of processes taking place and specification of time elapsed. A brand new schema comparison and synchronization engine is implemented as well.

5) Now, dbForge Studio for MySQL allows copying databases seamlessly through the command-line interface and alerts users about the result of database copying.

dbForge Studio for MySQL is a universal GUI tool for MySQL and MariaDB database administration, development, and management. The IDE allows you to create and execute queries, develop and debug stored routines, automate database object management, analyze table data via an intuitive interface, and much more.

To see the full list of updates implemented in dbForge Studio for MySQL v.7.4, please visit: https://www.devart.com/dbforge/mysql/studio/.

About Devart

Devart is one of the leading developers of database tools and administration software, ALM solutions, data providers for various database servers, data integration and backup solutions. The company also implements Web and Mobile development projects.

For additional information about Devart, visit https://www.devart.com/.

Devart has released a new version of Devart Excel Add-ins that allow connecting Excel to cloud and database data, edit this data, and save it back to the data source. The update offers many major improvements like advanced Edit Mode, refined data Refresh options and new cloud app add-ins.

Devart team, a recognized vendor of professional database management software for developers and DBAs, has announced the release of Devart Excel Add-ins 1.7. The update allows much more convenient and flexible editing and refreshing cloud and database data, including:

1) Advanced Edit Mode that eliminates a lot of previous limitations. Now a user can freely:

   • Copy and paste data in the Edit Mode, including pasting multiple rows, and copying data in the same workbook and worksheet with the imported table
   • Use many Excel editing features, like formulas, scripts, Autofill, etc.
   • Sort and filter of the table with imported data, hiding and unhiding columns, allows editing data outside of the imported table on the same worksheet, etc.
   • ...and many more.
     
      2) Refresh Improvements that preserve user's data, entered outside of the table with imported data on the same worksheet, data sorting settings in this table and table styles. Moreover, the new Refresh options allow users:

   • See the refresh operation progress and cancel it if necessary
   • Disable confirmation dialog boxes when starting refresh

3) Other Improvements that include the following handy features:

   • Excel Add-in for Zendesk has supported custom fields for certain Zendesk objects
   • Excel Add-in for Magento offers a more convenient connection editor for connecting to Magento 2 servers
   • Excel Add-in for Salesforce now allows connecting to Salesforce Sandbox
It’s worth to mention that Devart Excel Add-ins now fully support Windows scaling for high-DPI devices and display progress of commit changes operations.

For more information about improved Devart Excel Add-ins, please visit https://www.devart.com/excel-addins/.

Hey guys! Devart announced the first release of dbForge Studio for PostgreSQL that allows to manage and develop database objects in PostgreSQL. This new IDE offers many robust features like Code Completion, Object Explorer and Data Editor which help users create, develop and execute queries as well as edit and adjust the code to their requirements in a convenient and user-friendly interface.

Devart, a Czech software provider of database connectivity solutions and tools for database management and development, announced the first release of dbForge Studio for PostgreSQL. Using this tool,users can view all the required information of PostgreSQL database objects they are interested in. In the first version, dbForge Studio for PostgreSQL offers the following key features:

1) Code Completion enables users to save their time and enhance the code quality while writing SQL queries with the help of numerous helpful functionalities like:
   • List Members
   • Parameter Info
   • Quick Info
   • Complete Word

2) Object Explorer with expandable objects allows users to navigate through the object tree, find any PostgreSQL objects of interest and perform the following tasks:
   • Retrieve data from a table to present on a single SQL document
   • Truncate a table
   • Select Properties to view specific information on objects

3) Data Editor simplifies the process of editing PostgreSQL table data offering many handy capabilities:
   • Editing data similar to Google Sheets and MS Excel or in the card view mode
   • Managing the settings of tables, such as adjusting column width
   • Setting either paginal or auto-search mode by default
   • Changing colors and formats of rows and cells using a rich set of fonts and sizes
   • Providing predefined data type formats so that users can select the most suitable for their needs

For more information about dbForge Studio for PostgreSQL, please visit https://www.devart.com/dbforge/postgresql/studio/

Devart, a recognized vendor of professional database management software for developers and DBAs,   announced the release of dbForge Studio for SQL Server v5.5 with such significant features as Executed SQL Statements History, Support for Surround SCM predefined template, SQL Server 2016 Service Pack 1 (SP1) and SQL Server 2017 CTP2 new syntax support.

dbForge Studio for SQL Server v5.5 has received multiple improvements, and here are only several of them:

* SQL Server 2017 RC2 new syntax supported;
* Query Execution History - dramatically redesigned;
* New Feature - Monitor Server Performance;
* Lots of improvements in:
- Schema Compare
- Data Generator
- Source Control
- Code Completion
- Documenter
- Index Manager

dbForge Studio for SQL Server is an integrated environment for SQL Server development, management, administration, data reporting, and analysis. SQL Manager tool allows users to create, edit, copy, attach and detach, backup and restore databases from one server to another easily. These SQL tools help developers to manage databases, make complex database changes and speed up routine tasks.
To learn more, visit http://www.devart.com/dbforge/sql/studio/
About Devart
Devart is one of the leading developers of database tools and administration software, ALM solutions, data providers for various database servers, data integration and backup solutions. The company also implements Web and Mobile development projects.  
Learn more about Devart at https://www.devart.com.