Import and export data

The import commands let you import data from a variety of different data sources.

Depending on the data source, you also define the source data as part of importing it. Defining data means specifying attributes such as field names, field lengths, and field data type.

The export command lets you export data to a variety of different file formats, or to Results in HighBond.

Data access by Analytics is read-only

When connecting to any data source, or importing from any data source, Analytics is strictly read-only. Analytics cannot add, update, or delete data in a data source, or modify a data source in any way. This restriction applies to all data sources accessible by Analytics: file-based data sources, databases, and cloud data services.

Analytics data files (.fil) created from imported data are also treated as read-only by Analytics. Analytics cannot alter .fil files, with the exception of refreshing the file from the data source.

.fil files are completely separate from the data source used to create them. Deleting a .fil file has no effect on the data source.

Command descriptions

Command Description
ACCESSDATA

Imports data from a variety of ODBC-compliant data sources.

The command takes the form ACCESSDATA64 or ACCESSDATA32 depending on whether you are using a 64-bit or 32-bit ODBC driver.

DEFINE TABLE DB

Defines an Analytics server table by connecting to a database table using AX Connector. You can connect to a Microsoft SQL Server, Oracle, or DB2 database.

EXPORT

Exports data from Analytics to the specified file format, or to the Results app or the Robots app in HighBond.

IMPORT ACCESS

Creates an Analytics table by defining and importing a Microsoft Access database file.

IMPORT DELIMITED

Creates an Analytics table by defining and importing a delimited text file.

IMPORT EXCEL

Creates an Analytics table by defining and importing a Microsoft Excel worksheet or named range.

IMPORT GRCPROJECT

Creates an Analytics table by importing a HighBond Projects table.

IMPORT GRCRESULTS

Creates an Analytics table by importing a HighBond Results table or interpretation.

IMPORT MULTIDELIMITED

Creates multiple Analytics tables by defining and importing multiple delimited files.

IMPORT MULTIEXCEL

Creates multiple Analytics tables by defining and importing multiple Microsoft Excel worksheets or named ranges.

IMPORT ODBC

Creates an Analytics table by defining and importing data from an ODBC data source.

ODBC stands for Open Database Connectivity, a standard method for accessing databases.

IMPORT PDF

Creates an Analytics table by defining and importing an Adobe PDF file.

IMPORT PRINT

Creates an Analytics table by defining and importing a Print Image (Report) file.

IMPORT SAP

Creates an Analytics table by importing data from an SAP system using Direct Link.

IMPORT XBRL

Creates an Analytics table by defining and importing an XBRL file.

IMPORT XML

Creates an Analytics table by defining and importing an XML file.

RETRIEVE

Retrieves the result of a Direct Link query submitted for background processing.