Establishing a Connection
Connecting with the Alfresco Connection Manager
Adding a new Alfresco connection to the SSIS package is straightforward. Right-click within the Connection Manager window and select New Connection from the menu. Then, choose the Alfresco Connection Manager from the Add SSIS Connection Manager window.
Alternatively, you can create a new connection directly using the Alfresco Source or the Alfresco Destination. You can set the connection properties in the Alfresco Connection Manager window.
Authenticating to Alfresco
To connect to Alfresco, the following connection properties must be supplied: User, Password, and InstanceURL. User and Password should correspond to the login credentials that you use to access Alfresco in a web browser. InstanceURL corresponds to the Alfresco instance you will be querying. For instance, if you expect your queries to hit https://search-demo.dev.alfresco.me/alfresco/api/-default-/public/search/versions/1/sql, you should supply search-demo.dev.alfresco.me for InstanceURL.