Good morning.

I am trying to link my management studio 2014 to an oracle db that I only have a view access.

I am trying to copy tables from there.

And I am...

Thanks for your help. I will tried what you have suggested and update on how it went. 🙂

I am sorry I forgot to add, I don't have any permissions from the oracle side, only from my own side.

I need to try to do everything from my side.

thanks

Thanks for your reply.

I have installed drivers but they don't show on the management studio when I try to create the linked server.

Maybe there is something wrong with my installation,...

well it is a small database and it is being just tested, since i needed a solution first thing next week i will do simple java which i haven't written...

i will check it out and let you know how it went, i am also trying an oldb connector. i managed to connect, but that is as far as i...

hi,

i know you can import mongo to csv, and probably grab the csv using ssis

but the problem is the architecture of mongo, which as may see i dont understand fully

i...

Hi,

Did you get a reply on how to do it? I am facing the same problem, need to export my mongodb db into sql server to make a dw and...

thanks to you too. google didnt help much this time around 😎

thanks so much!!!! 😀

I will prepare a litter of coffee and sit down for some light reading 😀

thanks to you too so much for your help.

I will let you know how it went....

p.s. if someone can tell me how to post a table, i will gladly draw the results 😀

Thanks for your help.

I did a few changes on the query, but i am still encountering a few problems.

it is not summing the clickcount, i do get a three dimensional...

i am trying to get

on the columns the dates

on the rows the hours (from those dates)

and the sum of the clicks as a measure.

the same i gave has a few...

hi,

please find the sample requested

CREATE TABLE clicks (RecordDay datetime, ClickCount INT)

GO

INSERT INTO clicks (RecordDay datetime, ClickCount INT)

VALUES(2013-10-05 13:23:44, 2)

INSERT INTO clicks (RecordDay datetime, ClickCount INT)

VALUES(2013-10-05 15:45:21, 6)

INSERT INTO clicks (RecordDay...