{"id":2355,"date":"2014-12-18T21:15:12","date_gmt":"2014-12-18T21:15:12","guid":{"rendered":"https:\/\/alt2.minisoft.com\/support\/?p=2355"},"modified":"2014-12-18T21:15:12","modified_gmt":"2014-12-18T21:15:12","slug":"using-impromptu-with-odbc","status":"publish","type":"post","link":"https:\/\/c002.minisoft.com\/support\/using-impromptu-with-odbc\/","title":{"rendered":"Using Impromptu with ODBC"},"content":{"rendered":"

\n

Getting Started<\/p>\n

    \n
      \n
    1. Create a New Catalog, enter a file name and select Databases:<\/li>\n<\/ol>\n<\/ol>\n

      \"ODBC_j01\"<\/p>\n

        \n
          \n
        1. Select Add:<\/li>\n<\/ol>\n<\/ol>\n

          \"ODBC_j02\"<\/p>\n

            \n
              \n
            1. Enter a name for the database, select ODBC Gateway, find and select the ODBC data source<\/span> you created earlier,deselect User ID, and click OK:<\/li>\n<\/ol>\n<\/ol>\n

              \"cognos3\"<\/p>\n

                \n
                  \n
                1. The Database Name should now be correct. Click OK:<\/li>\n<\/ol>\n<\/ol>\n

                  \"ODBC_j04\"<\/p>\n

                    \n
                      \n
                    1. Select and add a table, then click OK:<\/li>\n<\/ol>\n<\/ol>\n

                      \"ODBC_j06\"<\/p>\n

                        \n
                          \n
                        1. \u00a0Select Cancel from the Joins dialog box:<\/li>\n<\/ol>\n<\/ol>\n

                          \"ODBC_j07\"<\/p>\n

                            \n
                              \n
                            1. Select New on the Toolbar to start the Report Wizard and click Next:<\/li>\n<\/ol>\n<\/ol>\n

                              \"ODBC_j08\"<\/p>\n

                                \n
                                  \n
                                1. \u00a0Double click the table name, select and add the fields, click Finish:<\/li>\n<\/ol>\n<\/ol>\n

                                  \"ODBC_j09\"<\/p>\n

                                    \n
                                      \n
                                    1. \u00a0Data from the dataset will appear:<\/li>\n<\/ol>\n<\/ol>\n

                                      \"ODBC_j10\"<\/p>\n","protected":false},"excerpt":{"rendered":"

                                      Getting Started Create a New Catalog, enter a file name and select Databases: Select Add: Enter a name for the database, select ODBC Gateway, find and select the ODBC data source you created earlier,deselect User ID, and click OK: The Database Name should now be correct. Click OK: Select and add a table, then click […]<\/p>\n","protected":false},"author":75,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[54,63],"tags":[],"_links":{"self":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/2355"}],"collection":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/users\/75"}],"replies":[{"embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/comments?post=2355"}],"version-history":[{"count":1,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/2355\/revisions"}],"predecessor-version":[{"id":2365,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/2355\/revisions\/2365"}],"wp:attachment":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/media?parent=2355"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/categories?post=2355"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/tags?post=2355"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}