Annual prognostications are typically overly optimistic, so for 2010’s soothsaying I’ve opted for a more pragmatic approach.
Austerity drives innovations in doing more with less – The 2009 budgetary hangovers while I expect to less restrictive this year, will drive nearly all purchasing decisions this year. A need to demonstrate obvious and immediate on any return [...]
{ 0 comments }
In this podcast Rob Steward shares why Progress Software is a great place to work, and he provides insights into corporate culture. This podcast lasts for 3:24.
{ 0 comments }
I recently read a blog entry where the author went to great lengths to explain what he did to make an application originally compiled as 64-bit for production deployment onto a 64-bit Windows platform work with the the 32-bit ODBC driver that he was using. My reaction, well, yeah, that’s one way to solve your [...]
{ 2 comments }
We frequently encounter customers who are using SQL Server, Teradata, DB2, Sybase and other databases, who want to integrate these data sources with their Oracle environments. Generic Connectivity, also referred to as Heterogeneous Services or OHS, enables users to integrate data that may exist on several different databases.
In this post, we will focus on the [...]
{ 0 comments }
Here is a video I’ve prepared showing how the DataDirect Data Integration Suite can be used to create customized ETL functions through the graphical mapping interface. By taking these fundamentals and adding functionality to fit your needs, you will be able to quickly and easily develop transformations that can then be deployed within your environment.
{ 0 comments }
In the previous post I introduced you to the idea of using the Data Integration Suite as a way to deploy ETL functions for moving data from database and file formats into a new database. A complete list of the data sources you can use for ETL processes can be found at Data Source Support. [...]
{ 0 comments }
As you’ve done with DB2 in part 1, you need to configure a Progress DataDirect ODBC Driver for the target database, which is Oracle.
Enter all of the connection information for the target Oracle database.
Do a “Test Connect” to ensure no fat-fingering. Not surprising, you need to supply your user name and password.
Assuming no typos or [...]
{ 0 comments }
In this post, we’ll focus on the extraction of the data from the DB2 system. You’ll learn how to configure your machine to easily extract data from DB2 on z/OS in preparation for a bulk load without running any command-line utilities or writing any SQL!
Requirements: A current Windows machine, either 32-bit or 64-bit. I’ll actually [...]
{ 0 comments }
You have an ongoing requirement to move data from one database to another. In this case, your operational data is in DB2 database running on z/OS on the company mainframe. There is a business need to periodically copy the data to an Oracle database. (The DB2 system is “off-limits” when it comes to ad hoc [...]
{ 0 comments }
Progress DataDirect recently hosted successful workshops in South and North India and has decided to extend the well-received workshop agenda to new cities this October. The Data Connectivity Workshops covered various aspects of DataDirect’s well-established data access middleware that offers seamless connectivity between heterogeneous clients and heterogeneous data sources. These products ultimately decrease development and [...]
{ 0 comments }
