How to use Data Connector to import data into the Symantec Management Platform database

Article:HOWTO79380  |  Created: 2012-08-28  |  Updated: 2014-05-21  |  Article URL http://www.symantec.com/docs/HOWTO79380
Article Type
How To



This white paper article provides general information and best practices on how to use Data Connector to import data into the Symantec Management Platform database (Symantec_CMDB). (Data Connector can also export data out of the Symantec Management Platform database, however, this is not discussed in this article.) For more information on how to use Data Connector, refer to its user guide:

Symantec IT Management Suite 7.5 powered by Altiris technology Administration Guide
http://www.symantec.com/business/support/index?page=content&id=DOC5330

Symantec Management Platform 7.1 SP2 User Guide
http://www.symantec.com/business/support/index?page=content&id=DOC4730

Part 1: The user's data.

The user provides their own data that they want to import into Altiris. This includes any data classes and associations that they want to populate for the specific resource type.
 
Data can be saved to a .CSV formatted text file, to an Excel spreadsheet or be in a database. (There are several other data format types that can be used, such as .XML, however, these are not discussed in this article). An example .CSV formatted text file may look like the following:

Name, Serial Number, Location
PC1, 111A, Los Angeles
PC2, 222B, New York City

Row one includes column names which are not processed as data. Row two is the first record, computer PC1, with its serial number data class of 111A and its location association of Los Angeles. Row three is the second record, PC2, with its serial number data class of 222B, and its location association of New York City.

Note: It is recommended to use column names when using a data file. This makes it easier to configure data classes and associations in the import rule, and if the column name matches the data class name, these will then automatically be configured.

Part 2: Create a Data Connector data source.

After the user has their data ready in a file or a database from Part 1, a Data Connector data source needs to be created to access it. Refer to the following articles to create and configure the data source, depending on the data format used from Part 1:

How to create a Data Connector data source that accesses data in a .CSV formatted text file
http://www.symantec.com/business/support/index?page=content&id=HOWTO95481

How to create a Data Connector data source that accesses data in an Excel spreadsheet through OLEDB
http://www.symantec.com/business/support/index?page=content&id=HOWTO95482

How to create a Data Connector data source that accesses data in a database through OLEDB
http://www.symantec.com/business/support/index?page=content&id=HOWTO94484

How to create a Data Connector data source that accesses data in a Microsoft SQL Server database through an ODBC System DSN
http://www.symantec.com/business/support/index?page=content&id=HOWTO95495

Part 3: Create a Data Connector import rule.

Create a Data Connector import rule to use the data source from Part 2. The user then configures any data classes or associations that they want to populate for the specific resource type. Refer to the following article to create and configure the import rule:

How to create a Data connector import rule that creates or updates resources
http://www.symantec.com/business/support/index?page=content&id=HOWTO95489

Related Articles

How to troubleshoot import issues when using a Data Connector Import Rule
http://www.symantec.com/business/support/index?page=content&id=TECH195835

How to import Software Purchases and Software Licenses using a Data Connector Import Rule
http://www.symantec.com/business/support/index?page=content&id=HOWTO79379

How to import CMDB Solution departments and locations from Active Directory using a Data Connector import rule
http://www.symantec.com/business/support/index?page=content&id=HOWTO59218

How to create a Data Connector import rule to assign a user's department or location
http://www.symantec.com/business/support/index?page=content&id=HOWTO64259

How to create a Data Connector Import Rule to migrate data from an old Notification Server to Symantec Management Platform 7.x
http://www.symantec.com/business/support/index?page=content&id=HOWTO77183




Article URL http://www.symantec.com/docs/HOWTO79380


Terms of use for this information are found in Legal Notices