Access a database

From DISE KnowledgeBase

Jump to: navigation, search
  1. Start the DISE Parser.
  2. Select File > Import.
  3. Go to the Samples directory and select the ODBC.dpmodifiers file.
  4. Right click on the Database access modifier and select Settings.
  5. Click on the Edit button and configure your DSN (Database Source Name).
  6. Write a SQL Query in the Statement box.
  7. Click Ok.
  8. Click Test.
  9. Take a look at the output file, located in your "Public\Documents\DISE Parser" folder in a file called "odbc_output.txt".

The processing will use a XSL file called db.xsl that will just convert all the rows in the ODBC database into lines of text. You can open that file to do some changes on how the output should be.