ITPub博客

首页 > 数据库 > 数据库开发技术 > How to use CSV or Text files as datasource for ReportNet (CRN) or Cognos 8 via ODBC

How to use CSV or Text files as datasource for ReportNet (CRN) or Cognos 8 via ODBC

原创 数据库开发技术 作者:liang573728 时间:2019-06-13 17:39:07 0 删除 编辑
Problem(Abstract)
How to use CSV or Text files as datasource for ReportNet (CRN) or Cognos 8 via ODBC
[@more@]
Resolving the problem
Make an ODBC connection in Windows via the Microsoft Text Driver, to a CSV or TXT file. Add the connection to CRN, and set up a Model to connect to the same datasource. Steps:Steps to create a new data source using Microsoft Text Driver ODBC connection:

  1. Launch ODBC (Start => All Programs => Administrative Tools => Data Sources (ODBC)
  2. Select the "System DSN" tab, so that the connection is available to everyone.
  3. Select "Add"
  4. From the "Create a new data source" window, select "Microsoft Text Driver (*.csv, *.txt) and click "Finish".
  5. In the ODBC Text setup window, provide a name for the data source (eg. Test).
  6. Clear the check box for "Use current directory" and click on "Select Directory".
  7. Provide the file name of the "xx.csv" or "xx.txt" source and navigate to the location folder and click OK. The new data source name should be visible and available in the "System data sources" window.
  8. Click OK to close the Data Source Administration window.

Note: If the connection is being made to a network shared directory, select "none" instead of a mapped drive letter and specify a UNC path to the shared folder where the .txt or .csv file resides.

To reconfigure the datasource, select it in the ODBC Datasource Administration => Configure selection.

Two files are attached for convenience based on the National sample, a .csv and a .txt file.

ref :http://www-01.ibm.com/support/docview.wss?uid=swg21343873

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/640706/viewspace-1036198/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2005-10-15

  • 博文量
    152
  • 访问量
    112961