Discover how a bimodal integration strategy can address the major data management challenges facing your organization today.
Get the Report →Connect to Act-On from Asprova with CData ODBC Driver for Act-On
This article shows how to connect faster to Act-On data from Asprova.
The CData ODBC Driver for Act-On enables you to access Act-On data from Asprova. In this article, you will import Act-On data into item data in Asprova as an example.
Asprova setting
-
Click File -> Data I/O Settings.
-
Double click the header of Item and open the Edit I/O dialog.
-
Select "No" from the RDB transaction combo box and close the dialog.
Data driver setting
-
Select "OLE DB" from combo box in "Data source" column.
-
Click button in Folder/database column and open the Data Link Property dialog. Select "Microsoft OLE DB Provider for ODBC Drivers" from the list of data provider.
-
Select the Connection tab. Check "Use data source name" and select "CData Act-On Source" from DSN combo box.
-
Click the Test Connection button and make sure you see the message "Connection successful".
Schema setting
-
Click the button in "External table name" column and open the Table List dialog. Make sure tables in Act-On are listed in the dialog.
-
Click the button in "Field mapping" column and open the Item-Field Mapping dialog.
-
Open the context menu in the space between tables and click Delete All. Link corresponding fields by dragging mouse.
-
Click File > Import and data will be imported into Asprova.
Check data
Click Table View > Item. Be sure you can see the item data stored in Act-On.