Archive for the category “Oracle”

18 Dec 2015

Data Warrior Agenda for 2016

Hard to believe 2015 is almost over.

It was a very busy year for me:

Lots of interesting #AgileDataWarehouse work as an independent consultant. Worked on at least 4 different clients with 4 different partners. (and thankful for every one!)
Recorded two online training classes with my good friend Dan Linstedt at LearnDataVault.com
- Agile Methods & Data Warehousing
- Oracle SQL Developer Data Modeler Jumpstart
Spoke at several events:
- DAMA Houston
- RMOUG Training Days 2015
- World Wide Data Vault Consortium 2015 in Stowe, VT (the hills were alive!)
- KSCOPE15 in Hollywood, FL (great white party!)
- ECO2015 in Raleigh, NC (beer…)
- Oracle Open World 2015 (in the #Cloud)
- Did a presentation while on the road for the Oracle Virtual Technology Summit (VTS)
- Did a webinar for the ODTUG Leadership Training Program
- am I forgetting any?
Wrote a guest blog post series on Data Vault for the folks at Vertabelo
Got interviewed by the Opal Alapat for a profile piece on the ODTUG blog (thanks again)
Went to Colorado a few times to officiate at several advanced black belt exams for Rocky Mountain Tae Kwon Do (Denver) and Blue Wave Martial Arts (Salida)
Wrote a little Kindle book with tips for using Oracle SDDM (Sql Developer Data Modeler)
Wrote another Kindle book! This one on Data Vault 2.0.
Took a new position as Senior Technical Evangelist for Snowflake Computing (fyi – look for coming blog posts here)

All of that has entailed a lot of air miles! This year I have visited:

Denver (several times!)
Salida, Colorado
Hollywood, Florida,
Raleigh, NC
Charlotte, NC (thanks to Lynn Winterboer for that one!)
San Francisco
Redwood City, California (Oracle HQ)
Austin (drove this one)
Minneapolis/ St Paul (thanks to Redpill Analytics mostly)
Kansas City, Missouri
Portland, Maine
St Albans, Vermont
Stowe, Vermont
San Mateo, California (HQ for Snowflake Computing)

And that was just work related! Family trips took me to:

Galveston (beach!)
South Padre Island, TX (more beach!)
Road trip to Central NY:
1. Joplin, Missouri
2. Hannibal, Missouri (Mark Twain museum)
3. Chicago (to see robots at the Museum of Science and Industry)
4. Sandusky, Ohio (just to sleep)
5. Fulton, NY (to see my dad)
6. Old Forge, NY (summer vacation in the mountains!)
7. Huntsville, Alabama (NASA Rocket Center!)
Who knows – the year is not over yet!

Speaking in 2016

2016 will be very busy with the new job for sure. I am already booked for a bunch of events. Here they are so far:

Data Day Texas – January 16 in Austin, TX

TDWI Webinar – Dymstyfying Elastic Data Warehousing (with Philip Russom) – January 26th

BIWA Summit – January 26-28 at Oracle HQ

RMOUG Training Days 2016 – Febuary 9-11 in Denver, CO (I have 2 hour deep dive on Feb 9th). Register early for discounts.

Enterprise Data World – April 17-22 in San Diego. Register early for discounts (by the end of the year for the best rate).

ODTUG KScope16 – June 26-30 in Chicago, IL. Register early and be sure to book the hotel!

Also likely speaking at World Wide Data Vault Consortium (WWDVC) – May 25-28 in Stowe, Vermont (TBD)

And many more to come! (watch my twitter feed for updates)

Hopefully I will see you at one or more of these events!

Wishing a safe a joyous holiday season!

Merry Christmas & Happy New Year!

Kent

The Data Warrior

Posted in Data Modeling, Data Vault, Data Warehouse, ODTUG, Oracle, SnowflakeDB, SQL Developer Data Modeler, Tae Kwon Do and tagged #AgileDataWarehouse, #datavault, #ElasticDW, #Kindle, #SnowflakeDB, #SQLDevModeler, @dlinstedt, @KentGraziano, @odtug, @SnowflakeDB, agile, Data Modeling, Data Warehouse, Kindle book, Oracle, Oracle SQL Developer Data Modeler | Leave a comment

03 Dec 2015

Data Modeler 4.1.2.1.899 is out!

Attention all lovers of #SQLDevModler – there is a new version out with some major bug fixes. Get it today!

Thanks to Heli for posting this.

HeliFromFinland

Data Modeler 4.1.2.1.899 is out with plenty of important bug fixes. Go and try!

http://www.oracle.com/technetwork/developer-tools/datamodeler/downloads/index.html

From the download pages:

Oracle SQL Developer Data Modeler 4.1.2.1: Bugs Fixed

Date: December 2015

This list contains only a selection of higher priority bugs, customer bugs and issues raised by the community on the OTN Forum since the release of version 4.1.2.

22109015	Table structure not available in browser for versioned designs
22120662	“Oracle errors to mask” tab is always disabled
22112910	Table has columns with undefined security properties’ for xmltype column
22186607	Constraint definition is missing in ddl when custom ddl script is used
22187312	Error when running design rules using Data Modeler version 4.1.2.895

Cheers

Heli

View original post

Posted in Oracle | Leave a comment

20 Nov 2015

19 Comments

Tech Tip: Connect to Snowflake db using #SQLDevModeler

So, some of you may have noticed that I took “real” job this week. I am now the Senior Technical Evangelist for a cool startup company called Snowflake Computing.

Basically we provide a data warehouse database as a service in the cloud.

Pretty cool stuff. (If you want to know more, check out our site at snowflake.net)

I will talk more about the coolness of Snowflake (pun intended) in the future, but for now I just want to show you how easy it is to connect to.

Of course the first thing I want to do when I meet a new database is see if I can connect my most favorite data modeling tool, Oracle SQL Developer Data Modeler (SDDM), to it and reverse engineer some tables.

The folks here told me that tools like Informatica, MicroStrategy, and Tableau connect just fine using either JDBC or ODBC, and that since we are ANSI SQL compliant, there should be no problem.

And they were right. It was almost as easy as connecting to Oracle but it was WAY easier than connecting to SQL Server.

First you need a login to a Snowflake database. No problem here. Since I am an employee, I do get a login. Check.

We have both a web-UI and a desktop command line tool. Turned out I needed the command line tool which incidentally needed our Snowflake JDBC connector to work. Followed the Snowflake documentation, downloaded the JDBC drive (to my new Mac!). Piece of cake.

So connecting from SDDM is really easy. First add the 3rd party JDBC driver in preferences. Preferences ->Data Modeler -> Third Party JDBC Driver (press the green + sign, then browse to the driver).

Add JDBC Driver

As you can see our JDBC driver is conveniently named snowflake_jdbc.jar.

Next step is to configure the database connection. To do this you go to File -> Import -> Data Dictionary, then add a new connection in the wizard.

Configure Connection

Give at a name and login information, then go to the JDBC tab.

So getting the URL was the trick (for me anyway). Luckily the command line tool displayed the URL when I launched it in a terminal window, so I just copied it from there (totally wild guess on my part).

So the URL (for future reference) is:

jdbc:snowflake://sfcsandbox.snowflakecomputing.com:443/?account=<service name>&user=<account>&ssl=on

Where account is whatever you named your account in Snowflake (once you have one of your very own that is).

The driver class was a little trickier – I had to read our documentation! Thankfully it is very good and has an entire section on how to connect using JDBC. In there I found the drive class name:

com.snowflake.client.jdbc.SnowflakeDriver

That was it.

I pushed the Test button and success!

Now to really test it, I did the typical reverse engineer and was able to see the demo schema and tables and brought them all in.

Demo schema in Snowflake (no, not a snowflake schema!)

So I call that a win.

Not a bad weeks work really:

New job orientation
Start learning a new tech and the “cloud”
Got logged in
Installed SDDM on a Mac for the 1st time ever!
Configured to speak to an “alien” database
Successfully reverse engineer a schema
Blog about it.

So that was my 1st week a a Senior Technical Evangelist.

TGIF!

Kent

still, The Data Warrior

P.S. If you want to see more about my week, just check my twitter stream and start following @SnowflakeDB too.

Posted in Data Warehouse, Oracle, SnowflakeDB, SQL Developer Data Modeler and tagged #cloud, #SnowflakeDB, #SQLDevModeler, @KentGraziano, @SnowflakeDB, Data Warehouse, data warehousing

04 Nov 2015

Oracle SQL Developer Data Modeler 4.1.2

#SQLDevModeler got a recent update with some major bug fixes. Read Heli’s post for the details, then go get the newest version.

HeliFromFinland

The best news on Friday Oct 23rd was that version 4.1.2 of Data Modeler came out! We were really waiting for this release because of some bugs on 4.1.1 that made our lives quite difficult. Thank you development team for fixing everything so quickly and releasing 4.1.2 so fast!

If you have not downloaded it yet, this is the place to do it:

http://www.oracle.com/technetwork/developer-tools/datamodeler/downloads/index.html

Some bug fixes (http://www.oracle.com/technetwork/developer-tools/datamodeler/downloads/data-modeler-bugsfixed-v412-2714842.html):

This list contains only a selection of higher priority bugs, customer bugs and issues raised by the community on the OTN Forum since the release of version 4.1.1.

21310122	Interactive DDL for automatically generated Indexes contains an invalid semi-colon
21436619	Different formatting causes Table Check Constraint to be marked as changed
21450718	Missing check constraint ddl (arc constraint) during merge
21471733	Save doesn’t remove deleted foreign keys
21627534	Grant flashback on an oracle table not supported
21617909	Domain can’t be locked without…

View original post 165 more words

Posted in Oracle | Leave a comment

19 Oct 2015

1 Comment

SALE: Oracle SQL Developer Data Modeler Jump Start

So in honor of the upcoming #OOW15 and User Group Sunday Symposiums, I decided to put my video workshop for #SQLDevModeler on Sale!

Why use #SQLDevModeler?

If you were an Oracle Designer user and are looking for a replacement data modeling tool, or you are using one of the other mainstream, expensive modeling tools and want a more cost effective alternative, then you owe it to yourself to look at Oracle SQL Developer Data Modeler (SDDM). Data Modeler has been around for years now and is up to version 4.1. It really is an industrial strength data modeling tool that can be used for any data modeling task you need to tackle. (And it works with MS SQL Server and DB2, not just Oracle.)

#SQLDevModeler is a fully functional tool provided for FREE by Oracle. It has many features built in that can be leveraged to capture the design of an existing (probably undocumented) database and re-engineer it or you can use it to design a new database, even a data warehouse from scratch. There are features to apply standards, and then generate DDL to implement your newly standardized design. You can even use one logical model to develop multiple physical models that can be deployed to different RDBMS. You also have options on the type of notation used in the diagrams (i.e., Barker, IE, etc.).

Workshop? What Workshop?

I’m so glad you asked! 😉

Since there was no one around teaching classes on SDDM, I figured I should build one that would be easily accessible and show you exactly how to use the tool for the most common data modeling tasks.

This workshop will start from a totally blank page and walk you through all the major features and options of the tool to show you how to design build and deploy a database. I provide lots of examples and tips on how to do all this so that you can quickly be productive.

In this workshop, I introduce you to the tool and show you how to use some of the cool features I use almost daily. I provide step-by-step instructions on how to use these features.

In this 4+ hour long workshop you will see:

How to create new objects from a blank page
How to build a logical ERD (with sub-types!)
How to reverse engineer and document existing databases
How to reverse engineer logical models from physical
How to use the visual view builder
How to use the interactive view testing tool
How to reconcile a model to the database or the database to a model
How to generate DDL for multiple RDBMSs (Not Just Oracle!)
How to generate a script to change an existing database

Tips, tricks and features I will demonstrate:

Modifying the delivered reporting templates
How (and when) to use the abbreviations utility
How to use and apply domains
How to create and applying object naming templates
How to add audit columns to every table
How to add custom design rules for model quality checks
How to use the built in quality checks
How to use the newest find and extract feature to enable updating table and column comments by end users
How to generate a simple data dictionary

As an added bonus, in addition to step by step slides, I also give you a live demonstration of important aspects of the tool.

By the end of the workshop you will be able to effectively use Oracle SQL Developer Data Modeler for all your data modeling tasks.

So how about a sample?

The platform that we used to deliver the video is pretty darn good, but I figured you might want to see what the content looks like so here are two modules taken right out of the class. The first one talks about using sub views in SDDM, and the 2nd one talks about creating Entities.

Enjoy!

Subviews

Entities

Sale Coupon!

So ready to sign up?

Great. Go here to get right in!

Normally the price is $1299 (which is MUCH less than you would have to pay me to come to your office and teach you myself), but for a limited time, I am giving a big discount so that even more folks can afford it.

Use coupon code KentSDDM to get $300 off the regular price.

I am sure you will find this a very useful workshop with examples you can use (yes there are a few downloads when you finish the class). The examples alone will save you a bunch of time and money.

But don’t take my word for it:

I’ve seen a good bit of this course. It’s good stuff, and Kent is a great instructor and presenter. https://t.co/YlwBMNmnyx

— Jeff Smith (@thatjeffsmith) September 28, 2015

So sign up today, start watching, then you can ask me questions at #OOW15!

Cheers.

Kent

The Data Warrior

P.S. The sale will not last long, so be sure to jump in now to save $300 while you can. Go on, sign up here (you know you should).

Posted in Data Modeling, Oracle, SQL Developer Data Modeler and tagged #BetterDataModeling, #SQLDev, #SQLDevModeler, data model, data model design, hands on workshop, sale on training, Training, training on Data Modeler, training on Data Modeling, training on SQL Developer Data Modeler

The Data Warrior

Changing the world, one data model at a time. How can I help you?

Archive for the category “Oracle”

Data Warrior Agenda for 2016