Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Issue connecting Alteryx to 1C program database

Khalisaaliyeva
7 - Meteor
‎03-28-2023 01:06 AM

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!

Reply
0 Likes
1 REPLY 1
ArtApa
Alteryx
Alteryx
‎03-29-2023 08:25 PM

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.

Reply
0 Likes
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All