Build, protect and deploy apps across any platform and mobile device
Deliver Awesome UI with the most complete toolboxes for .NET, Web and Mobile development
Build rich, smart HTML5 and JavaScript apps for any platform, browser or device
Automate UI, load and performance testing for web, desktop and mobile
Use Angular, TypeScript or JavaScript to build truly native mobile apps
Rapidly develop, manage and deploy business apps, delivered as SaaS in the cloud
Automate decision processes with a no-code business rules engine
Build mobile apps for iOS, Android and Windows Phone
A complete cloud platform for an app or your entire digital business
Deploy automated machine learning to accurately predict machine failures with technology optimized for Industrial IoT.
Optimize data integration with high-performance connectivity
Connect to any cloud or on-premises data source using a standard interface
Build engaging multi-channel web and digital experiences with intuitive web content management
Welcome to the Amazon Redshift insert challenge (no s3 or ice buckets). So LIVE at Oracle OpenWorld 2014 #OOW14, I have been challenged by data professionals to load 1 million records into Amazon Redshift from Oracle Data Integrator WITHOUT using an S3 bucket during a live #OOW14 session: Oracle Data Integration: A Crucial Ingredient for Cloud Integration [CON7926]:
@SAsInSumit million row insert live, what could go wrong? — Jeff Smith (@thatjeffsmith) September 12, 2014
@SAsInSumit million row insert live, what could go wrong?
@SAsInSumit @DataDirect_News #ODI can do many things, but this may be tough. And live? I don't know... — Michael Rainey (@mRainey) September 12, 2014
@SAsInSumit @DataDirect_News #ODI can do many things, but this may be tough. And live? I don't know...
@SAsInSumit @DataDirect_News Seeing is believing. Can't wait to actually SEE that :P — Christophe Dupupet (@XofDup) September 12, 2014
@SAsInSumit @DataDirect_News Seeing is believing. Can't wait to actually SEE that :P
@SAsInSumit @DataDirect_News PROVE IT! I will believe it when I see it!!!! — Sarah CraynonZumbrum (@EPM_Queen) September 12, 2014
@SAsInSumit @DataDirect_News PROVE IT! I will believe it when I see it!!!!
Amazon Redshift is just one cloud data source, so we'll also demo and talk about connecting various cloud data sources to build an Oracle data warehouse with ODI listed below. We know this is a hot topic since my last two sessions on Salesforce data integration at Dreamforce 12 and 13 both sold out.
Since 1 million rows takes awhile, I put a filter to only load 40,288 rows which is taking 790 seconds or ~13 minutes. We're looking at close to 6 hours to load 1M at this rate.
But I'm not worried about it since I am backed by the greatest R&D team for data connectivity in the world at Progress DataDirect; and plan to use the new DataDirect Amazon Redshift JDBC Driver.
@SAsInSumit @DataDirect_News This could be the best #ODI12c demo ever or not... Do you really think you can pull it off? #oow14 — Julien Testut (@JulienTestut) September 12, 2014
@SAsInSumit @DataDirect_News This could be the best #ODI12c demo ever or not... Do you really think you can pull it off? #oow14
@SAsInSumit @JulienTestut @DataDirect_News Looking forward to #oow14 to see the demo succeed and collect winnings. Our tech is a safe bet :) — Brody Messmer (@brodymessmer) September 13, 2014
@SAsInSumit @JulienTestut @DataDirect_News Looking forward to #oow14 to see the demo succeed and collect winnings. Our tech is a safe bet :)
If we pull this off, I will ask Julien Testut, Principal Product Manager for ODI, who is hosting the session to buy everyone in the audience a local treat (Morning Bun or Cup of Philz?).
Get started with a trial download today.
Or tweet to @DataDirect_News, talk to us on live chat or call 1-800-876-3101.
Sumit Sarkar is a Chief Data Evangelist at Progress, with over 10 years experience working in the data connectivity field. The world's leading consultant on open data standards connectivity with cloud data, Sumit's interests include performance tuning of the data access layer for which he has developed a patent pending technology for its analysis; business intelligence and data warehousing for SaaS platforms; and data connectivity for aPaaS environments, with a focus on standards such as ODBC, JDBC, ADO.NET and ODATA. He is an IBM Certified Consultant for IBM Cognos Business Intelligence and TDWI member. He has presented sessions on data connectivity at various conferences including Dreamforce, Oracle OpenWorld, Strata Hadoop, MongoDB World and SAP Analytics and Business Objects Conference, among many others.
Copyright © 2017 Progress Software Corporation and/or its subsidiaries or affiliates. All Rights Reserved.
Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.