We are new to using OpenDB, and I am working on getting the data into our data warehouse (SQL Server). Currently, I am using WhereScape RED to manage the ETL (using ODBC).
This seems like a viable solution for incremental nightly loads. However, for the initial load of the historical data some of the tables are very large and difficult to load.
Does anyone have any good tools or best practices for getting this setup?
Colorado Christian University