Oracle Data Warrior

Taking on Data Architecture, Data Warehousing, Data Vault, Fitness, Exercise, and who knows…

Archive for the tag “Free”

14 Jan 2013
6 Comments

Tech Tip: Connect to SQL Server Using Oracle SQL Developer

I spend a lot of time reverse engineering client databases to see what kind of design they are working with or to simply create a data model diagram for them (so they know what they have).

Along the way I often need to actually look at the data as well to do some analysis and profiling.

Often this means looking at data and models in SQL Server as well as Oracle.

What’s an Oracle Data Warrior to do?

Hook up my FREE handy dandy Oracle SQL Developer to the SQL Server database.

How do you do that?

First you need to get the right driver. You can find it here: http://sourceforge.net/projects/jtds/files/jtds/1.2.5/jtds-1.2.5-dist.zip/download

Then follow these steps:

  1. Download and unzip the file into the main SQL Developer directory (or the directory of your choice).
  2. In SQL Developer go to Tools -> Preferences -> Database -> Third party JDBC Drivers
  3. Click the “add entry” button
  4. Navigate to the jtds-1.2.5.jar file.
  5. Save and exit preferences.
  6. Close and restart SQL Developer
  7. Open “Add Connection” – there should now be a SQL Server tab.
SQL Developer Preferences

SQL Developer Preferences

With this in place, you can now connect to SQL Server without having to load any other software.

Pretty useful.

Happy Querying!

Kent

P.S. You can connect to other non-Oracle dbs as well. Check out this post by Jeff Smith for even more details.

 

Posted in Oracle and tagged , , , , , , , , , , ,
14 Oct 2012

Hurry – Only 24 Hours Left to Get a Free Conference Registration

As I have written before, I love Oracle User Groups.

My two most favorite groups are the Oracle Development Tools User Group (ODTUG) and the Rocky Mountain Oracle Users Group (RMOUG).

These two groups put on what are arguably the best annual conferences for users of Oracle technology – by users, for users.

Over the past 20+ years I have attended most of their events – and NEVER paid a registration fee.

This was very helpful when my boss said there was no money for training. I just said “I get in free”.

So would you like to attend one of these events for FREE?

All you have to do is submit an abstract to present a session. If you get selected, your registration fee is waived. This is worth over $1000.

But you have to hurry, the deadline for submission is Monday October 15th, 2012.

Details:

RMOUG Training Days is  February 11-13, 2013 in Denver, Colorado. (Right in the middle of ski season!)

Go here to submit an abstract.

ODTUG’s KScope event will be June 23-27th in wonderful New Orleans.

Go here to submit an abstract.

I have submitted multiple abstracts to both events.

So what are you waiting for – go submit now!

See you in Denver and New Orleans in 2013.

Kent

P.S. My Kindle ebook  started out as a user group presentation. No telling what you might do with your presentation.

Posted in ODTUG, Oracle, User Groups and tagged , , , , , , ,
08 Mar 2012
1 Comment

How many kinds of data models can you name?

When someone says they are building a data model, that can mean many different things to many different people. My long-time friend and mentor, Dave Hay, has produced a very helpful and detailed video called “Kinds of Data Models, and How to Name Them.”

It is very useful for not only beginning data modelers but for experienced folks too as it will make you think about the language you use when talking about data models.

Heck, this will be good for managers too – it will help you be much more specific when you are interviewing candidates for data model and data architecture positions.

And, best of all it is free for everyone to watch. Check it out here.

Post it, re-post it, Tweet it. You know the drill…

Later.

Kent

P.S. Stay tuned for a way cool data vault training opportunity. If you have not subscribed to my blog yet, now is the time so you don’t miss this announcement.

Posted in Data Modeling and tagged ,
26 Feb 2012

More free stuff!

Hey gang,

I have been working hard over the past few weeks to find some of my old white papers so I could make them available to everyone on my blog site. Well, I finally found a few of them on some flash drives and figured out how to upload them to here to WordPress.

If you look above you should now see a new menu item called “White papers”. Click that link to get access to the papers I have found so far.

They are FREE for you to download. I am not even asking you to “opt in” or anything.

I just ask that you respect the copyrights and tell folks where you found them (share on Facebook, LinkedIn, Tweet it, etc).

I know there are more but have to figure out which ones are still useful (or at least moderately so). So be sure to check back often to see what I have added.

If you remember any I did in the past you might want a copy of, tell me in the comments (below) and I will see if I can find it.

Oh and as a bonus, I have also included a copy of my recent “Introduction to Data Vault Data Modeling” article just in case you have not read it yet.

Hope you find some of these useful. Have a great week!

Kent

P.S. I am thinking about publishing some of these, with minor revisions, to Kindle. Do you think that would be useful to any of you?

Posted in Data Modeling, Data Vault, Data Warehouse, Oracle and tagged , , , , ,

Post Navigation

Follow

Get every new post delivered to your Inbox.

Join 384 other followers

%d bloggers like this: