1 / 14

Accessing an ODBC Database

Accessing an ODBC Database. External Data ODBC Command. From ACL Project Screen use External Data ODBC Command. Select Server. The ODBC interface lists the databases available to this project. Clear Security.

bernad
Download Presentation

Accessing an ODBC Database

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Accessing an ODBC Database

  2. External Data ODBC Command From ACL Project Screen use External Data ODBC Command

  3. Select Server The ODBC interface lists the databases available to this project.

  4. Clear Security The files are password protected. The Internal Audit ID only has write access so we cannot accidentally screw up a file.

  5. Select Table or View We will use a view developed by Information Systems for Internal Audit. ACL could connect multiple files and Internal Audit could achieve the same result with more independence but more cost.

  6. Select Check File Fields The ACL ODBC interface automatically identifies and formats the fields. If a large file is involved fields can be excluded.

  7. Save File

  8. File Layout

  9. Summarize by Day Check Register produce totals by daily check run and by payment method. The check file is sorted and footed accordingly.

  10. Select or Filter Manageable Data The datafiles can be very large so we normally use a filter to obtain an efficient files size.

  11. Place Results in File

  12. Command Execution

  13. Final ACL Control Totals Totals by day agreed to check register. Example is 11/30/07.

  14. Check Register Bank Account Number Amounts and Record Counts Agreed to ACL Report for Day in Question

More Related