★Oracle Big Data Lite Virtual Machine
- Oracle Enterprise Linux 6.4
- Oracle Database 12c Release 1 Enterprise Edition (126.96.36.199) with Oracle Advanced Analytics, Spatial & Graph, and more
- Cloudera’s Distribution including Apache Hadoop (CDH 5.0)
- Oracle Big Data Connectors 3.0
- Oracle SQL Connector for HDFS 3.0.0
- Oracle Loader for Hadoop 3.0.0
- Oracle Data Integrator 12c
- Oracle R Advanced (more...)
While preparing for my session at Oracle Open World on "Oracle 12c for Developers" I ran into a little remarkable thing.
When sorting a dataset, the sorting is always done last. That is what I was taught anyway. There is probably some obscure way to detect the exact execution plan, but personally I never bothered to go and investigate.
When I was created some test scripts I found there was a way to see that (more...)
In my previous blog, we looked at Oracle ACM's Title, Priority, and Category artifacts and their configurations in an Oracle ACM project. In this blog, we will dig a bit deeper into ACM, specifically ACM Activities. Within an ACM Case, when you create an ACM Activity, you are presented with a few properties that need be set for the activity. The values you select in these properties will define that activity. In this blog (more...)
R language is useful to become a data scientist, as well as a computer scientist. I mention a book that points about a data science with R. A Hands-On Programming with R Write Your Own Functions and Simulations By Garrett Grolemund. It was written how to solve the logistical problems of (more...)
By Brent Dayley, Senior Instructor at Oracle University
"While teaching Oracle University classes on Oracle Data Integrator, I often instruct my students that it takes roughly one and a half days to understand the setup that we do in ODI Studio in order to start to map data from source to target. I start out by giving them a visual tour of the four navigators: Topology, Security, Designer and Operator."
Another OTN Tour Latin America has come and gone. This is the most important technical event in the region visiting 12 countries and with more than 2500 attendees in two weeks.
This year Rittman Mead was part of the OTN Tour in Buenos Aires (Argentina) and Montevideo (Uruguay) presenting about ODI and OGG.
We have started in Buenos Aires on August 11 for the first day of the OTN Tour in Argentina. I’ve talked about (more...)
By Tim Gorman
I recall that the Dec 1999 or Jan 2000 issues of Nat’l Geographic magazine had a “Letters From The Editor” column that speculated, in jest, that the rate at which humans were saving back-issues of Nat’l Geographic magazine, would by the year 2100 result in the total accumulation of yellow magazines outweighing planet Earth.
Anyway, that statement resonated with me, because although I change residences every few years, it has only been (more...)
Oracle’s 188.8.131.52 was released a few weeks ago (You can download it from OTN here: Oracle 184.108.40.206 Download). While technically a minor point release, it contains a couple of major features that would normally be rolled out in a more substantial version change like 12cR2 or perhaps V13. Of course the most highly anticipated feature is a new option (Oracle In-Memory Option) that provides a column (more...)
I’m often engaged with clients helping them respond to Requests for Proposals (RFPs), and there are way too many bad RFPs out there.
These bad RFPs not only specify what the customer actually needs, they also specify that the customer can possibly think he will ever need. Typical requirements are that the user must be able to add extra attributes to all entities, or that the user can dynamically change which attributes are mandatory, or (more...)
A TNS error at night…
Sometime ago my data warehouse colleague came to me with a TNS error. At night times he runs his batch jobs in order to update his data warehouse. That night one of his jobs did not run properly and generated an ORA-12592 error. He had to restart this job during daytime.
It turned out it was not the only occurrence of this TNS error. A couple of days later he (more...)
When you have scripts for creating tables, packages etc., in the current version you have to manually keep those (more...)
A Pandas DataFrame has a nice to_sql(table_name, sqlalchemy_engine) method that saves itself to a database.
The only trouble is that coming up with the SQLAlchemy Engine object is a little bit of a pain, and if you're using the IPython %sql magic, your %sql session already has an SQLAlchemy engine anyway. So I created a bogus
PERSIST pseudo-SQL command that simply calls
to_sql with the open database connection:
%sql PERSIST mydataframe
The result is (more...)
If you’ve been following our postings on the blog over the past year, you’ll probably have seen quite a lot of activity around big data and Hadoop and in particular, what these technologies bring to the world of Oracle Business Intelligence, Oracle Data Warehousing and Oracle Data Integration. For anyone who’s not had a chance to read the posts and articles, the three links below are a great introduction to what we’ve been up to:
In the first part of these entries we discussed how to test your expressions, the importance of optimizing the appearance of a tLogRow component and how to handle windows and views within Talend. This time around, we will be talking about the different ways to get components into your job, how to trace your dataflow and how to easily sync columns. As last time, this post will be useful for both starting and experienced users.