Issue connecting Alteryx to 1C program database

Khalisaaliyeva

I am experiencing difficulty connecting Alteryx to my 1C program database. I have searched for a pre-built ODBC driver for Alteryx on the 1C Company website but have been unable to locate one. I have also tried searching for third-party drivers, but I am not sure which one is compatible with my version of 1C program and operating system.

Could you please provide guidance on how to connect Alteryx to my 1C program database? My version of Alteryx is 2022.3.1.395.

Additionally, I have checked the Data Source Administrator window and I cannot find the 1C ODBC driver when I click the Add button option. Is there something that I need to do in order to enable the driver?

Thank you for your help and assistance in advance!

ArtApa

Hi @Khalisaaliyeva  - The data that 1C:Enterprise uses on a constant basis may be divided into 5 groups according to their purpose and importance. You are interested in Infobases. Infobases are used to store the most important data, including configuration data, all enterprise business data, and administrative data. All the data related to a single Infobase is stored in a single database. Loss or corruption of any Infobase data may render a 1C:Enterprise-based system inoperable.

The Infobase is stored in a database as a set of tables. 1C:Enterprise 8 can use one of the five DBMS for this:

• Integrated into 1C:Enterprise 8 (file mode of an Infobase). In this case, all Infobase data is stored in a file named 1cv8.1cd. It is a binary file which is in fact a database for a DBMS that is integrated into 1C:Enterprise 8.
• Microsoft SQL Server (client/server mode of an Infobase). All Infobase data is stored in a Microsoft SQL Server database.
• PostgreSQL (client/server mode of an Infobase). All Infobase data is stored in a PostgreSQL database.
• IBM DB2 (client/server mode of an Infobase). All Infobase data is stored in an IBM DB2 database.
• Oracle Database (client/server mode of an Infobase). All Infobase data is stored in an Oracle Database.

The above means that you need to find out, which DBMS is used in your organisation and get the right driver for your connection.