Hi everyone, Andy from Easysoft Limited here, what I want to show you today is how to get data from SQL Server into Oracle.
Now for this we will be accessing SQL Server 2014 from Oracle 12 and getting data across.
This could be quite easily be any SQL Server version from 2008 and any Oracle version from 11.2, the configuration and process is the same. We can obviously get access to data on SQL Server prior to 2008 and Oracle prior to version 11.2 but it will need a different configuration to what I am going to show you today
The plan is also to add more data to the SQL Server table and show this new data back in Oracle.
To start off you'll need access to ensure that you have access to your SQL Server and Oracle databases.
You'll also need the Easysoft SQL Server ODBC Driver available from www.easysoft.com; just download it, install it and request the free 14 day trial licence.
Before we start we need to make some changes to the standard Easysoft config files.
Here I have changed Mars Connection to Yes. It must be set to "Yes" if you are connecting to SQL Server 2005 or newer.
Easysoft supports all SQL data types from the version of SQL Server from version 7.
Oracle supports data types that are common to most ODBC Drivers, but not some of the SQL Server ones.
If you intend to access VARCHAR(MAX) for example, then there are some additional settings that need to be set up.
Now as I would like to show you VARCHAR(MAX) data moving from SQL Server to Oracle, I have made the relevant change.
As you can see, VarMaxAsLong says "Yes"
We now need to create a link from Oracles Database Gateway (DG4ODBC) to the ODBC datasource that we already have, this is done in an init(sid) oracle file; let's have a look at our file.
Please note that HS_NLS_NCHAR must be set to UCS2
Oracle assume that most database vendors use UTF-8 for wide characters, however Easysoft, like almost all ODBC Driver vendors (including Oracles own ODBC Driver) uses UCS2 for wide characters.
So that's the link between DG4ODBC and the datasource setup correctly.
Next we need to set up the Listener entry
The Oracle Listener waits for incoming requests from the Oracle database. For the Oracle Listener to listen for requests, information about DG4ODBC must be added to the Oracle Listener configuration file, listener.ora
The PROGRAM=dg4odbc tells the Listener that we are wanting to use the Oracle database gateway to communicate with ODBC.
The ENVS=LD_LIBRARY_PATH tells Oracle what library to load
Now that's all set up and OK we need to tell Oracle which server to attach the listener entry to. This is done in tnsnames.ora, and he is the file that we ensured was set up earlier.
The Oracle Listener now needs to be restarted.
OK, that's now started the Listener up again.
So we have ensured that all the configuration files are set up correctly.
The Listener and tnsnames.ora both set up OK.
The final step is to create a link from the Oracle database to the "tnsnames.ora" entry.
CREATE PUBLIC DATABASE LINK ODBC CONNECT TO "test" IDENTIFIED BY "test" USING 'sqlsrv_ptr';
Right, that's all done.
Let's access the data in SQL Server now.
select * from [email protected];
Where 'demo' is the name of the SQL Server table and 'odbc' is the public database link name.
OK, there we have the data. So to recap, I'm in Oracle and we have managed to read the data from SQL Server.
Let's just add an additional row in that SQL Server table and retrieve the new data in Oracle.
/usr/local/easysoft/unixODBC/bin/isql.sh -v sqlsrv
insert into demo values (2,'Easysoft')
select * from demo
select * from [email protected];
And there is the new data.
Easysoft Limited can help you with your data access ... for our full range of ODBC and JDBC Drivers, Bridges and Gateways visit easysoft.com
Be sure to let us know if you have any comments or questions.
Until next time, thanks again and we'll see you again soon.
I love this edgy look! I was so excited that her hair, even as short as it is now, was still able to be put into the fun and trendy dutch pigtail braids! Instead of braiding to the ends, I ended them in close together pigtails at the nape of her neck. After I finished braiding, I tugged on the outsides of the braid gently to loosen them and make them a little messy and fun! Since she doesn’t have enough hair to tie around the elastics, I made sure to use elastics that matched her hair so they blend in as much as possible. You could also cover them with clips or bows! A view from the back of her Dutch pigtail braids! A great braid for short hair is a micro accent braid! My biggest tip for braiding short hair would be to add in small slices of hair rather than big ones. I did a small (micro) braid along a slightly curved deep part for anther cute and edgy look! You could also do another one next to it if you wanted a little more to the look, but I really liked how simple this one was. You can see how the part curves a little better from this view of the back. I ended the braid close to the head with an elastic that matched her hair. For our fourth style, we did a 3/4 french braid! Super simple but also super cute! You could do any type braid! It would also look cute using a Dutch braid or a fishtail braid! I loved the side view of this braid! I will for sure be doing this one next time she goes to gymnastics or swimming, whichever comes first! Our last braid is two four dutch lace braids into two loops in the back. Start off by parting the hair down the middle. On each side of the part, do a dutch lace braid, adding hair in from only the section closest to the part as you braid. Tie the braids together in the back with a small elastic and before you pull the hair all the way through to make a ponytail, leave it in a cute little loop! If the hair is a little bit longer, you could do a tiny bun. Repeat this directly under the braid you just did so you have two rows and two loops.
We will have to be coming up with lots more short hair braids in the future, so be sure to give us a follow over at our newly redesigned blog Abella’s Braids to see more as we do them!
Thanks for reading! See you again this time next month!
love these ideas! My daughter recently cut about 8 inches off her hair and is loving her shorter hair, but I’ve mostly been at a loss of what to do with it! Thanks!
Abella has been begging me for at least a year, probably closer to two years, to cut her hair. I posted a photo on Instagram with a question in the caption. “Abella has been begging me to cut her hair short, do you think I should let her do it?” Almost everyone said “YES!” So thanks to all of the good advice from my followers, we did it…and we haven’t regretted it for a second! I think she looks so cute and it really fits her personality! It’s for sure a lot harder to come up with braids but it’s pushed me to step out of my comfort zone! We wanted to show you that even if you have short hair, there are lots of cute braids you can still do!
This first braid (above) is three ladder braids. Start out with a part deep to one side. On the side with less hair, start out by doing a waterfall braid along the part. Under that one, do another waterfall braid, but incorporate the waterfall pieces from the one above it as you braid. Under that one, do a french braid. Incorporate the waterfall pieces from the second braid as you go. We braided each one to the ends and used elastics that matched her hair to tie them off.