AUTHOR DETAILS

  • Paul Chang5 Posts

    Paul Chang is a Senior Technical Support Engineer at Rocket Software. He is responsible for supporting all U2 common middleware client products, Java products and .NET clients. He has 35 years of experience in computing and holds a master’s degree in Computer Science with an emphasis on Relational Database Design.

Tutorials UniData Universe

UniVerse External Database Access (EDA) with I-type field dictionary items against SQL Server

Overview External Database Access (EDA) enables you to convert data stored in Rocket UniVerse and Unidata databases to a first normal form (1NF) database, such as Microsoft SQL Server, then access that data using existing UniVerse BASIC programs, RetrieVe, or UniData/UniVerse SQL. For the UniVerse I-type fields, they can be mapped in many ways to […]

Technology Tutorials Universe

UniVerse External Database Access (EDA) with Microsoft ODBC Driver 17 for Linux

Overview External Database Access (EDA) enables you to convert data stored in a Rocket UniVerse and UniData database to a first normal form (1NF) database, such as Microsoft SQL Server, then access that data using existing UniVerse BASIC programs, RetrieVe, or UniData/UniVerse SQL. For UniVerse running on a Linux platform, previously you had to purchase […]

Technology Tutorials UniData Universe

Business Intelligence Development Studio (SSIS) and U2 Toolkit for .NET v.2.2.2 with a Native Connection

Overview Microsoft SQL Server Integration Services (SSIS) is a platform for building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing. It can transfer UniData or UniVerse data to SQL Server very easily. If you use a uci connection to access a UniData or UniVerse server, you must normalize your […]

Technology Tutorials UniData Universe

Improve program performance by up to 300 times faster using the Rocket U2 Toolkit driver

If you are trying to improve performance on a client-server application accessing UniVerse or UniData data files, then this blog is written for you. Minor code changes are required, but these changes can dramatically improve program performance, making it 100 to 300 times faster. Historically, most client-server or web applications accessing a chunk of information […]

Technology

Creating a new Entity Data Model using VS 2013 to work with Entity Framework 6.1.3

If you use your U2 accounts to access SQL-based applications, then this blog is written for you. Here I’ll discuss Entity Framework, Visual Studio and provide some screen shots and sample code. Entity Framework 4.0 or 5.0 is part of old Visual Studio (VS) versions. When upgrading to VS 2013 or later versions, it creates […]