Alchemy Solutions' VSAM to SQL Server Migration Tool Adds Search and Filtering

Share Article

Alchemy Solutions NeoData v2.0.17.0 chocked with new features

Alchemy Solutions, Inc., announced the latest version of their VSAM to Microsoft SQL Server migration tool, NeoData, today. NeoData v2.0.17.0 includes search and filtering functions, greatly improving speed and flexibility.

"These new features will make transforming VSAM data to SQL Server faster and more accurate than ever," says Alchemy Solutions Vice President of Strategy and Alliances Raul Menendez. "Users can create, save and load filters, allowing them to quickly find the data they need without searching manually. And they can do it all without writing or modifying COBOL code."

To access VSAM files on a mainframe, business must write custom COBOL programs. NeoData splits inaccessible data files into easily digestible, database-standard bits. With NeoData, business can generate reports and view data instantly, take advantage of relational databases and leverage new business logic using modern languages like C# and VB.NET.

"Customers who need to migrate VSAM files to SQL Server to gain the full benefits of SQL Server data management can now take advantage of the latest version of NeoData,” said Persio Afonso, director, SQL Server Marketing. “The goal of NeoData is to make the conversion as pain-free as possible to ensure that customers can quickly use SQL Server’s advanced functionality.”

NeoData v2.0.17.0 also includes a migration wizard to assist with SQL-CLR UDT deployment, additions to the NeoDataTool Command Line utility, the ability to create endpoints directly from mainframe catalogs and support for Microsoft .NET Framework 3.5.

SQL-CLR UDT Deploy & Migrate Wizard

The new NeoData SQL-CLR UDT Deploy & Migrate Wizard makes deploying SQL Server databases simple and straightforward. It allows businesses to launch databases quickly to meet user and customer demands. The wizard includes options for database connection, deployment choices, data preservation and SQL Server preservation.

NeoDataTool Command Line Utility Additions

The NeoDataTool command line utility can now be used to modify certain NeoData project attributes and change multiple NeoData projects at once, greatly improving efficiency during data translation. Change project names, mapping properties and SQL Server collation. The tool can also be used to change the endpoint values of name, file name, record layout, byte order, character-encoding type, float format, zoned decimal format, DB connection string and SQL Server table prefix.

Endpoint Creation Directly from Mainframe Catalog

NeoData v2.0.17.0 now has the ability to create an endpoint directly from a mainframe dataset. The Endpoint Type is “Mainframe Record Sequential” and employs the FTP transfer and mainframe catalog browsing capabilities within NeoData. The Mainframe Record Sequential Endpoint property fields contain specific information about the dataset and how to transfer it from the mainframe. Both VSAM and Sequential files can be transferred.

About Alchemy Solutions

Alchemy Solutions modernizes business IT through software developed for the Microsoft application platform. NeoData™ converts indexed data files to SQL. NetCOBOL® for .NET runs COBOL on the Microsoft .NET Framework. NeoKicks™ translates CICS to ASP.NET web pages. NeoBatch® executes JCL in Windows. The mainframe modernization tools can also launch COBOL and CICS into the cloud via Windows Azure. Alchemy Solutions, Inc. is a privately held company with its headquarter in Bend, Oregon, USA.


Dustin Driver
Marketing Communications    
Alchemy Solutions


Share article on social media or email:

View article via:

Pdf Print

Contact Author

Dustin Driver
Email >
Visit website