Graphs and Gauges for All Data Sources

Data Access component provides an interface to carry out database operations. It connects to the database using any type of JDBC driver to retrieve and manipulate data. Data Access component gets you the power of being able to read, write, and edit data stored in any data source, be it text, database, or XML file/stream. With Data Access component, you will be able to connect and communicate with any type of data source through protocols like FILE, JDBC, FTP or HTTP. It works in the most of the security and access constraints imposed by different architectures and enables you to access your any type of data from HTTP servers, FTP servers, LAN, Internet, and File servers.

Text Data Access

• Can parse data with fixed column size or with delimiter. Also parses data by user defined text qualifier
• Provides facility to configure fetch size to fetch records
• Configurable character delimiter for rows and columns
• Option to append or replace fetched data in existing client buffer
• Provides an option to consider the first line as column header
• Column names can be retrieved and stored in data access component

Please refer Programmers’ guide for further information.

SQL Data Access

• Supports all the four types of JDBC Connections
• Configurable connection attributes viz., database URL, driver, username, and password
• Allows configuring SQL query string. Facilitates users to specify parameters in SQL query in the form of retrieval arguments Value of parameters can be set at run time
• Allows including columns as criteria. Specify options viz. unique columns, unique and updateable columns, and unique and modified columns
• Option to restrict data updating to specific columns as well as tables
• Configurable fetch size to fetch records
• Option to append or replace fetched data in existing client buffer

Please refer Programmers’ guide for further information.

Data Access Through HTTP

• Makes use of common methods - GET, POST, and HEAD methods for data exchange
• Sends file as well as string buffer to HTTP server as an entity
• Can parse data with fixed column size or with delimiter
• Configurable fetch size to fetch records
• Option to append or replace fetched data in existing client buffer
• Option to consider the first line as column header
• You can retrieve and store column names in data Access Component

Please refer Programmers’ guide for further information.

Data Access Through FTP

• Connects to any FTP server
• Can parse data with fixed column size or with delimiter
• Configurable fetch size to fetch records
• Option to append or replace fetched data in existing client buffer
• Configurable character delimiter for rows and columns
• Option to configure first line as column header
• Column names can be retrieved and stored in Data Access Component

Please refer Programmers’ guide for further information.

XML Data Access

• Can parse an XML file by user-defined tags (identifiers of root, row, and column)
• Provides an option to consider the first line as column header
• Column names can be retrieved and stored in data access component