Showing posts with label method. Show all posts
Showing posts with label method. Show all posts

Friday, March 23, 2012

Need Direction on WHAT to Implement...

Please understand that I am not asking HOW to do something - but, rather, I
just need some advise on what "technology" or method I should employ...
The problem is this:
I have a client for whom I am developing a web site. The client is a bank -
therefore, the entire site will be secure (SSL).
The banks' customers will be entering account number information to the
site - and we will be storing all inputs into a SQL Server database. The SQL
Server database resides on one of OUR servers.
The bank client then wants to periodically download, on demand, the
information that its customers have entered. (And the bank wants to download
the information entered in Excel spreadsheet format.)
I need to determine how I am going to get the entered information from our
ASP.NET server to our SQL Server database in a format that will be
unreadable to us (me, my company).
Likewise, I need to make the information available to the bank to download
in a format that they CAN read.
Where do I start'
I am an experienced, MCSD.NET certified developer - and I can implement
anything.
I just need to know where to begin.
Many thanks for your assistance!
~ Celia ~?
I am an experienced, MCSD.NET certified developer - and I can implement
anything.
"Celia Oblinger" <Oblinger@.comporium.net> wrote in message
news:b208a994.0401151834.259491a1@.posting.google.com...
quote:

> Please understand that I am not asking HOW to do something - but, rather,

I
quote:

> just need some advise on what "technology" or method I should employ...
> The problem is this:
> I have a client for whom I am developing a web site. The client is a

bank -
quote:

> therefore, the entire site will be secure (SSL).
> The banks' customers will be entering account number information to the
> site - and we will be storing all inputs into a SQL Server database. The

SQL
quote:

> Server database resides on one of OUR servers.
> The bank client then wants to periodically download, on demand, the
> information that its customers have entered. (And the bank wants to

download
quote:

> the information entered in Excel spreadsheet format.)
> I need to determine how I am going to get the entered information from our
> ASP.NET server to our SQL Server database in a format that will be
> unreadable to us (me, my company).
> Likewise, I need to make the information available to the bank to download
> in a format that they CAN read.
> Where do I start'
> I am an experienced, MCSD.NET certified developer - and I can implement
> anything.
> I just need to know where to begin.
> Many thanks for your assistance!
> ~ Celia ~
|||You could create a SQL DTS package that would extract the data from SQL and
put it into a new Excel Spreadsheet on demand.
Take a look at some examples out on http://sqldts.com
Then just use SSL between IIS and SQL to protect the data. The data will
not however be encrypted in SQL. You'll need to use third party tools to
do this.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.sql

Need Direction in WHAT to Implement...

Please understand that I am not asking HOW to do something - but, rather, I
just need some advise on what "technology" or method I should employ...
The problem is this:
I have a client for whom I am developing a web site. The client is a bank -
therefore, the entire site will be secure (SSL).
The banks' customers will be entering account number information to the
site - and we will be storing all inputs into a SQL Server database. The SQL
Server database resides on one of OUR servers.
The bank client then wants to periodically download, on demand, the
information that its customers have entered. (And the bank wants to download
the information entered in Excel spreadsheet format.)
I need to determine how I am going to get the entered information from our
ASP.NET server to our SQL Server database in a format that will be
unreadable to us (me, my company).
Likewise, I need to make the information available to the bank to download
in a format that they CAN read.
Where do I start'
I am an experienced, MCSD.NET certified developer - and I can implement
anything.
I just need to know where to begin.
Many thanks for your assistance!
~ Celia ~Celia,
One thought I have on this issue is to ensure the data stored in the SQL
Database is encrypted using a strong encryption package. There are several
good third party applications that can accomplish this objective for you.
The trick then is to control where and how the data can be displayed in an
unencrypted format. If the data is encrypted in the data files, the data
is not compromised even if someone obtains a copy of the mdf and ldf files.
Control of the decryption key is crucial.
Hopefully this information will get you started on the project.
Thanks.
Gary Whitley
This posting is provided "AS IS" with no warranties, and confers no rights.

Monday, February 20, 2012

Near Real time updating of fact table

-what is the best method that to implement the near real time updating of a
fact table without affecting all those users who are reading from it?
-fact table in question is only 1.8gb in size, 3.1 million rows, expect near
real time updating of approx 1000 new fact table records every 15 min,
occassionaly updates of historical (modified) fact table records - this is
where i assume write locks v read lock conflict may occur
- i am only concerned for the crystal report users who are using the fact
table via sql views ie relational db, the cube at present can stay as write
an night and read during the day
- any help greatly appreciated
U can use DTS for this, keep in mind that DTS is version sensitive.
Message posted via http://www.sqlmonster.com
|||Can you please elaborate on DTS being version sensitive?
I am also trying to achieve this in my data warehouse environment and very
curious to find out how.
Thanks,
Jay
"Rakesh Doebe via droptable.com" wrote:

> U can use DTS for this, keep in mind that DTS is version sensitive.
> --
> Message posted via http://www.droptable.com
>
|||Can you please elaborate on DTS being version sensitive?
I am also trying to achieve this in my data warehouse environment.
Thanks,
Jay
"Rakesh Doebe via droptable.com" wrote:

> U can use DTS for this, keep in mind that DTS is version sensitive.
> --
> Message posted via http://www.droptable.com
>

Near Real time updating of fact table

-what is the best method that to implement the near real time updating of a
fact table without affecting all those users who are reading from it?
-fact table in question is only 1.8gb in size, 3.1 million rows, expect near
real time updating of approx 1000 new fact table records every 15 min,
occassionaly updates of historical (modified) fact table records - this is
where i assume write locks v read lock conflict may occur
- i am only concerned for the crystal report users who are using the fact
table via sql views ie relational db, the cube at present can stay as write
an night and read during the day
- any help greatly appreciatedU can use DTS for this, keep in mind that DTS is version sensitive.
Message posted via http://www.droptable.com|||Can you please elaborate on DTS being version sensitive?
I am also trying to achieve this in my data warehouse environment and very
curious to find out how.
Thanks,
Jay
"Rakesh Doebe via droptable.com" wrote:

> U can use DTS for this, keep in mind that DTS is version sensitive.
> --
> Message posted via http://www.droptable.com
>|||Can you please elaborate on DTS being version sensitive?
I am also trying to achieve this in my data warehouse environment.
Thanks,
Jay
"Rakesh Doebe via droptable.com" wrote:

> U can use DTS for this, keep in mind that DTS is version sensitive.
> --
> Message posted via http://www.droptable.com
>

Navigation not working after clicking once

We open reports in new window from an asp.net page..using rs.render method.
Recently we have new reports with graphs...when clicked on detail for graph
I have to open another report detail in a new window. I have created a
link(naviagtion URL property for textbox ) in the main graph report to open
the detail report link as
="javascript:void(document.open('/ReportViewer/ReportFrame.aspx?rptPath=REPORTPATH&args="
& REPORTPARAMETERES &
"','_blank','left=50,top=50,width=800,height=580,menubar=no,resizable=yes,scrollbars=Yes,status=yes,toolbar=0'))"
Issue 1 :
The link is working fine for the first time. When I click the link for the
first time...the new window opens fine with the detail report...but when i
close the new window(detail report) and click the link nothing happens,no
report open..why. Also if i keep the new window(of detail report) as is
without closing and then click on the link again in the graph report...one
more new window opens up with the detail report...
Why does the link not work when i close the new window and re-click the link
Issue 2 :
I am trying this...
The window we open the report in contains frames..and we open the report in
the lower frame...how can i get the new detail report to open in the same
frame.
I tried using '_self'...but with this the new detail report is open on the
main IE page where our actual application is been open.
Any suggestions to get it working as I wish it tooo...would help.
Thanks.
SKI am still stuck on this...
I am doubting this is some kind of setting issue or what
I changed the URL link to simple
= "javascript:void(window.open('http://www.google.com','_blank'))"
even this ...when i open it for the first time it works fine...but when i
close the new window the link does not work anymore...
fyi : we are deploying the reports in PDF format...any issue with adobe !!!
I get a security warning saying document is trying to open a link...but
nothing opens after the firsttime '
any ideas....
"Sunny" wrote:
> We open reports in new window from an asp.net page..using rs.render method.
> Recently we have new reports with graphs...when clicked on detail for graph
> I have to open another report detail in a new window. I have created a
> link(naviagtion URL property for textbox ) in the main graph report to open
> the detail report link as
> ="javascript:void(document.open('/ReportViewer/ReportFrame.aspx?rptPath=REPORTPATH&args="
> & REPORTPARAMETERES &
> "','_blank','left=50,top=50,width=800,height=580,menubar=no,resizable=yes,scrollbars=Yes,status=yes,toolbar=0'))"
> Issue 1 :
> The link is working fine for the first time. When I click the link for the
> first time...the new window opens fine with the detail report...but when i
> close the new window(detail report) and click the link nothing happens,no
> report open..why. Also if i keep the new window(of detail report) as is
> without closing and then click on the link again in the graph report...one
> more new window opens up with the detail report...
> Why does the link not work when i close the new window and re-click the link
> Issue 2 :
> I am trying this...
> The window we open the report in contains frames..and we open the report in
> the lower frame...how can i get the new detail report to open in the same
> frame.
> I tried using '_self'...but with this the new detail report is open on the
> main IE page where our actual application is been open.
> Any suggestions to get it working as I wish it tooo...would help.
> Thanks.
> SK|||On Mar 28, 2:02 am, Sunny <S...@.discussions.microsoft.com> wrote:
> I am still stuck on this...
> I am doubting this is some kind of setting issue or what
> I changed the URL link to simple
> = "javascript:void(window.open('http://www.google.com','_blank'))"
> even this ...when i open it for the first time it works fine...but when i
> close the new window the link does not work anymore...
> fyi : we are deploying the reports in PDF format...any issue with adobe !!!
> I get a security warning saying document is trying to open a link...but
> nothing opens after the firsttime '
> any ideas....
> "Sunny" wrote:
> > We open reports in new window from an asp.net page..using rs.render method.
> > Recently we have new reports with graphs...when clicked on detail for graph
> > I have to open another report detail in a new window. I have created a
> > link(naviagtion URL property for textbox ) in the main graph report to open
> > the detail report link as
> > ="javascript:void(document.open('/ReportViewer/ReportFrame.aspx?rptPath=REPORTPATH&args="
> > & REPORTPARAMETERES &
> > "','_blank','left=50,top=50,width=800,height=580,menubar=no,resizable=yes,scrollbars=Yes,status=yes,toolbar=0'))"
> > Issue 1 :
> > The link is working fine for the first time. When I click the link for the
> > first time...the new window opens fine with the detail report...but when i
> > close the new window(detail report) and click the link nothing happens,no
> > report open..why. Also if i keep the new window(of detail report) as is
> > without closing and then click on the link again in the graph report...one
> > more new window opens up with the detail report...
> > Why does the link not work when i close the new window and re-click the link
> > Issue 2 :
> > I am trying this...
> > The window we open the report in contains frames..and we open the report in
> > the lower frame...how can i get the new detail report to open in the same
> > frame.
> > I tried using '_self'...but with this the new detail report is open on the
> > main IE page where our actual application is been open.
> > Any suggestions to get it working as I wish it tooo...would help.
> > Thanks.
> > SK
It sounds kind-of-like your browser settings are not allowing pop-
ups.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks EMartinez for the reply...
But no I have tried that...by allowing any popups...
It seems really strange...I think it has something to do with adobe
reader...no idea what?
The link opens fine for the first time...the second time i click ..nothing
happens except i get the security errror from adobe reader saying the
document is trying to open the link bla bla. The link works fine when the
window opened the first time is kept open!Whyyyyy
"EMartinez" wrote:
> On Mar 28, 2:02 am, Sunny <S...@.discussions.microsoft.com> wrote:
> > I am still stuck on this...
> > I am doubting this is some kind of setting issue or what
> >
> > I changed the URL link to simple
> > = "javascript:void(window.open('http://www.google.com','_blank'))"
> >
> > even this ...when i open it for the first time it works fine...but when i
> > close the new window the link does not work anymore...
> >
> > fyi : we are deploying the reports in PDF format...any issue with adobe !!!
> > I get a security warning saying document is trying to open a link...but
> > nothing opens after the firsttime '
> >
> > any ideas....
> >
> > "Sunny" wrote:
> > > We open reports in new window from an asp.net page..using rs.render method.
> > > Recently we have new reports with graphs...when clicked on detail for graph
> > > I have to open another report detail in a new window. I have created a
> > > link(naviagtion URL property for textbox ) in the main graph report to open
> > > the detail report link as
> >
> > > ="javascript:void(document.open('/ReportViewer/ReportFrame.aspx?rptPath=REPORTPATH&args="
> > > & REPORTPARAMETERES &
> > > "','_blank','left=50,top=50,width=800,height=580,menubar=no,resizable=yes,scrollbars=Yes,status=yes,toolbar=0'))"
> >
> > > Issue 1 :
> >
> > > The link is working fine for the first time. When I click the link for the
> > > first time...the new window opens fine with the detail report...but when i
> > > close the new window(detail report) and click the link nothing happens,no
> > > report open..why. Also if i keep the new window(of detail report) as is
> > > without closing and then click on the link again in the graph report...one
> > > more new window opens up with the detail report...
> > > Why does the link not work when i close the new window and re-click the link
> >
> > > Issue 2 :
> > > I am trying this...
> > > The window we open the report in contains frames..and we open the report in
> > > the lower frame...how can i get the new detail report to open in the same
> > > frame.
> > > I tried using '_self'...but with this the new detail report is open on the
> > > main IE page where our actual application is been open.
> >
> > > Any suggestions to get it working as I wish it tooo...would help.
> >
> > > Thanks.
> >
> > > SK
> It sounds kind-of-like your browser settings are not allowing pop-
> ups.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>