International AC: An Education Case on Continuous Monitoring SQL Server Data with ODBC-Linked Tables in Microsoft Access

2016 ◽  
Vol 13 (2) ◽  
pp. 195-213
Author(s):  
Sherwood Lane Lambert ◽  
Jon Holladay ◽  
Dawna M. Drum
Keyword(s):  
Faculty Member ◽  
Continuous Monitoring ◽  
Sql Server ◽  
Continuous Auditing ◽  
Microsoft Access ◽  
Database Administrator ◽  
Open Database Connectivity ◽  
Database Connectivity ◽  
Random Times

ABSTRACT This education case teaches students Continuous Auditing/Continuous Monitoring (CA/CM) using Open Database Connectivity (ODBC) connections from students' Microsoft Access (Access) to tables in Microsoft SQL Server (SQL Server). First, the institution's database administrator (DBA) imports the student tables provided with the Teaching Notes into the institution's SQL Server with read-only access. In Access, students create ODBC connections to the SQL Server student tables. Then, students create Access queries using the ODBC-linked tables to monitor for anomalies. During a scheduled week, the DBA, in coordination with the faculty member, enters anomalies in the SQL Server student tables at random times, and students run their Access queries to identify the anomalies.

Accessing Data From Multiple Heterogeneous Distributed Database Systems

2019 ◽  
pp. 192-219
Author(s):  
Shefali Trushit Naik
Keyword(s):  
System Parameter ◽  
Database Systems ◽  
Distributed Database ◽  
Sql Server ◽  
Distributed Database Systems ◽  
Data Source ◽  
Database Connectivity ◽  
Relational Database Management ◽  
Complete Process ◽  
Relational Database Management Systems

This chapter describes the method to retrieve data from multiple heterogeneous distributed relational database management systems such as MySQL, PostgreSQL, MS SQL Server, MS Access, etc. into Oracle RDBMS using Oracle's Heterogeneous Gateway Services. The complete process starting from downloading and installation of required software, creation of data source names using open database connectivity, modification of system parameter files, checking connections, creation of synonyms for tables of remote databases into oracle, creation of database links and accessing data from non-oracle databases using database links is explained in great detail. Apart from this, data manipulation in remote databases from Oracle and execution of PL/SQL procedures to manipulate data residing on remote databases is discussed with examples. Troubleshooting common errors during this process is also discussed.

scholarly journals XBRL een katalysator voor continuous auditing?

2008 ◽  
Vol 82 (7/8) ◽  
pp. 324-333
Author(s):  
M Mashale
Keyword(s):  
Continuous Monitoring ◽  
Continuous Auditing ◽  
In De Praktijk

XBRL en Continuous Auditing zijn twee onderwerpen die momenteel binnen het vakgebied auditing in de schijnwerpers staan. Ontwikkelingen in fi nanciële markten en het bedrijfsleven, zoals de toenemende interesse voor en ontwikkeling van Continuous Monitoring en Continuous Reporting systemen, beïnvloeden de vraag naar assurancediensten en leiden tot het aan de kaak stellen van controlemethodieken die momenteel door externe auditors in de praktijk worden toegepast. De ontwikkelingen in de fi nanciële markten vragen om impactonderzoek door en een adequate respons vanuit de auditgemeenschap. Inspelend op deze veranderingen komt op dit moment binnen de auditgemeenschap onderzoek op gang naar de ontwikkeling van toepassingen van Continuous Auditing en naar factoren die de realisatie van deze toepassingen faciliteren. In dit kader wordt in dit onderzoek een aanzet gedaan tot een kwalitatieve verkenning van de relatie tussen de mogelijkheden tot datastandaardisatie van XBRL en de toepassing van Continuous Auditing. De relatie tussen XBRL en Continuous Auditing is momenteel, zowel op wetenschappelijk gebied als in het bedrijfsleven, een nog lang niet uitgekristalliseerd onderwerp. Er is – in concreto – weinig bekend over het effect van XBRL-implementatie op bestaande en toekomstige controlemethodieken. De voor dit onderzoek geïnterviewde en via literatuur geraadpleegde deskundigen delen de mening dat de mogelijkheden die XBRL biedt om fi nanciële data te standaardiseren, als katalysator optreden voor de implementatie van Continuous Auditing. Echter, datastandaardisatie is in dit implementatieproces slechts een puzzelstukje.

scholarly journals Akumulasi Data Dari Database Multi Sumber (Studi Kasus: Penilaian Angka Kredit Dosen Di UPN “Veteran” Jawa Timur)

2017 ◽  
Vol 12 (1) ◽  
pp. 7
Author(s):  
Intan Yuniar Purbasari ◽  
Henni Endah Wahanani
Keyword(s):  
Sql Server ◽  
Microsoft Access ◽  
Ruby On Rails

Jabatan akademik dosen adalah sebuah karir dan jugamerupakan pengakuan kemampuan seorang dosen dalam menjalankan Tridharma Perguruan Tinggi. Untukdapat memperolehnya, setiap dosen harus menjalani serangkaian penilaian kredit poin (Penilaian Angka Kredit-PAK) sesuai dengan aturan yang telah ditetapkan oleh pemerintah melalui Direktoral Jenderal Pendidikan Tinggi, yang sekarang berada di bawah Kementerian Riset, Teknologi, dan Pendidikan Tinggi. Dosen yang dinilai harus mengisi sejumlah dokumen yang mendata kegiatan tridharma-nya selama setidaknya empat tahun ke belakang. Selain itu, setiap semester mereka juga diharuskan mengisi dokumen serupa dalam bentuk laporan Beban Kerja Dosen (BKD), berbasis Microsoft Access. Di sisi lain, UPN “Veteran” Jawa Timur juga telah mencatat data-data pribadi, pendidikan, dan sejarah akademissemua pegawainya dalam sistem informasi internal SIMPEG (Sistem Informasi Manajemen Pegawai, berbasis Borland Delphi) dan juga SIDOS (Sistem Informasi Dosen, berbasis Microsoft SQL Server) yang juga harus diisi dan rutin diupdate oleh tiap pegawai/dosen. Pada dasarnya data di ketiga sistem informasi tersebut adalah serupa dan dapat digunakan dalam proses PAK untuk menjaga konsistensi dan validitas data. Penelitian ini bertujuan untuk mengumpulkan data dari sistem BKD dan SIMPEG dan mengintegrasikannya untuk membuat model aplikasi berbasis web untuk PAK. Terdapat total 76 data dosen dari 3 semester laporan BKD yang digunakan dalam penelitian ini. Tabel dari SIDOS digunakan sebagai template untuk desain tabel di database yang baru dibuat di sistem ini yang menggunakan framework Ruby on Rails. Sebuah rintisan aplikasi web telah dibuat untuk menampilkan data yang telah dikumpulkan dan dapat dikustomisasi untuk menampilkan informasi yang berkaitan dengan kegiatan tridharma seorang dosen tertentu.

Continuous Auditing and Continuous Monitoring in ERP Environments: Case Studies of Application Implementations

2013 ◽  
Vol 28 (1) ◽  
pp. 287-310 ◽  
Author(s):  
Kishore Singh ◽  
Peter J. Best ◽  
Mario Bojilov ◽  
Catherine Blunt
Keyword(s):  
Empirical Evidence ◽  
Computer Technology ◽  
Continuous Monitoring ◽  
Business Processes ◽  
Level Of Detail ◽  
Continuous Auditing ◽  
Modern Computer ◽  
Growing Body ◽  
Computer Based ◽  
Time Basis

ABSTRACT The need for continuous auditing and continuous monitoring (CA/CM) has increased in the global digital economy. Modern computer-based systems make it possible to measure and monitor business processes at an unprecedented level of detail in a real- or near real-time basis. This empowers auditors to become increasingly dependent on computer technology and software tools. While there is a growing body of literature related to this domain, there is a need for empirical evidence from actual implementations that document these systems in detail. In this research, we perform such an investigation on three CA/CM systems, namely SAPSECURE, CAMAP, and Bagheera-S™.

Developing Database Query Proficiency: Assuring Compliance for Responses to Web Site Referrals

2001 ◽  
Vol 15 (1) ◽  
pp. 35-56 ◽  
Author(s):  
A. Faye Borthick ◽  
Donald R. Jones ◽  
Ryan Kim
Keyword(s):  
Web Site ◽  
Continuous Monitoring ◽  
The Other ◽  
Business Relationships ◽  
Database Query ◽  
Database Queries ◽  
Microsoft Access ◽  
New Business ◽  
Trading Partners

This case illustrates how database queries can be used to provide continuous assurance in a situation where two trading partners want assurance of the other's compliance with their agreements. In this two-sided assurance situation, a car maker wants assurance that its dealers make timely responses to web site customers and the dealers want assurance that the car maker is sending them all the designated customer referrals. The queries, developed in Microsoft Access®, illustrate the kind of queries that accountants could prepare to perform continuous monitoring of business activities. In this situation, referrals not in compliance with the agreements might be sent automatically to car maker and dealer managements. Query-based approaches to continuous assurance are likely to become more common as trading partners devise new business relationships and want assurance that the other party is abiding by their mutual agreements.

Sign in / Sign up

Export Citation Format

Share Document