Home | Downloads | Support | About GGY | About AXIS
Article Title: Communicating with external systems in AXIS
Article Type: General System  
Article ID #: 358
GGY Contacts: GGY Client Support (416-250-6777)
Last Modified: 12 Dec 13

Article Summary:

The following summarizes many different means of communicating with external systems in AXIS

(Click here for printable version)

Article Detail:

Imports

 

Seriatim Inforce file

 

Format:
  • Fixed-width ASCII file (each records contains fields with fixed position, length and format)
  • Delimited (e.g. comma-delimited CSV) text file 
  • CodeBase (DBF) table
  • Microsoft SQL Server database
  • Any ODBC compliant source using Collect Records from a Remote Table
Method of import: User defines a file layout or mapping between external database table structure and tables in a dataset and performs loading to AXIS DataLink table.
Drivers/software: No additional software/drivers needed for ASCII files. ODBC driver required for other sources. AXIS DataLink license is required
Manual/Batch process Yes/Yes
Additional information: 34155, 34129

 

Assumptions

Table values

Scenarios

 

Format:
  • MS Excel 95-2013,
  • ASCII comma-delimited or fixed width,
  • FoxPro (DBF), MS Access table,
  • CodeBase (DBF) table,
  • Microsoft SQL Server database
  • Any ODBC compliant source using Collect Records from a Remote Table
  • SOA Standard Format Tables (Table Manager database).

Certain structure (set of mandatory columns) is required for each type of the information

Methods of import: Method 1:The source file is read into AXIS Import/Export database, then imported into AXIS

Method 2: Assumptions and Table values can be loaded into AXIS DataLink table and then sent to AXIS

Method 3: Table values can be imported from SOA Standard Format Tables

Drivers/software: For method 1: DAO ISAM drivers (part of standard AXIS libraries installation) , ODBC drivers needed for ODBC sources,

For method 2: No additional software/drivers needed for text files, ODBC drivers needed for ODBC sources, AXIS DataLink license is required

For method 3: No additional software/drivers needed.

Manual/Batch process Yes/Yes
Additional information: KB#84, 34189, 30545

Exports

 

 

Assumptions

Table values

Results: All Vendor supplied and User defined (custom) Reports

Query results

System logs

 

Format:
  • MS Excel 95-2013,
  • WK3 Lotus spreadsheet,
  • ASCII comma-delimited or fixed width file, 
  • FoxPro (DBF), 
  • CodeBase (DBF) table,
  • MS Access database ,
  • MS SQL Server
  • Adobe PDF
Methods of export:

Method 1: Export to AXIS Import/Export database from a variety of manual and batch options. Then export to external files of the above formats.

Import/Export database can also be located directly on MS SQL Server.

Method 2: Direct export to Excel or text files from almost every grid based screen in interactive mode and certain batch jobs.

Method 3: Query results can be sent to Import/Export database or directly to Excel/Text file

Method 4: Export to Adobe PDF format files for various reports and screens. Interactively (File/Send To File/Send To PDF...menu) or in batch.

Drivers/software: For method 1: DAO ISAM drivers (part of standard AXIS libraries installation). OLE DB provider (Native client) for MS SQL Server. CodeBase SQL ODBC driver for exports to CodeBase format.

For method 2: MS Excel installed for "Send to Excel" options if using Excel Automation, otherwise no Excel is required (built-in read-write engine for Excel format provided in AXIS) 

For method 3: No additional software/drivers needed.

For method 4: Optional PDF driver required (included as part of AXIS Libraries package)

Manual/Batch process Yes/Yes
Additional information: 34189, 34166, 34160

Other means of communicating with external systems

- Standard Windows Clipboard Copy/Paste functionality is available from all table editors as well as grid views

- Comma-delimited files can be automatically converted to fixed-width for seriatim inforce loading by using built in batch job.

- AXIS DataLink/System Log and certain other  reports can be saved as HTML files for future viewing or use in other systems


Contact | Client  Login / File Upload | Terms of Use | Email GGY   Search