I am looking for advice on giving my non-technical users the ability to create their own reports. For example, a user may want to include client name, phone number and address but not social security number. But anothe user may need all 4 fields. I would like a tool that allows my users to drag and drop fields ultimately making an ad-hoc report. This is a very simplified example and our data goes across many tables. So I would need the ability to give them the field data based upon complicated SQL views that IT writes but the user just needs to drag and drop what they need.
Does anyone know / use a product that does this? No sophisticated graphs or anything is needed. Just simple columns of data that can be brought into excel for further manipulation.
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed.
Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.