This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 92%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
Hi,
I want to Index entire database using cognitive search service and i want to fetch the data from DB using the index, my database contains nearly 18 tables for this can i create one index, datasource , indexer for the whole database or do i need to create separate index, datasource, indexer for each table, i am using free version i have limit of 3, i can create only three
@Gnana Sai krishna If the below reply answers your question, please consider accepting the solution by hitting the Accept as Solution as it helps the community look for answers to similar questions.
Regards
Geetha
You can use a view to consolidate data from multiple tables. Although large views aren't ideal for SQL indexer. You can also create a new table consolidating data from others that gets updated using Azure Data Factory, Change Data Capture, Change Tracking that table will exist just for ingestion into your Cognitive Search index.
Thank you, could you please provide any link related to view, how to use view in datasource, i am doing programmatically using javascript.