Knowledge is the gold of nowadays
Enjoy and share valuable information to make better solutions
How to: Connect 1C:Enterprise with Onlizer
1C:Enterprise is a line of accounting, business and CRM applications most popular in the CIS region. But the integration of this system may be very tricky. This "How-to" article describing how to set up and connect 1C account with Onlizer to simplify further integration and automation.
Configure access to 1C via OData interface
This tutorial cover scenario when 1C server and web-server is hosted on Windows-driven machine. If you need information about how to set up Linux-driven servers please contact us team@onlizer.com
-
Set up web-server
To publish OData interface web-server will be required so you need to setup it
Installing IIS 7 on Windows Server 2008 or Windows Server 2008 R2
Installing IIS 8 on Windows Server 2012
After installation, additional settings are required for the Default App Pool. For this:
-
Run IIS Manager using Win+R and "inetmgr" command or from Start menu > Windows Administrative Tools > Internet Information Services (IIS) Manager
-
Select in the IIS Manager pool and the Advanced Settings item on the left
-
Set Enable 32-bit applications option to True
-
It is also necessary to specify the user in the Identity settings. This user account must have access rights to the location of the installation of the 1C's database / server and the directory where the OData interface will be published
-
After saving the settings, restart (Recycle) the App Pool
-
- Publish a standard OData interface to a web server
Starting from version 8.3.5, 1C:Enterprise platform can automatically generate REST interface for the entire application. For each configuration object (catalog, document, information register, etc.) you can allow modification based on data obtained via REST interface. The platform uses version 3.0 of OData as its access protocol.
To publish OData services, in Designer, on the Administration menu, click Publish to web server and select the Publish standard OData interface check box. Atom/XML and JSON formats are supported. After the application is published to a web server, third-party systems can access it via the REST interface using HTTP requests. Programming on the side of the 1C:Enterprise application is not required for working with the 1C:Enterprise application via OData protocol.
Thus, the URL of the type http://<server>/<configuration>/odata/standard.odata/Catalog_Products will return the contents of the Products catalog in XML format - a collection of entry elements
- Set up Onizer Connect integration
To get started, let's go to Onlizer Portal. To do this, enter "portal.onlizer.com" in the browser's address line or use the quick link. Log in into portal using your email or username and password.
Now we need to add your 1C account to Onlizer. For this go to the "Connection Hub" section in the Navigation menu (left side of the screen).
This section contains a list of all of your third-party services connected to Onlizer. Do not worry if you have an empty list at the moment, soon the names of your services will appear here. To add a new service, click on the "Add new service connection" link.
Now you will be redirected to Onlizer Connect portal and a list of services will appear. You can connect any of them to your project and use them in your business logic. The list contains a batch of services and we constantly update it. Find tile with 1C:Enterprise icon and title and click it.
Specify 1C's OData endpoint in format http://<host>/<configuration>/odata/standard.odata/, login and password for 1C's user account. Then click "Connect"
After a successful connection established, you will be redirected to Connections Hub page and newly created 1C connection will be shown there.