Scribe GP Adapter Table Access
Posted by Bill Goulette on Mon, Mar 01, 2010
As part of our integration practice, we end up creating integrations that are well outside the functionality of templates offered by the integration software provider. In particular, there are times where the tables involved in the integration need special inclusion in the security model that informs the integration module.
Each integration software has different methods for providing object access to the integration tool. In Scirbe Insight's case, when it comes to Dynamics GP, the list of SQL objects that can be accessed by their tool is contained in a table called KSYNCTABLEBASE located in the company database (not to be confused with the DYNAMICS database).
It is likely that part of your design document includes identification of the objects that are being integrated between the systems. You can check to see if the tables included in your integration design are accessible by reviewing the results of the following query against the company database:
select * from KSYNCTABLESBASE
Note - of course, you must have Scribe Insight and the Scribe GP Adapter installed for this table to exist there.
If the table you are looking for is not found there, you may add it using the following query and substituting the 'PA00401' value with whatever table you need to access with the Scribe Workbench:
INSERT INTO KSYNCTABLESBASE
( TABLENAME, OWNER, SUBJECT_AREA, LABEL, TYPE, UPDATABLE, HIDDEN, DRS_OBJECT, BASE_TABLES, REMARKS, FIELD_INFO )
VALUES
( 'PA00401', 'dbo', 'Additional Integration Objects', null, 'U', 'Y', 'N', null, null, 'Table used for additional information', null)
Happy integrating.